|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 18th, 2009, 04:58 PM
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
November 18th, 2009, 07:09 PM
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?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
