Sorting a Number

Super Contributor

Hello Everyone,

Screenshot (6510).png

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 - 

Screenshot (6511).png

 

So, what formula should i apply?

Please help..

I am using Microsoft Office 2016

 

 

Here is a attached file...

 

 

5 Replies

Hi @Zan_Hanifee 

 

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)
)
Sir can you please explain the formula?
Please..??

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

Thank you so much sir.

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

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