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.

Circle	Core	Core	Collector	Collector	Metro	Metro
	AVL	# of Links	AVL	# of Links	AVL	# of Links
Kerala	97.85%	12	97.15%	20	99.42%	47
Punjab	99.89%	3	96.68%	1	99.82%	73
Karnatak	95.21%	9	95.85%	20	0	0
Delhi	0	0	99.14%	19	99.89%	14
Kashmir	0	0	99.4	1	0	0
Assam	0	0	55.23	3	0	0

<tbody>
</tbody>

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