palaeontology
Active Member
- Joined
- May 12, 2017
- Messages
- 444
- Office Version
- 2016
- Platform
- Windows
Hi,
I have the following numbers in range AS133:BD133 ...
<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
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