| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 - extracting duplicate names
Does anyone know how I can accomplish the following task?
I have a spreadsheet that I need to extract duplicate names and all other items associated with the duplicate names . Example: Case # Claimant 123456 Fred T 78910 Fred Thompson 2345 James 8911 John How would I pull all variations of "FRED" and corresponding case #'s for Fred? -- Thank you, Cheri T |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2007 - extracting duplicate names
DataFilter
Text FiltersContains Fred F5SpecialVisible cells only. Copy to another sheet or area. Gord Dibben MS Excel MVP On Wed, 18 Nov 2009 08:58:06 -0800, Cheri wrote: Does anyone know how I can accomplish the following task? I have a spreadsheet that I need to extract duplicate names and all other items associated with the duplicate names . Example: Case # Claimant 123456 Fred T 78910 Fred Thompson 2345 James 8911 John How would I pull all variations of "FRED" and corresponding case #'s for Fred? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extracting data in Excel 2007 | Excel Discussion (Misc queries) | |||
| extracting names, shifts dept from excel worksheet | Excel Worksheet Functions | |||
| How do you delete duplicate addresses, but keep duplicate names? | Excel Discussion (Misc queries) | |||
| subtracting (extracting non-duplicate items)HELP!! | Excel Worksheet Functions | |||
| Extracting the Duplicate Records | Excel Discussion (Misc queries) | |||
Linear Mode
