• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Put list of numbers in descending order

W

westend9876

Member
On Row 3 I have numbers as follows in columns N, O, P, Q, R, S:
0 2 0 1 5 0

I need to put these numbers in descending order on Row 4 using the same columns as follows:
5 2 1 0 0 0

The numbers will change frequently also. Thanks.
 
Hi, westend98776!
N4: =K.ESIMO.MAYOR($N3:$S3;COLUMNA()-COLUMNA($N3)+1) in English -----> =LARGE($N3:$S3,COLUMN()-COLUMN($N3)+1)
Change reference in bold if output is wanted elsewhere. Copy across thru S4.
Regards!
 
You must log in or register to reply here.
Back
Top