Need to get a list of names from a collumn

[Taislin]

Hi. I have a workbook with a collumn full of football championships. As you know there are hundreds of different championships names. And i have a collumn with all of them but some are repeated over and over because this collumn is connected with values of profit/loss in another collumn. For example: Blue Square North (Collumn A1) and in collumn B1 1.75; then Blue Square North (Collum A2) and 2.98 (Collumn B2), and over and over...

So what i need is a formula that retrieves all unique and different names in a range collumn and the puts all the dfferent names in a new collumn (lets say C). Because what i intend to do then is to use vlookup to search for the championships one by one (through collumn C) and count the ones with profit and them loss by the name of each one.

So what i need is a way to retrive a list of the unique names in A and get them in C.
Is this possible?
Thank you.

[Pepe Le Mokko]

You can create a list of unique names by copying your list to col C than after selecting the column go to the Data ribbon - Remove Duplicates Tool

[Taislin]

Need to say to myself - daah lol
Thank you for your reply. After i wrote the post i started to think... "what about remove the duplicates?" - then i realised the simple it was.
Thank you

[Fotis1991]

Give a try to this.

In C1, put this.

=IF(A1="","",A1)

In C2 and copy down, this one.

=INDEX(A$1:A$1000,MATCH(1,INDEX((COUNTIF(C$1:C1,A$1:A$1000&"")=0)*(A$1:A$1000<>""),0),0))


=IFERROR(INDEX(A$1:A$1000,MATCH(1,INDEX((COUNTIF(C$1:C1,A$1:A$1000&"")=0)*(A$1:A$1000<>""),0),0)),"")

I think in Portugal you use Semi colons(like us in Greece) as separators in formulas. If so pls change ALL commas in my formula to semi colons.

[Taislin]

@Fotis1991

Thank you fotis. i though about an index formula but didnt know how to built it. I'll try it too, but i think it might slowdown the workbook which is already heavy. But i'll try it anyway. Yeah in Portugal we use semicolons too. I'm already used to convert the formulas. Thank you anyway for the advice. Thank you also for your reply. Regards.

[Fotis1991]

.............................