Forum Discussion
Count multiple names in a column
I need to get a count of how many times the same email address appears in a column; but not just the one email address, over 1,000 email addresses that total over 80,000 rows. I need a count for eac...
One option is to create a pivot table based on the data. Add the email field to both the Rows area and the Values area.
If you have Microsoft 365, you can also use the new PIVOTBY function: