View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bill in Wichita Bill in Wichita is offline
external usenet poster
 
Posts: 1
Default How can I find duplicates in one column of an exel spreadsheet?

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.