A
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
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