Hi
I've got a list of repeated addresess in column A of a spreadsheet.
But I need to return a unique consecutive list of the addresses in column A, into column G.
In the simple list below, I have 4 countries (England, Japan, Canada and the USA) listed 3 times each. So there are 12 rows in column A, with the countries starting in cell A2.
However, I need to put a formula in column G2 which will list the unique countries and show the results in the 'Unique List of Locations' in column G below.
I'll also need to be able to clear the data from row 3 and below, the be able to drag down the formula in column G when new data is put into the file.
Does anyone know how to do this, please?
I've got a list of repeated addresess in column A of a spreadsheet.
But I need to return a unique consecutive list of the addresses in column A, into column G.
In the simple list below, I have 4 countries (England, Japan, Canada and the USA) listed 3 times each. So there are 12 rows in column A, with the countries starting in cell A2.
However, I need to put a formula in column G2 which will list the unique countries and show the results in the 'Unique List of Locations' in column G below.
I'll also need to be able to clear the data from row 3 and below, the be able to drag down the formula in column G when new data is put into the file.
Does anyone know how to do this, please?
Locations | Unique List of Locations | |||||
England | England | |||||
England | Japan | |||||
England | Canada | |||||
Japan | USA | |||||
Japan | ||||||
Japan | ||||||
Canada | ||||||
Canada | ||||||
Canada | ||||||
USA | ||||||
USA | ||||||
USA |