Sorting with a formula

[Evolta]

Hey there,

After working with excel for a while, handling things without any problems... I came to a new problem.
I have values in 5 columns and 10 rows.

I want to sort the values in column 2. (at the moment they contain. 0-0-0-0-0-0-1-2-0-2.
column 1, should move accordingly.
- the other colums are based on formulas, so thats not a problem

So... it should not be that difficult,.. but I cannot get it done -.-
It does not even matter what value 2 or value 0 is taken first

I'll try uploading an example in a bit.
example.xlsx

[samba_ravi]

B18=INDEX(B$4:B$13,MATCH(LARGE(INDEX($C$4:$C$13+(10^-8)/ROW(C$4:C$13),0),ROW(A1)),INDEX($C$4:$C$13+(10^-8)/ROW(C$4:C$13),0),0))
try this and copy across

[Evolta]

Great :D I just figured out myself how to sort the column itself with large, but was not sure how to go on from there.
Translated it to dutch and replaced the , with ; and it works wonderful.

What I do not understand yet is why you add 10^-8 (in $C$4:$C$13+(10^-8))
Is that to convert it to a number but since its a pointlessly small number it doesn't change anything?


-edit-.. ow wait... I simply do not understand that index part at all, give me a while

[Evolta]

Correct me if I'm wrong...
Took me a while to see what was going on... But INDEX($C$4:$C$13+(10^-8)/ROW(C$4:C$13);0) adds a very small number to each cell.
Since its a number <1 (and very small since it should not influence the results) and devision is used, it makes sure the ranking is maintained top down.

So I think I figured out why,... now I'll try to really understand the how so I can reproduce these kind of formulas

-edit-
got it hopefully I can help other with this