Skip to content

Highlight and Count Duplicate Rows In Excel | Highlight Duplicate Rows in Excel Except First

    In this Microsoft Excel video tutorial I demonstrate how to highlight and count duplicate rows in your data. This can include or exclude the first occurrence. Click here to download the featured file. Video Table of Contents 00:00 – Introduction 00:03 – Concatenate the values in each row 01:02 – Count the number of occurrences… Read More »Highlight and Count Duplicate Rows In Excel | Highlight Duplicate Rows in Excel Except First

    How to Create Automatic Subtotals in Excel | Nested (Multiple) Subtotals | Group Rows & Subtotal

      In this video tutorial I explain how to quickly and easily group rows and create automatic subtotals. I also demonstrate how to create nested subtotals based on grouping in multiple columns. Click here to download the featured file. Video Table of Contents 00:00 – Introduction 00:04 – Group and create subtotals for one column 01:11… Read More »How to Create Automatic Subtotals in Excel | Nested (Multiple) Subtotals | Group Rows & Subtotal

      Show / Hide Rows or Columns Based on Drop-Down Selection | Pick Table From Drop-Down List

          In this video tutorial I demonstrate how to show/hide rows or columns or tables based on a drop-down list selection. This particular technique requires VBA code which I supply via the link above. Click here to download the featured file (including code). Video Table of Contents 00:00 – Introduction 00:49 – Create the data… Read More »Show / Hide Rows or Columns Based on Drop-Down Selection | Pick Table From Drop-Down List