automatic make a colum with unique values

I didn't download your file. Try something like this...

Data in the range A2:A20

This array formula** entered in C2:

=IFERROR(INDEX(A$2:A$20,MATCH(0,IF(A$2:A$20<>"",COUNTIF(C$1:C1,A$2:A$20)),0)),"")

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

Copy down until you get blanks.

Hi

I left C1 empty

In C3 and below to get the list

=IFERROR(INDEX(A$3:A$1000,MATCH(0,INDEX(COUNTIF(C$1:$C2,A$3:A$1000&""),),0)),"")


Hope it helps

Hi Guys,

Thanks for the fast reaction.
I need my result in an othe tab How does the formule goes thenE?

Robert

@Giro
Here's a helpful tip. If you have the formula working in one tab, you can CUT and paste it to a separate sheet and all the changes necessary will automatically be made. I do this a lot especially when the sheet names are long and I don't want to go through the trouble of typing them all out. It has to be cut and not copied.

Hi,

in B3


=IFERROR(INDEX(Blad1!A$3:A$1000,MATCH(0,INDEX(COUNTIF(B$1:B2,Blad1!A$3:A$1000&""),),0)),"")

to be copied down.

Hope it helps

Ciao,

thanks for providing feedback.

Regards

Good deal. Thanks for the feedback!