Find, Filter and Paste Duplicates

[Appalachia]

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

 

[JP]

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