I have a table imported from Access as follows:
CITY..........SURNAME........VALUE
London..........Jones.............30
London..........Aria................20
Newcastle......Aria................10
London..........Hendry............50
Newcastle......Harrison..........50
Manchester....Gio.................30
I would like to display a unique list of SURNAME based on CITY.
For Example:
If A2 in a spreadsheet says "London"
Show dynamically in Cell B5, B6 and B7 horizontally, the values "Jones", "Aria" and "Hendry"
If A2 in a spreadsheet says "Newcastle"
Show dynamically in Cell B5 and B6 horizontally, the values "Aria" and "Harrison"
If A2 in a spreadsheet says "Manchester"
Show dynamically in Cell B7 horizontally, the values "Gio"
If A2 in a spreadsheet says "TEST"
Show dynamically in Cell B5 horizontally, nothing.
How can I achieve this in Excel 2010? Any help is greatly appreciated.
Bookmarks