Forum Discussion
DUPLICATES WILL BE SINGLE
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?
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?
=IF(COUNTIF($A$1:A1,A1)=1,A1,"")
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.
