sksanjeev786
Well-known Member
- Joined
- Aug 5, 2020
- Messages
- 884
- Office Version
- 365
- 2016
- Platform
- Windows
Hi Team
I have almost 50 tab data and I want to rank columns F, E, D, C, B high to low (if we have duplicate data in each F column or pre.)
so can we have a MACRO for this Each tab name Q6a,Q6b till Q6e , then Q7a,Q7b. till Q7e
let me know if you have any questions
Thanks
Sanjeev
I have almost 50 tab data and I want to rank columns F, E, D, C, B high to low (if we have duplicate data in each F column or pre.)
so can we have a MACRO for this Each tab name Q6a,Q6b till Q6e , then Q7a,Q7b. till Q7e
let me know if you have any questions
Ranked Data.xlsx | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
3 | Q2 2020 | Q3 2020 | Q4 2020 | Q1 2021 | Q2 2021 | |||
4 | ||||||||
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 |
Thanks
Sanjeev