Ranking based on Two coloumns

lalro143

New Member
Joined
May 30, 2014
Messages
39
Hi,

I have two columns as mentioned below col A & col B.

Col ACol BCol C
SITESCOMPLIANCERANK
300090%2
400090%1
<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.
 

Some videos you may like

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

steve the fish

Well-known Member
Joined
Oct 20, 2009
Messages
8,103
Office Version
  1. 365
Platform
  1. Windows
Try this in C2, useful up to row 50 or you will need to amend.

=RANK(B2,$B$2:$B$50)+SUMPRODUCT(($B$2:$B$50=B2)*($A$2:$A$50>A2))
 

Oeldere

Well-known Member
Joined
Dec 29, 2011
Messages
2,213
SITES COMPLIANCE RANK helpcolumn rank
3000 90% 2 0,93000 2
2000 89% 2 0,89200 3
1400 89% 2 0,89140 4
4000 90% 1 0,94000 1


d2= =(B2&A2)*1 and drag down

e2 = =RANK($D2,$D$2:$D$5) and drag down

the result is showing above.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,501
Messages
5,523,293
Members
409,508
Latest member
Afc

This Week's Hot Topics

Top