Individual Ranking

[sksanjeev786]

Hi Team,
I need individual ranking like B vs C, B vs D, B vs E for all data and i need all ranking data from Q column onwards

Fidelity_FS_Latesh.xlsx
	B	C	D	E	F	G	H	I	J	K	L
3		Check writing	High-yield savings	Payment services like credit/debit cards and online bill pay	FDIC insured products/services	Peer-to-peer (P2P) payments such as Zelle	Lending products	Monitoring spending and cash flow	Real-time fraud and balance alerts	Budgeting tools	None Of these
4	Ally Bank	12	13	16	20	8	17	12	14	11	55
5	Bank of America/Merrill Lynch	35	20	32	35	14	31	21	26	20	40
6	Capital One	27	21	42	37	11	30	23	32	20	33
7	Cash App	13	16	33	21	43	20	29	25	23	35
8	Charles Schwab	10	13	11	21	5	13	13	14	13	59
9	Citigroup	26	16	33	34	9	27	17	24	17	41
10	Fidelity Investments	11	16	12	25	6	16	14	15	16	54
11	JP Morgan Chase	30	20	35	37	15	30	24	29	21	38
12	PayPal	13	17	36	23	43	18	27	27	20	34
13	SoFi	10	12	15	19	9	16	14	14	14	57
14	Venmo	8	10	21	15	38	9	16	15	13	43
15	Wells Fargo	39	21	36	39	16	32	24	29	23	36
Sheet1

 

[RobP]

Hi maybe something like this will do what you need. Formula in G2 can be moved to Q, and adapted for whichever column you want to see.

Book1
	A	B	C	D	E	F	G
1		topic1	topic2	topic3			topic 1
2	Bank1	12	13	16			3
3	Bank2	35	20	32			1
4	Bank3	27	21	42			2
Sheet1

Cell Formulas
Range	Formula
G2:G4	G2	=RANK(B2:B4,$B$2:$B$4)
Dynamic array formulas.

 

[sksanjeev786]

Hi maybe something like this will do what you need. Formula in G2 can be moved to Q, and adapted for whichever column you want to see.

Book1
	A	B	C	D	E	F	G
1		topic1	topic2	topic3			topic 1
2	Bank1	12	13	16			3
3	Bank2	35	20	32			1
4	Bank3	27	21	42			2
Sheet1

Cell Formulas
Range	Formula
G2:G4	G2	=RANK(B2:B4,$B$2:$B$4)
Dynamic array formulas.

Hi

I need ranking based on the column B and C , and B and D along with brand name and data..

 

[RobP]

maybe share some example of the data and your expected output? as currently I'm a little confused by your requirements based on what you ask for in the original post, and now what you ask for.

Apologies for not understanding what you need so far. Above extra info would be good for all to see on say a small subset of example data.
Thanks
Rob

 

[sksanjeev786]

maybe share some example of the data and your expected output? as currently I'm a little confused by your requirements based on what you ask for in the original post, and now what you ask for.

Apologies for not understanding what you need so far. Above extra info would be good for all to see on say a small subset of example data.
Thanks
Rob

Hi Sir,

Here is the example i am looking for ranking output is fro O to V

