sksanjeev786
Well-known Member
- Joined
- Aug 5, 2020
- Messages
- 883
- Office Version
- 365
- 2016
- Platform
- Windows
Hi TeamHi 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.
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,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)
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.