I need to know how to make excel display a count of all the same records in table. So for example Column Z has 86000 Entries and i want to a count of all the items that are the same throughout the column.
If i have 1000 entries of Robert-123-#$%-Was-Her3 - I would like to be able to select just those and also get a count.
I dont know much about excel except for basic filtering so pelase be extra clear on how i might do this.
Thanks in advacne!!