Bill

If you just want to identify them and we'll say they are in A1:A2000 then in
a spare column alongside enter

=COUNTIF($A$1:$A$2000,A1)

and copy down

This will give you the number of times they appear in the list and you can
autofilter or sort on that

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Bill in Wichita" <Bill in wrote in
message ...
I have a spreadsheet with over 2000 rows of data I would like to quickly
isolate those with duplicate names or phone numbers. Can I do this in
Filter?
I know I can eliminate duplicates but I want to find them.