Have a look in Help at COUNTIF then come back if you need more.
best wishes
--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address
"JN" wrote in message
...
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!