Copper Contributor
I entered in A1 Petrol, A2 Diesel, A3 Oil, A4 Gas, A5 Petrol, A6 Oil, A7 Electricity, A8 Water, A9 Gas, A10 Lpg.
Now I want all names from A1 to A10 will be I can see in another cells but all names will be show only 1 time (i.e., duplicates will be single).

Which formula will I use?
1 Reply




Maybe with above formula. With Office365 or 2021 you can apply UNIQUE formula. In older versions of Excel you can use data -> remove duplicates as well.