How do I copy information from a column in googlePlanillas without repeating data if they have repeated data?

Question

i have a spreadsheet in which a column contains names, I need to copy this data to another column, but without copying the repetitions of the names, example:

Coluna A       Coluna C
Américo        Américo
Mauricio       Mauricio
Bruno          Bruno
José           José
Mauricio       Marta
Marta
Bruno

I found a formula on the Internet, but it doesn’t work, it follows the formula =INDEX ($A$2: $A$10, MATCH(0, COUNTIF ($C$1: C1, $A$2: $A$10), 0))

Someone knows how to help me?

Answer 1

Use the function:

UNIQUE

In your case the use would be as follows:

=UNIQUE(A2:A)