View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JCO JCO is offline
external usenet poster
 
Posts: 54
Default Remove Duplicates (Macro)

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