first 6 unique numbers in row

[palaeontology]

Hi,

I have the following numbers in range AS133:BD133 ...

10

23

2

2

23

97

58

23

9

54

78

23

<tbody>
</tbody>

I would like to return the first 6 unique numbers from that list into the range BF133:BK133
I'm currently using the following formula in BF133 and dragging across ...

=INDEX($AS$133:$BD$133,MATCH(0,INDEX(COUNTIF($BF$133:BF133,$AS$133:$BD$133),0,0),0))

Unfortunately, instead of returning these 6 unique numbers ...

10 23 2 97 58 9 .... it's returning zero in all 6 cells

Can anyone see the error in my formula ?

Kind regards,

Chris

 

[StephenCrump]

Your formula refers to BF133, so if you put it in cell BF133 you'll get circular references and zero values.

Change $BF$133:BF133 to $BE$133:BE133

 

[palaeontology]

of course, embarrassed i missed it.

Thankyou for solving that,

Kind regards,

Chris