sksanjeev786
Well-known Member
- Joined
- Aug 5, 2020
- Messages
- 1,010
- Office Version
- 365
- 2016
- Platform
- Windows
Hi Team,
I need ranking based on the column F Based on the row num F3 (including A1:F4),F8 (A6:F9),F13 (A11: F14) and so on
I need ranking based on the column F Based on the row num F3 (including A1:F4),F8 (A6:F9),F13 (A11: F14) and so on
book2 | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | Q. Slide 7 | |||||||
2 | Q2 2021 | Q3 2021 | Q4 2021 | Q1 2022 | Q2 2022 | |||
3 | Fidelity | 36 | 34 | 34 | 33 | 36 | ||
4 | BASE | 1062 | 1127 | 1037 | 995 | 1037 | ||
5 | ||||||||
6 | Q. Slide 7 | |||||||
7 | Q2 2021 | Q3 2021 | Q4 2021 | Q1 2022 | Q2 2022 | |||
8 | Charles Schwab | 17 | 15 | 19 | 17 | 17 | ||
9 | BASE | 1059 | 1112 | 999 | 947 | 983 | ||
10 | ||||||||
11 | Q. Slide 7 | |||||||
12 | Q2 2021 | Q3 2021 | Q4 2021 | Q1 2022 | Q2 2022 | |||
13 | Principal Financial Group | 6 | 9 | 15 | 12 | 13 | ||
14 | BASE | 471 | 501 | 427 | 419 | 409 | ||
15 | ||||||||
16 | Q. Slide 7 | |||||||
17 | Q2 2021 | Q3 2021 | Q4 2021 | Q1 2022 | Q2 2022 | |||
18 | TIAA | 13 | 15 | 15 | 13 | 17 | ||
19 | BASE | 482 | 479 | 400 | 351 | 380 | ||
20 | ||||||||
21 | Q. Slide 7 | |||||||
22 | Q2 2021 | Q3 2021 | Q4 2021 | Q1 2022 | Q2 2022 | |||
23 | MetLife | 0 | 0 | 0 | 14 | 15 | ||
24 | BASE | 0 | 0 | 0 | 879 | 909 | ||
Sheet1 |