How do I compare rows where there are 30+ columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet with 50,000 + rows and columns A through DF. I would
like to look at each row as a record and return only rows where all the
columns are exactly the same.
 
Look at Data/Filter/Advanced Filter and check the Unique Records box. Check Help for more
info if you need it.
 
Back
Top