Grumpy88
Member
Hi.
In the attached workbook, I have three columns of numbers. I am looking for a formula please that will arrange column B in descending order, but always moving the accompanying row value in column C as well when it resorts the order. Where two successive values in column B are the same, they should be ordered with the smaller value in column A being first.
I know that formatting it as a table would do that for me, but I'd like to use the data in a specific format of report (whose format doesn't allow for that). I am also looking for a formula-based approach, as that would update and sort the list automatically as the source data changes. I have Excel365.
Thanks.
In the attached workbook, I have three columns of numbers. I am looking for a formula please that will arrange column B in descending order, but always moving the accompanying row value in column C as well when it resorts the order. Where two successive values in column B are the same, they should be ordered with the smaller value in column A being first.
I know that formatting it as a table would do that for me, but I'd like to use the data in a specific format of report (whose format doesn't allow for that). I am also looking for a formula-based approach, as that would update and sort the list automatically as the source data changes. I have Excel365.
Thanks.