| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Duplicated Names In List
Hello all !! I have in column A list of over 1,000 names. In this list the names are duplicated. How can I filter/retrieve or modify this list to have all the names but not duplicated. You help is greatly appreciated. MIK -- mik00725 ------------------------------------------------------------------------ mik00725's Profile: http://www.excelforum.com/member.php...o&userid=16169 View this thread: http://www.excelforum.com/showthread...hreadid=534639 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Duplicated Names In List
DataFilterAdvanced Filter.
"Unique records only" and "Copy to a new location". Gord Dibben MS Excel MVP On Thu, 20 Apr 2006 11:00:30 -0500, mik00725 wrote: Hello all !! I have in column A list of over 1,000 names. In this list the names are duplicated. How can I filter/retrieve or modify this list to have all the names but not duplicated. You help is greatly appreciated. MIK |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Spreadsheet from Access. List of names changes as names are | Excel Discussion (Misc queries) | |||
| filter 400 names from list 1 from list 2 with 4000 names | Excel Worksheet Functions | |||
| create a list of worksheet names (from a single folder, or open files) | Excel Discussion (Misc queries) | |||
| how do i print a list of names and dates in excel into a two-colu. | Excel Discussion (Misc queries) | |||
| Setting up a random list from long list of names ? | Excel Discussion (Misc queries) | |||
Hybrid Mode
