Hi Don

I do not know why, but I just couldn't get your formula to work. However, I
eventually got what I wanted by using the Pivot Tabel idea from 'Gary"s
Student'.

Many thanks anyway for taking the time and effort to help. It was much
appreciated.

Thank you.

"Don Guillett" wrote:

Put the formula in any blank column that you desire. Then use the grab
handle and drag down. The grab handle can be had by going to the bottom
right of the cell with the formula where there is a small square. Grab this
with your mouse and drag down the column to the end of where your list of
names is. Got it?
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Popey" wrote in message
...
Hi Don

You don't explain where I put the "=COUNTIF($F$2:$F$22,D2)" forumula!
What do you mean by "Copied Down"?


"Don Guillett" wrote:

A simpler way. Make a list of your clients in col D and use this copied
down. Then sort.
=COUNTIF($F$2:$F$22,D2)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Popey" wrote in message
...
Hi Don

Many thanks for your reply, and I appreciate your help, but I have to
confess - your reply made no sense to me whatsover. Sorry :(

"Don Guillett" wrote:

Assuming your customer names in col F. One way is to use this in col G
and
copied down.
=COUNTIF($F$2:$F$22,F2)
Sort or
Then use match to find the row in that column and find the name it
applies
to.
=INDEX(F2:F22,MATCH(LARGE(G2:G22,1),G2:G22,0))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Popey" wrote in message
...
Hi

Here's one for you Excel forumla wizards:

Using Excel 2007 -

I have a list of customer names in Column C of a customer database I
have
created, some names are repeated as they are frequent customers. Is
there
a
(hopefully simple) formula that would automatically search column C
and
tell
me how many times each customer has appeared in that column, thereby
allowing
me to readily see which customers return the most?

Very many thanks.