Tuesday, December 22, 2009

Unique Values?

Hi Excel Team,

I have some data in a column suppose they are 1000 names. For example
Ramesh
Suresh
Mahesh
Dinesh
Priya
Kusum
Kusum
Ramesh
Suresh
Ravi
dinesh
priya
Shivnath
Ravi
.
..
Etc.

Now I want to know how many unique values are there in the column??? Plz help and explain the Formula...
Thanks