Excel 2007 - extracting duplicate names

C

Cheri

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?
 
G

Gord Dibben

Data>Filter

Text Filters>Contains Fred

F5>Special>Visible cells only.

Copy to another sheet or area.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Duplicate Names by factor of 4 4
Contact Records-extracting contact names to linked table 9
Extract Middle Initial from Name 10
Using VLOOKUP to display required information 1
Lookup latest entry 1 5
Lookup latest entry 3
pulling select names by codes? 1
Impossible query? 3

Top