Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find, Filter and Paste Duplicates
In Excel 2007 -
I have two Spread Sheets. Both have a column with 'City' names. How can I get a resultant list of unique 'Cities' in a new sheet listed alphabeticaly? e.g. Sheet 1 Sheet 2 Sheet 3 A1 A1 A1 New York Rome London New York Paris Madrid London Madrid New York Rome New York Paris Rome Thanks -- Confusion will be my epitaph... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find, Filter and Paste Duplicates
Can you copy all of the ranges to one worksheet? Then you could just
use Advanced Filter to get a list of unique values. http://www.contextures.com/xladvfilter01.html#FilterUR HTH, JP On Apr 4, 6:48*pm, Appalachia wrote: In Excel 2007 - I have two Spread Sheets. Both have a column with 'City' names. How can I get a resultant list of unique 'Cities' in a new sheet listed alphabeticaly? e.g. Sheet 1 * * * * * Sheet 2 * * * *Sheet 3 A1 * * * * * * * * *A1 * * * * * * * *A1 New York * * * *Rome * * * * * London New York * * * *Paris * * * * * *Madrid London * * * * * Madrid * * * * *New York Rome * * * * * * New York * * *Paris * * * * * * * * * * * * * * * * * * * * *Rome Thanks -- Confusion will be my epitaph... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter out duplicates | Excel Discussion (Misc queries) | |||
Show duplicates in cell for filter | Excel Discussion (Misc queries) | |||
Filter for duplicates | Excel Discussion (Misc queries) | |||
Find Duplicates | Excel Discussion (Misc queries) | |||
Find duplicates | Excel Discussion (Misc queries) |