Formula help return number once only

[zone709]

Hi,

Trying to do a formula to return number only once.

Example
Staring from row A2

I have going down an more.
A
10
10
10
20
20
29
29

Trying to return in AN only one number at a time.
AN
10
20
29
like that anyway formula would do this ?

 

[Fluff]

In AN2 try
=IFERROR(INDEX(A$2:A$32,MATCH(0,INDEX(COUNTIF(AN$1:AN1,A$2:A$32),0),0)),"")

 

[zone709]

works great thanks for the help

 

[Eric W]

Another option for AN2:

=IFERROR(SMALL($A$2:$A$32,COUNTIF($A$2:$A$32,"<="&MAX($AN$1:$AN1))+1),"")

 

[zone709]

Hey guys thanks for the reply. I just ran into something simliar and tried these formulas but didnt work.

In column B I have names that are the same but only want to return one name at a time like the numbers I did without taking in duplicates.

Any help on this thanks

 

[Fluff]

Just change the A ranges to B & the AN to your new column

 

[Eric W]

The formula I provided in post 4 only works on numbers, but Fluff's should work for text as well as numbers.

 

[zone709]

I did but the first name keeps pulling in the same name all the way down. I am leaving now i will check tomorrow. Thanks fro the reply.