Converting Order to single digit.

[serge]

Im looking for a formula that will return those 5 digits 1,2,3,4,5 by giving me the order from the smaller to the bigger number from row B3:F3 and when there are duplicate, it would read the duplicate from left to right.

Row B3:F3 is 1,1,15,5,6 which will return the digits : 1,2,4,5,3
Row B4:F4 is 0,10,5,5,5 which will return the digits : 1,3,4,5,2

[/URL][/IMG]

Thank you.
Serge.

 

[Tetra201]

Try the following:

- Select range H3:L3
- In the formula bar, type or paste =HLOOKUP(SMALL(B3:F3+0.001*{1,2,3,4,5},{1,2,3,4,5}),CHOOSE({1;2},B3:F3+0.001*{1,2,3,4,5},B$1:F$1),2,0)
- Press and hold Ctrl and Shift, then press Enter
- Drag-copy range H3:L3 down as needed

 

[serge]

Wow, very nice, it's working perfect, thank you very much Tetra201, really appreciate it.
Serge.