Counting the frequency of multiple values within a column

[guilbj2]

I have a sheet setup with hundreds of names in a column where the name
will repeat from time to time (they are names associated with each fil
listed in another column). What I need to do is find out ho
frequently each of the names appears. Due to the huge volume o
different names, I'd much rather not use hundreds of countif statement
to check how many times each name appears. Does anyone know a
efficient way to tally how many times each value appears

 

[Frank Kabel]

Hi
use a pivot table for this:
- use the column with your words as row item
- use 'countof word column' as data item

 

[AlfD]

Hi!

Have a look at subtotals

Al