View Single Post
  #1   Report Post  
Spyder
 
Posts: n/a
Default How do I identify dulicate rows in a spreadsheet?

I have a spreadsheet with over a thousand rows. That sheet contains five
columns. I am doing an average on column 5, but have some duplicates. I
want to identify those duplicates so that I can eliminate them. If columns
1, 2 and 3 are the same for any of the rows, the row(s) is a duplicate. Is
there an easy way to identify these duplicates quickly, using a function or
pivot table?

Thanks for any help!!
Jeff