On Saturday, October 13, 2012 9:35:47 AM UTC-5, JCO wrote:
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

I think you will need a macro to loop thru the hyperlink ADDRESS