Small function with a arithmetic calculation

[max333]

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

=SMALL(--Left(Int(F5/10),int(g5/10),int(h5/10),int(i5/10),int(j5/10),int(k5/10))),{1,2,3,4,5,6})

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.

[max333]

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.

[Root_]

Maybe

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

[max333]

Wonderful! it works like charm. thanks, Root!

[Root_]

You are welcome.