ExcelBanter - Excel 2007 - extracting duplicate names

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel 2007 - extracting duplicate names (https://www.excelbanter.com/excel-discussion-misc-queries/248750-excel-2007-extracting-duplicate-names.html)

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

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?