Ranking based on multiple columns having different weightage.

[northtwister]

There are multiple threads of Ranking based on multiple columns but still I am posting new.
Please try to help me.
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Circle[/TD]
[TD]Core[/TD]
[TD]Core[/TD]
[TD]Collector[/TD]
[TD]Collector[/TD]
[TD]Metro[/TD]
[TD]Metro[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]AVL[/TD]
[TD]# of Links[/TD]
[TD]AVL[/TD]
[TD]# of Links[/TD]
[TD]AVL[/TD]
[TD]# of Links[/TD]
[/TR]
[TR]
[TD]Kerala[/TD]
[TD]97.85%[/TD]
[TD]12[/TD]
[TD]97.15%[/TD]
[TD]20[/TD]
[TD]99.42%[/TD]
[TD]47[/TD]
[/TR]
[TR]
[TD]Punjab[/TD]
[TD]99.89%[/TD]
[TD]3[/TD]
[TD]96.68%[/TD]
[TD]1[/TD]
[TD]99.82%[/TD]
[TD]73[/TD]
[/TR]
[TR]
[TD]Karnatak[/TD]
[TD]95.21%[/TD]
[TD]9[/TD]
[TD]95.85%[/TD]
[TD]20[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Delhi[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]99.14%[/TD]
[TD]19[/TD]
[TD]99.89%[/TD]
[TD]14[/TD]
[/TR]
[TR]
[TD]Kashmir[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]99.4[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Assam[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]55.23[/TD]
[TD]3[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]

As you can see the table there is availability for each circle and their number of links.
Core has weightage of 50%
Collector has weightage of 25%
Metro has weightage of 25%

Few states link Kerala & Punjab has all 3 populated.
Few state link Karnataka & Delhi dont have Metro and Core links respectively
And Kashmir & Assam just have 1 & 3 links of collector.

So based on these details I have to rank Circles. Highest number of links and Highest AVL% state to be declared as 1st.

Thanks in Advance.

 

[northtwister]

Any one can help me!!!???

 

[NeonRedSharpie]

You don't have a lot of information needed, but you can just multiply the columns by they weight and then rank the total.

Assuming Table starts in A1 and goes to G8:

H3=

=(B3*0.5)+(D3*0.25)+(F3*0.25)

You can drag that over to I3:I8.

Then, just rank them. This goes in J3:

=(RANK(H3,$H$3:$H$8)+RANK(I3,$I$3:$I$8))/2