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

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