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... |
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... |
All times are GMT +1. The time now is 09:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com