Absolutely perfect! Thank you Thank you Thank you!

"Ron Rosenfeld" wrote:

On Fri, 24 Aug 2007 12:28:03 -0700, JN wrote:

I have a column with text and blank cells. I need a formula that will not
only retrieve the names of the unique text values but also give me a count
how many times they appeared. Example:

Col A
[blank]
Apples
Pears
[blank]
Apples
Oranges

Apples 2
Pears 1
Oranges 1

It could be in 2 different columns...

Thanks in advance!

Although not a formula, you could use a pivot table to list both the unique
entries and their count.

You could also use the advanced filter to list the unique entries, and countif
to get the count.

You could also sort your data, then use the subtotals wizard to get a count of
each item.
--ron