View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joel joel is offline
external usenet poster
 
Posts: 9,101
Default finding "Like" names in rows

I am trying to filter a list of 5000 names of different items, where there
are "like" names in different rows. I need to be able to show/delete the
like duplicate ones. So in the names below I would like to search on first
name and if same, then delete the dups. i.e.
INGRAM BARGE CO INC
INGRAM BOOK CO
INGRAM BOOK GROUP INC
Ingram Industries
INGRAM INDUSTRIES INC
INGRAM MICRO INC
International Paper
INTERNATIONAL PAPER CO


After this search, I would like to see only 2 entries.
I