I have the following table structure
<tbody>
</tbody>
And I would like to use a formula that orders the values in columns B and C and returns the corresponding value in column A, as below...
<tbody>
</tbody>
Currently I have code that would order the values in one column, say B and then return A - but not two columns of values.
Any help is appreciated.
A | B | C |
Allan | 12 | 21 |
Bob | 15 | 9 |
Chris | 17 | 15 |
Dave | 22 | 7 |
<tbody>
</tbody>
And I would like to use a formula that orders the values in columns B and C and returns the corresponding value in column A, as below...
A | B |
Dave | 22 |
Allan | 21 |
Chris | 17 |
Bob | 15 |
Chris | 15 |
Allan | 12 |
Bob | 9 |
Dave | 7 |
<tbody>
</tbody>
Currently I have code that would order the values in one column, say B and then return A - but not two columns of values.
Any help is appreciated.