Posted 15 July 2008 - 06:55 PM
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
where A2 to A11 is the range where the names occur