Thread: Remove Duplicates (Macro)
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
John Black John Black is offline
external usenet poster
  
Posts: 9
Default Remove Duplicates (Macro)
In article , says...

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))

I don't really get how this works?

John Black
Reply With QuoteReply With Quote