I could do that by listing the months over here, and then using a formula to get the results, but it would be way faster to use a pivot table. I’d like to see how many birthdays fall in each month. Here are the results from a survey, where a hundred people were asked for their birth month, and I’d like to see how many birthdays fall in each month.
Excel find duplicates in column and count full#
Here is the full transcript for the Count Duplicates with Pivot Table video, shown at the top of this post. You can use the workbook to follow along with the video. The zipped file is in xlsx format, with no macros. To get the sample file, go to my Contextures website – Count Duplicates With a Pivot Table. In that column, the pivot table shows the number of times that each month name appears in the survey results list.
Excel find duplicates in column and count how to#
In this short video, Sarah shows how to count the number of times each month name appears in the list.
How many times is each month name duplicated in the list? Instead of using a formula to figure that out, get the numbers quickly, in a pivot table. In this fake survey, 100 people were asked to name their birth month, and the list was entered on an Excel worksheet. No formulas needed with this Excel tip! See how to do this in the short video, and written steps, below. In Excel, use a pivot table to quickly count the duplicate items in a list.