Book1
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
2		Check writing	High-yield savings	Payment services like credit/debit cards and online bill pay	FDIC insured products/services	Peer-to-peer (P2P) payments such as Zelle	Lending products	Monitoring spending and cash flow	Real-time fraud and balance alerts	Budgeting tools	None Of these				Check writing			High-yield savings			Payment services like credit/debit cards and online bill pay
3	Ally Bank	12	13	16	20	8	17	12	14	11	55			Wells Fargo	39		Ally Bank	13		Ally Bank	16
4	Bank of America/Merrill Lynch	35	20	32	35	14	31	21	26	20	40			Bank of America/Merrill Lynch	35		Capital One	21		Capital One	42
5	Capital One	27	21	42	37	11	30	23	32	20	33			JP Morgan Chase	30		Wells Fargo	21		PayPal	36
6	Cash App	13	16	33	21	43	20	29	25	23	35			Capital One	27		Bank of America/Merrill Lynch	20		Wells Fargo	36
7	Charles Schwab	10	13	11	21	5	13	13	14	13	59			Citigroup	26		JP Morgan Chase	20		JP Morgan Chase	35
8	Citigroup	26	16	33	34	9	27	17	24	17	41			Cash App	13		PayPal	17		Cash App	33
9	Fidelity Investments	11	16	12	25	6	16	14	15	16	54			PayPal	13		Cash App	16		Citigroup	33
10	JP Morgan Chase	30	20	35	37	15	30	24	29	21	38			Ally Bank	12		Citigroup	16		Bank of America/Merrill Lynch	32
11	PayPal	13	17	36	23	43	18	27	27	20	34			Fidelity Investments	11		Fidelity Investments	16		Venmo	21
12	SoFi	10	12	15	19	9	16	14	14	14	57			Charles Schwab	10		Charles Schwab	13		SoFi	15
13	Venmo	8	10	21	15	38	9	16	15	13	43			SoFi	10		SoFi	12		Fidelity Investments	12
14	Wells Fargo	39	21	36	39	16	32	24	29	23	36			Venmo	8		Venmo	10		Charles Schwab	11
Sheet1

 

[RobP]

Ok so you don’t want the rank at all, you just want to sort each column looking at the data you wish to see.

Can I ask - in cell S3 you have 13 so that seems out of place in the order. Likewise in v3 you have 16. Is there some reason for this please?
Thanks
Rob

 

[RobP]

Maybe these are what you need :

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1
2			Check writing	High-yield savings	Payment services like credit/debit cards and online bill pay	FDIC insured products/services	Peer-to-peer (P2P) payments such as Zelle	Lending products	Monitoring spending and cash flow	Real-time fraud and balance alerts	Budgeting tools	None Of these
3		Ally Bank	12	13	16	20	8	17	12	14	11	55			Wells Fargo	39	Capital One	21	Capital One	42
4		Bank of America/Merrill Lynch	35	20	32	35	14	31	21	26	20	40			Bank of America/Merrill Lynch	35	Wells Fargo	21	PayPal	36
5		Capital One	27	21	42	37	11	30	23	32	20	33			JP Morgan Chase	30	Bank of America/Merrill Lynch	20	Wells Fargo	36
6		Cash App	13	16	33	21	43	20	29	25	23	35			Capital One	27	JP Morgan Chase	20	JP Morgan Chase	35
7		Charles Schwab	10	13	11	21	5	13	13	14	13	59			Citigroup	26	PayPal	17	Cash App	33
8		Citigroup	26	16	33	34	9	27	17	24	17	41			Cash App	13	Cash App	16	Citigroup	33
9		Fidelity Investments	11	16	12	25	6	16	14	15	16	54			PayPal	13	Citigroup	16	Bank of America/Merrill Lynch	32
10		JP Morgan Chase	30	20	35	37	15	30	24	29	21	38			Ally Bank	12	Fidelity Investments	16	Venmo	21
11		PayPal	13	17	36	23	43	18	27	27	20	34			Fidelity Investments	11	Ally Bank	13	Ally Bank	16
12		SoFi	10	12	15	19	9	16	14	14	14	57			Charles Schwab	10	Charles Schwab	13	SoFi	15
13		Venmo	8	10	21	15	38	9	16	15	13	43			SoFi	10	SoFi	12	Fidelity Investments	12
14		Wells Fargo	39	21	36	39	16	32	24	29	23	36			Venmo	8	Venmo	10	Charles Schwab	11
Sheet1

