| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel seach
I have an excel sheet with 5000 entries - much of which are duplicates. Is
there a way to pull only one line/name/address from each set of duplicates without going through and doing it one by one? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
excel seach
You can use Advanced Filter to extract duplicates - Debra Dalgleish
shows how he http://www.contextures.com/xladvfilter01.html Hope this helps. Pete On Jun 27, 9:59*pm, Excel-lent Novice <Excel-lent wrote: I have an excel sheet with 5000 entries - much of which are duplicates. *Is there a way to pull only one line/name/address from each set of duplicates without going through and doing it one by one? * |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| function to seach directory for file location | Excel Worksheet Functions | |||
| Inserting a string seach within a complex function | Excel Worksheet Functions | |||
| seach and replace '(' with an '/' | Excel Discussion (Misc queries) | |||
| Excel Forumla to seach and return all values | Excel Worksheet Functions | |||
| Seach Column and return multiple dates to another worksheet? | Excel Worksheet Functions | |||
Linear Mode
