# Converting Order to single digit.

#### serge

##### Well-known Member
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.

### Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
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

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

Replies
1
Views
162
Replies
1
Views
171
Replies
1
Views
161
Replies
6
Views
515
Replies
6
Views
292

1,203,600
Messages
6,056,206
Members
444,850
Latest member
dancasta7

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back