Small function with a arithmetic calculation

I am looking for a way to use small function in this manner :

Please Login or Register  to view this content.

This is wrong, it doesn't work. I write it to explain what I'm trying to do only.

The values in range F5:K5 first divided by 10 and then, then the first digit of the divisions are taken by left function, and then the output numbers are sorted in ascending order.

Example : if F5:5 ---> 5/10 =0,5 ---> 0
if G5:70 ---->70/10 = 7 ---->7

with small function it will be : 0, 7


Thanks.

I am also open to other formulas if there is any. Basically, I want excel take the first digits of numbers and order them with small function. but I have problem with one digit numbers, I want small function to take 0 as the first digit number when there is a one digit number in the cell.

Maybe

=SMALL(--LEFT(INT(F5:K5/10)),{1,2,3,4,5,6})

Wonderful! it works like charm. thanks, Root!

You are welcome.