I have a set of random numbers in two columns A and B. I want to arrange the sum of these two columns in descending order. However, if the sum of two numbers in Column A and B is equal to another row(s), then the descending order should give priority to the greater number in Column A. For example, in the table below, sum of two numbers in Column A and B in first two rows is equal (38). However, the descending order in Column C should keep row 2 as No.1 as row 2 in Column A has the greater number (22) as compared to row 1 in Column A (20).
Thanks in advance.
Thanks in advance.
A | B |
20 | 18 |
22 | 16 |
19 | 22 |
15 | 26 |
18 | 23 |
23 | 14 |
26 | 11 |
25 | 15 |
27 | 18 |
29 | 9 |