Sorting a Number

Question

Hello Everyone,I want to arrange the list of amounts in such a way that, $48 comes in the first place and $24.78 goes to the last, basically I want to reverse the list.&nbsp;It should be result come like this with the help of Formula -&nbsp;&nbsp;So, what formula should i apply?Please help..I am using Microsoft Office 2016&nbsp;&nbsp;Here is a attached file...&nbsp;&nbsp;

lorenzo · Answer

Hi&nbsp;Excel&nbsp;&nbsp;Assuming numbers &amp; no blanks in A1:A17 (edited):&nbsp;&nbsp;=IF(ROW()-ROW(A$1) = 0,
    A$17,
    IF(ROW()-ROW(A$1)+1 = ROWS(A$1:A$17), A$1, A1)
)

excel · Answer

Sir can you please explain the formula?Please..??

riny_van_eekelen · Answer

Excel&nbsp;The screenshot does not show a reverse list. It merely swapped the first and the last number. If reversing the list is what you want, use this in B1 and fill down:=INDEX(list,COUNT(list)-ROW()+1)where "list" is a named range referring to A1:A17.&nbsp;

excel · Answer

Thank you so much sir.Yes sir, i want to swap first and last number with the help of formula.

lorenzo · Answer

Revised the formula with something easier given what you want to achieve

Forum Discussion

Sorting a Number

5 Replies

Resources