| 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... |
| 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) | |||
Threaded Mode
