Count occurances without knowing the objects

[erison]

Hi all. Hope I found the correct section. I have a problem which hits me now and then. Let's say I have a list of 1000 names. I want to count how many times each time occurs. Quite easy with a countif, but my before that I have to analyze which names the list actually consists of. (Theoretically, it could be the same name reaeated 1000 times or 1000 unique names with one occurance each.) This part I have no idea how to do. I guess I have to run it through with VBA in some way to gereate a new sheet with the names that the list consists of. After that I can do a countif. What do you say, what's the easiest way?

Thanks in advance!

[Ron Coderre]

If you use a pivot table, it can list each unique name and the count of each name.

Is that something you can work with?

[mcmahobt]

Say your list starts in A1 and fills downward through column A. If you put in B1:

Please Login or Register  to view this content.

and drag down, wherever a 1 occurs is a unique occurrence of that name.

[erison]

Fast answers, nice
@Ron Coderre, I have never used pivot tables but after some youtubing and testing, yes that seems to solve my problem!
@mcmahobt. Doesn't really work for me as the cell gets a 1 the first time tha name comes up, a 2 the second time and so on. I would like a list where every unique name is just one one row. Please let me know if I didn't understand you right!