Hello!
I'm new here and not very good in english so I hope I will explain my problem well.
Generally, I need an array formula to sort table by numbers. Let's say I have numbers in cells (A1:A15) and text in cells (B1:B15), and need to sort table (A1:B15) by numbers in column (A1:A15) using dynamic array formula. I found a formula for sorting numbers only, but can't figure out how can I sort associated text also.. Array formula for sorting numbers would look like this:
(I choose cells C1:C15 and write folowing formula in formula bar)
=SMALL(A1:A15;ROW(INDIRECT("1:"&ROWS(A1:A15))))
(Then I press ctrl+shift+enter to add array formula)
I get sorted column (A1:A15) in cells (C1:C15), but I need to get column (B1:B15) in cells (D1:D15) also, sorted by numbers from (A1:A15)
I would be very gratefull if someone could help me to figure out how can I include text from (B1:B15) into that dynamic sorting array formula!
Best regards
Bookmarks