When faced with this problem, I use Jim Cone's fine commercial add-in called
XL Companion. It's available at
http://www.realezsites.com/bus/primitivesoftware/
Vaya con Dios,
Chuck, CABGx3
"ChuckF" wrote:
Could anyone please help me with a formula that would count how many
unique entries are in a given range of cells. All I need to know is
how many different entries there are. (Not including empty cells)
So if I have A2:A20,
A2 Hello
A3 Goodbye
A4 Hello
A5 Cya
A6 L8R
A7 Hello
A8 Goodbye
and so on and so on...I want a formula to tell me that there are 4
different entries.
Any help would be great!