Ranking Column based on columns having percentage and number.

[Gaurav453]

Hi all,

I'm looking to rank this data of basis of two columns consisting of percent and numerical value. Is there a way to do it?

 

[hagia_sofia]

But what is the idea of ranking these data - just 1 to N for both and then average? Or something else?

 

[Gaurav453]

I'm trying to rank managers based on two columns which consists of percent and number value.

 

[Gaurav453]

Rank should be from 1 to N

 

[Gaurav453]

I'm looking to combine both column and used both of em to rank managers.

 

[Fluff]

Maybe

Fluff.xlsm
	A	B	C	D
1
2	A	40	0.25	1
3	B	12	0.4	3
4	C	6	0.12	4
5	D	12	0.69	2
Sheet6

Cell Formulas
Range	Formula
D2:D5	D2	=XMATCH(A2,INDEX(SORT($A$2:$C$5,{2,3},-1),,1))

 

[Gaurav453]

The above formula is ranking the column A on basis of column B only. There is no contribution of column C in ranking of column A.

 

[Fluff]

The formula is ranking by both columns B & C, as you can on rows 3 & 5 which both have the same score in col B