Formula for Sorting Numbers

[vijay.vizzu]

Dear All,


Is there any formula, by which we can sort the values from Ascending to descending or descending to ascending.


Thanks

Vijay

 

[Hui]

Vijay


If your data is in A2:A20


Descending

=Large($A$2:$A$20,row(A1))

then copy down


Ascending

=Small($A$2:$A$20,row(A1))

then copy down

 

[vijay.vizzu]

Thank you Hui... It works fine

 

[nazmul_muneer]

If your data is in B2:B8

Type the formula and copy to down for Descending

=IF(RANK($B2,$B$2:$B$8,0)=RANK($B2,$B$2:$B$8,0),LARGE($B$2:$B$8,ROW(B1)),"")