Filter out records

[Grey]

I have thousands of records in excel where some records are duplicated with
one field. How can I retrieve the duplicate field record in another
worksheet??

Million thanks.

 

[Dave Peterson]

I don't quite understand your question, but Chip Pearson has a bunch of
techniques for working with duplicates at:
http://www.cpearson.com/excel/duplicat.htm