VBA Ranking data for all the tabs

[sksanjeev786]

Hi Team,

I have data from A5 to F18 with multiple tabs but the same column and row and I want to rank high to low
for column F and then column E for almost 30 tabs

Ranked DataV.xlsx
	A	B	C	D	E	F
5	Fidelity	11	9	11	11	10
6	Charles Schwab	6	5	5	5	5
7	Voya (F)	2	3	2	2	2
8	Prudential	1	1	1	1	1
9	Ameriprise	0	0	1	1	1
10	TIAA	0	0	1	1	1
11	T Rowe Price	1	0	0	1	0
12	John Hancock	0	0	0	0	0
13	Lincoln Financial	0	0	0	0	0
14	The Hartford	0	0	0	0	0
15	Principal Financial Group	0	0	0	0	0
16	Empower Retirement	0	0	0	0	0
17	Transamerica	0	0	0	0	0
18	Competitor Average	1	1	1	1	1
1

 

[bebo021999]

Assum you have sheet 1-30, column A to F
Where you want to put desired output?
In column H every sheets, or in sheet 31st?

Could you post 1 more sheet (sheet2) with different data, then highlight the expected results?

 

[sksanjeev786]

Assum you have sheet 1-30, column A to F
Where you want to put desired output?
In column H every sheets, or in sheet 31st?

Could you post 1 more sheet (sheet2) with different data, then highlight the expected results?

Thank you so much for your help

here is the data and expected result in column H to M

Ranked DataV.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M
5	Ameriprise	5	7	7	6	6		Fidelity	55	53	55	49	49
6	TIAA	6	6	6	4	4		Charles Schwab	39	37	38	33	32
7	Lincoln Financial	5	4	4	3	3		Prudential	21	22	21	11	8
8	Fidelity	55	53	55	49	49		Voya (F)	9	11	11	10	8
9	John Hancock	6	6	7	3	2		Competitor Average	13	12	13	8	8
10	Principal Financial Group	3	4	5	1	2		T Rowe Price	11	9	10	7	7
11	Charles Schwab	39	37	38	33	32		Ameriprise	5	7	7	6	6
12	Prudential	21	22	21	11	8		TIAA	6	6	6	4	4
13	Voya (F)	9	11	11	10	8		Lincoln Financial	5	4	4	3	3
14	T Rowe Price	11	9	10	7	7		John Hancock	6	6	7	3	2
15	The Hartford	4	3	4	1	1		Principal Financial Group	3	4	5	1	2
16	Transamerica	2	4	3	1	1		The Hartford	4	3	4	1	1
17	Empower Retirement	2	2	2	0	1		Transamerica	2	4	3	1	1
18	Competitor Average	13	12	13	8	8		Empower Retirement	2	2	2	0	1
3