Hi,

I have a data set in excel and it has about 1000 projects each assigned to a
person (name).

Some times more than one projects are assigned to the same person (name).

I want to know how many times does any name appear in the list. I know I
could use auto filter nad count each the frequency of each specific name but
that is a manual process and takes too long.

Is there a way to just count the number of times a name appears in the data
set (column)?

Please help.

Thanks
Rum