BleepingComputer.com: Ms Excel 2000 - Calculate Amount Of Times Names Appear On A List?

I need to take a list of names from a worksheet and assess how many times each person appears on it. This is a long list with duplicate names down the same column.

It sounds easy enough but I just can't find out how to do it.

Any help you can give would be much appreciated.

Not much information to go on in your post.
So I'm guessing as follows:
You have a worksheet. In that worksheet JOHN appears x number of times, TERRY appears y number of times, is that guess about right?
All the names are in one column. Is that right?
If not, you have to provide more description.

If yes, a filter can help a lot without any fancy formulas.
Click Data, then Fileter, then AutoFilter on the column heading
[I assume you have a column headning such as Name above all the data]
Filter for the name on the dropdown list
Now look on the status line at the bottom.
Do you see a count?
If not, right click it, and select count.
It'll tell you how many.

If you can't use the filter, and must have a formula, assuming your names are in column A, the counting formula will be
=COUNTIF(A2:A11,"John")
where A2 to A11 is the range where the names occur

That's just what I was after.

I knew how to use the autofilter, but the COUNTIF statement was definitley the thing I needed.

Many thanks

You are too kind.

Whoooopeee! Great. Thanks for the feedback.