View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mac Mac is offline
external usenet poster
 
Posts: 213
Default Extracting duplicates with row ref's to a list

I have a column of some 10.000 values with duplicates highlighted; now, I'd
like ot have all of these duplicates ( not just a list of distinct values)
stored to list with a row reference of each (in a neighbouring column, for
example). Does anyone have an idea?