Cell Formulas
Range	Formula
O3:P14	O3	=CHOOSECOLS(SORT(B3:C14,2,-1),1,2)
Q3:R14	Q3	=CHOOSECOLS(SORT($B$3:D$14,3,-1),1,3)
S3:T14	S3	=CHOOSECOLS(SORT($B$3:E$14,4,-1),1,4)
Dynamic array formulas.

 

[sksanjeev786]

Maybe these are what you need :

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1
2			Check writing	High-yield savings	Payment services like credit/debit cards and online bill pay	FDIC insured products/services	Peer-to-peer (P2P) payments such as Zelle	Lending products	Monitoring spending and cash flow	Real-time fraud and balance alerts	Budgeting tools	None Of these
3		Ally Bank	12	13	16	20	8	17	12	14	11	55			Wells Fargo	39	Capital One	21	Capital One	42
4		Bank of America/Merrill Lynch	35	20	32	35	14	31	21	26	20	40			Bank of America/Merrill Lynch	35	Wells Fargo	21	PayPal	36
5		Capital One	27	21	42	37	11	30	23	32	20	33			JP Morgan Chase	30	Bank of America/Merrill Lynch	20	Wells Fargo	36
6		Cash App	13	16	33	21	43	20	29	25	23	35			Capital One	27	JP Morgan Chase	20	JP Morgan Chase	35
7		Charles Schwab	10	13	11	21	5	13	13	14	13	59			Citigroup	26	PayPal	17	Cash App	33
8		Citigroup	26	16	33	34	9	27	17	24	17	41			Cash App	13	Cash App	16	Citigroup	33
9		Fidelity Investments	11	16	12	25	6	16	14	15	16	54			PayPal	13	Citigroup	16	Bank of America/Merrill Lynch	32
10		JP Morgan Chase	30	20	35	37	15	30	24	29	21	38			Ally Bank	12	Fidelity Investments	16	Venmo	21
11		PayPal	13	17	36	23	43	18	27	27	20	34			Fidelity Investments	11	Ally Bank	13	Ally Bank	16
12		SoFi	10	12	15	19	9	16	14	14	14	57			Charles Schwab	10	Charles Schwab	13	SoFi	15
13		Venmo	8	10	21	15	38	9	16	15	13	43			SoFi	10	SoFi	12	Fidelity Investments	12
14		Wells Fargo	39	21	36	39	16	32	24	29	23	36			Venmo	8	Venmo	10	Charles Schwab	11
Sheet1

Cell Formulas
Range	Formula
O3:P14	O3	=CHOOSECOLS(SORT(B3:C14,2,-1),1,2)
Q3:R14	Q3	=CHOOSECOLS(SORT($B$3:D$14,3,-1),1,3)
S3:T14	S3	=CHOOSECOLS(SORT($B$3:E$14,4,-1),1,4)
Dynamic array formulas.

yes...!!!

thanks you so much sir for your help

 

[RobP]

Great, Thanks for your feedback & glad we could help.

Rob

 

[sksanjeev786]

Great, Thanks for your feedback & glad we could help.

Rob

Hi Sir,

Can we have a secondary ranking to the below data if Q2 data is same then rank on Q1

Book1
	B	C	D	E	F	G	H	I
2		Q1	Q2				Q1	Q2
3	Ally Bank	12	13			Wells Fargo	39	21
4	Bank of America/Merrill Lynch	35	20			Capital One	27	21
5	Capital One	27	21			Bank of America/Merrill Lynch	35	20
6	Cash App	13	16			JP Morgan Chase	30	20
7	Charles Schwab	10	13			PayPal	13	17
8	Fidelity Investments	11	16			SoFi	10	17
9	Citigroup	26	16			Citigroup	26	16
10	JP Morgan Chase	30	20			Cash App	13	16
11	SoFi	10	17			Fidelity Investments	11	16
12	PayPal	13	17			Ally Bank	12	13
13	Venmo	8	10			Charles Schwab	10	13
14	Wells Fargo	39	21			Venmo	8	10
Sheet3