Sorry if the title didn't say it all.
I have a probelm which I can't seem to solve.
I have a list called "DATA" and in column A I have countries (Sweden, USA, France and so on) and in column B I have Citys for these countries (For USA It could be New York, Miami and so on) and in column C I have street names in this cities. Each country, city and streetname can appear several times in the list. If column A is USA the city in column B will alway be a US city and same goes for column C (will be a steet in the city in column B in the country in column A).
I then need to create another list base on the "DATA" list (in another sheet). This list needs to look in "DATA" list in column A and write in all unique entries (all countires in the list)
Like this:
Country
USA
Sweden
France
Column B need to list all the unique entries in column B for the value in B1 (USA in this case which is liked to A2 of cause)
Like this:
USA
New York
Miami
Las Vegas
Column C need to list all the unique entries in column C for the value in C1 (New York in this case which is liked to B2 of cause)
New York
Ann street
Fulton street
Perry street
Is this possible without VB programming? This would help me massivly!!
/Per
I have a probelm which I can't seem to solve.
I have a list called "DATA" and in column A I have countries (Sweden, USA, France and so on) and in column B I have Citys for these countries (For USA It could be New York, Miami and so on) and in column C I have street names in this cities. Each country, city and streetname can appear several times in the list. If column A is USA the city in column B will alway be a US city and same goes for column C (will be a steet in the city in column B in the country in column A).
I then need to create another list base on the "DATA" list (in another sheet). This list needs to look in "DATA" list in column A and write in all unique entries (all countires in the list)
Like this:
Country
USA
Sweden
France
Column B need to list all the unique entries in column B for the value in B1 (USA in this case which is liked to A2 of cause)
Like this:
USA
New York
Miami
Las Vegas
Column C need to list all the unique entries in column C for the value in C1 (New York in this case which is liked to B2 of cause)
New York
Ann street
Fulton street
Perry street
Is this possible without VB programming? This would help me massivly!!
/Per