Make unique list from a cells in one row

Hi everyone.
I need a solution for making a unique list for cells from one row.
In the pic C6:AP6 are some codes. I want to sort those codes with formula like shown in cells AR:AU. Advance filtering doesn't work in this case.

I tried to find answer on many pages and nothing. Pls help. Thanks in advance.

situation.gif

Originally Posted by Haseeb A

If C6:AP6 is a valid numbers, enter in

AR6,

=MAX(C6:AP6)

In AS6,

=LARGE($C6:$AP6,1+COUNTIF($C6:$AP6,">="&N(AR6)))

Then copy AS6 to AT6

This sounded like a good solution, but when I tried to execute formula 'the formula you typed contains an error' pop-up.
The thing is in the future I will input some different working codes in this table, and it would be great that some formula recognize this entry and index it in the green colored cells. By now I have input 3 working codes that would be great to be indexed as a unique entry making it a unique list of working codes that appears in 'radni nalog' column.

Here is the example table
example table.xlsx

You can put this array* formula in cell AQ1:

=IFERROR(INDEX($E$1:$AO$1,MATCH(0,IF($E$1:$AO$1<>"",COUNTIF($AP$1:AP1,$E$1:$AO$1),1),0)),"")

and then copy it across (e.g. to AV1). It will give you unique values from the range E1 to AO1, ignoring blanks.

*An array formula must be committed using the key combination of Ctrl-Shift-Enter (CSE) instead of the usual <Enter>. If you do this correctly then Excel will wrap curly braces { } around the formula when viewed in the formula bar, but you must not type these yourself. If you need to amend the formula subsequently, you must use CSE again.

Hope this helps.

Pete

Originally Posted by Haseeb A

See the attached.

This will give all the unique NUMBERS entered in B1:AO1 in descending order.

Very good, very elegant. I'm charmed and happy because this solves my problem :D
Thank you all for helping me with this (for me) mind blowing puzzle!