VBA: Can i get ranking of my selected range with ,1,2,3 ranking

[sksanjeev786]

Hi Team

I have a multiple-column with data and I want to rank on 1st,2nd and 3rd column high to low.
can anyone help me with this?


Thanks.

Regards,
Sanjeev

 

[sksanjeev786]

Hi Team

I have a multiple-column with data and I want to rank on 1st,2nd and 3rd column high to low.
can anyone help me with this?


Thanks.

Regards,
Sanjeev

Hi Team

please help me on this

Thank you.

 

[sksanjeev786]

Hi Team

please help me on this

Thank you.

Hi Team

please help me on this

Thank you.

 

[Eric W]

It's a little unclear what you want. Could you show what your expected results should be? In the meantime, here's a basic ranking formula:

Book1
	A	B	C	D	E	F	G
1	GAVE RECALL (NET)	96	33	65	1	4	2
2	Mentioned Coke Zero/Zero Sugar	39	88	79	2	1	1
3	Mentioned Coca-Cola	25	72	22	3	2	3
4	Mentioned Coca-Cola/Zero Sugar	15	9	9	4	5	5
5	Mentioned Coke	11	63	11	5	3	4
Sheet1

Cell Formulas
Range	Formula
E1:G5	E1	=RANK(B1,B$1:B$5)

 

[sksanjeev786]

It's a little unclear what you want. Could you show what your expected results should be? In the meantime, here's a basic ranking formula:

Book1
	A	B	C	D	E	F	G
1	GAVE RECALL (NET)	96	33	65	1	4	2
2	Mentioned Coke Zero/Zero Sugar	39	88	79	2	1	1
3	Mentioned Coca-Cola	25	72	22	3	2	3
4	Mentioned Coca-Cola/Zero Sugar	15	9	9	4	5	5
5	Mentioned Coke	11	63	11	5	3	4
Sheet1

Cell Formulas
Range	Formula
E1:G5	E1	=RANK(B1,B$1:B$5)

Hi Eric,

I need ranking data for column B,C,D high to low if I rank only column B hope you got it.

Regards,
Sanjeev

 

[Eric W]

In my example, E has the rankings for column B, F has the rankings for column C, and G has the rankings for column D. If you only want the column B rankings, just remove the formulas from columns F and G.

 

[sksanjeev786]

In my example, E has the rankings for column B, F has the rankings for column C, and G has the rankings for column D. If you only want the column B rankings, just remove the formulas from columns F and G.

Hi Sir,

I need ranking automatic if I rank only column B data so by default C and D also rank with secondary and 3rd rank.

As you have provided the data needs to ranking 3 times in Column E,F and G can it be like if I rank only column B so C and D data rank automatic.

Let us know if it is possible thank you

Regards,
Sanjeev

 

[Eric W]

Can you show an example of what you're looking for? If you use C and D columns as secondary and 3rd parameters, they would only come into play if column B has ties, which is not the case in your example. Please make an example with some numbers, and show the expected results and explain how you got them.