DUPLICATES WILL BE SINGLE

[mayank_rathi]

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?

[#2]

@mayank_rathi 

=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.