Finding Duplicate Data In Excel 2000

[Jchambers]

I am trying to find a way to Find and Group duplicate data in an Excel
spreadsheet. Is there a way to do this?

 

[Dave Peterson]

You could sort by the key field/column.

Then use some of the techniques at Chip Pearson's site:
http://www.cpearson.com/excel/Duplicates.aspx

 

[Jchambers]

I have tried that. I would like to Be able to query multiple columns and
still have the all of the information in the row associated with the findings.

 

[Dave Peterson]

Maybe just using data|filter|autofilter on the key field would be sufficient.

I have tried that. I would like to Be able to query multiple columns and
still have the all of the information in the row associated with the findings.