Forum Discussion
Excel
=IF(A1=3,3,IF(A1=4,2,IF(A1=5,1,IF(A1=1,5,IF(A1=2,4,"")))))=CHOOSE(A1,5,4,3,2,1)In cell A2 you can try any of these formulas.
=IF(A1=3,3,IF(A1=4,2,IF(A1=5,1,IF(A1=1,5,IF(A1=2,4,"")))))=CHOOSE(A1,5,4,3,2,1)In cell A2 you can try any of these formulas.
Hi, I have another!! In this, I have a list of names in one column and associated number in the next column. I've filtered the the numbers and associated names in order of highest number to the lowest but I want this order to change automatically if one or more of the numbers changes!
Can anyone add some light..... Please?
- I'm happy to see so much activity. I believe the original question was answered, so won't you please consider making another thread for your new question? That helps keep things simple and organized and is good stewardship of the community platform.
=SORT(A2:B11,2,-1)Do you want to sort the numbers and associated names? Then you can try this formula if you have access to the SORT function. It's available in Office 365 and Excel 2021 and Excel for the web.
- Many thanks for looking at this for me its much appreciated. I have 365 but I cant seem to get this to work. Want you have set out is exactly what I need but when it type the formula I get a error message. I can relate to your reference to A2 & B11 in the formula as that is the range but what does the ;2;-1 relate to? This is my version of your formula =SORTIEREN(H32:J43;2;-1)
Which version (language) of Excel do you work with?
In german excel the formula is:
=SORTIEREN(H32:J43;2;-1)
In english:
=SORT(H32:J43,2,-1)
2 is the column by which the range is sorted. -1 is for descending order.
