Hi,
I have two columns as mentioned below col A & col B.
<colgroup><col width="64" style="width: 48pt;">
<col width="89" style="width: 67pt; mso-width-source: userset; mso-width-alt: 3254;">
<col width="64" style="width: 48pt;">
<tbody>
</tbody>
Now I want formula which can determine ranking based first on Col B, In case % of cells in col B are same then it check col A's value and rank based site count as shown above.
Thanks in advance.
I have two columns as mentioned below col A & col B.
Col A | Col B | Col C |
SITES | COMPLIANCE | RANK |
3000 | 90% | 2 |
4000 | 90% | 1 |
Now I want formula which can determine ranking based first on Col B, In case % of cells in col B are same then it check col A's value and rank based site count as shown above.
Thanks in advance.