 # Sorting a Number

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.

It should be result come like this with the help of Formula - So, what formula should i apply?

I am using Microsoft Office 2016

Here is a attached file...

5 Replies

# Re: Sorting a Number

Assuming numbers & no blanks in A1:A17 (edited):

``````=IF(ROW()-ROW(A\$1) = 0,
A\$17,
IF(ROW()-ROW(A\$1)+1 = ROWS(A\$1:A\$17), A\$1, A1)
)``````

# Re: Sorting a Number

Sir can you please explain the formula?

# Re: Sorting a Number

@Zan_Hanifee 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.

# Re: Sorting a Number

Thank you so much sir.

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

# Re: Sorting a Number

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