Thanks for your answer. Sorry it took so long for my reply. My newsgroup
was not in Conversation mode. I did not realized people responded. Thanks
again. Works great.


"plinius" wrote in message ...

Il 13/10/2012 16:35, JCO ha scritto:
Using Excel 2007.
I need to be able to select a series of cells in a single column and
count the unique data (no duplicates). The existing cell format is
"General". Currently each cell is a hyperlink in the format shown below:
1-2323456
1-4345356
1-5454232
1-2323456

If these cells are selected, the answer should be 3 (because top and
bottom are the same).
Thanks


=SUMPRODUCT(1/COUNTIF(A1:A4,A1:A4))

E.