| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| correct syntax for nesting "if", "and", and "vlookup"....if possib | Excel Worksheet Functions | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Threaded Mode
