View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Bob is offline
external usenet poster
 
Posts: 972
Default mark duplicate entries

I have multiple rows of data with eight columns (A1:H1). I would like to be
able to find which rows are duplicated in column A, D, E and G.
I know I can sort these by and separate any data that doesn't match but I
would like to work with something a little more quicker.