HI Peo and Pete,
Thank you for responding so quickly!

My result using Peo's formula was 6. My formula gave me 6 also but I needed
a list of the actual names without doing the auto-filter as Pete suggested.

thoughts? jane

"Peo Sjoblom" wrote:

Use this instead

=SUMPRODUCT((B5:B15<"")/COUNTIF(B5:B15,B5:B15&""))


that will not return an error if all cells are empty


You can use advanced filter which has a built in way, select the list, then
select unique records only then copy to another location. Excel 2007 has a
built in method for this called remove duplicates



--


Regards,


Peo Sjoblom


"jane" wrote in message
...
here is my data:
Mary
Sally
Sally
Mary
John
John
David

I used the following to COUNT the unique values:
=SUMPRODUCT((B5:B15<"")/COUNTIF(B5:B15,B5:B15))

What can I do to get a list that REPORTS the unique data - my result
should
look like this:
Mary
Sally
John
David

thanks in advance! jane