View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dendy Dendy is offline
external usenet poster
 
Posts: 15
Default Duplicates Excel 2000

=IF(NOT(G2=G3), "No Duplicate")

I am using the above formula with a huge list. I have false on one of the
duplicates but would like to have false on both duplicates as I want to sort
all the false ascending to remove them at one time.

Thanks Linda