View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mac Mac is offline
external usenet poster
 
Posts: 213
Default Finding duplicates in distinct ranges...

I have like 300 columns with 50 values in each and I want to find duplicates
accross these groups - e.g. number 23,5366 appears in group no. 23, in group
no. 45, in group no. 145 twice, etc. - and I needto get back the row
reference of these duplicates ( conditional highlighitng would sufice). How
can I achieve this?