first 6 unique numbers in row

palaeontology

Active Member
Joined
May 12, 2017
Messages
371
Office Version
  1. 2016
Platform
  1. Windows
Hi,

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

<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
 

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

StephenCrump

Well-known Member
Joined
Sep 18, 2013
Messages
3,801
Office Version
  1. 365
Platform
  1. Windows
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

Active Member
Joined
May 12, 2017
Messages
371
Office Version
  1. 2016
Platform
  1. Windows
of course, embarrassed i missed it.

Thankyou for solving that,

Kind regards,

Chris
 

Watch MrExcel Video

Forum statistics

Threads
1,109,001
Messages
5,526,203
Members
409,686
Latest member
Tori83

This Week's Hot Topics

Top