Cobber2008
New Member
- Joined
- Nov 29, 2020
- Messages
- 28
- Office Version
- 365
Hello - i need to rank about 50000 rows of data but only against a subset of data. As you can see below ive done the Rank in column E (manually) to rank on the data that is the same in column A/B/C. When it changes it needs to rank based on that different subset. So in the limited example below im looking for a formula to apply column E that will rank the first 9 rows as A/B/C are the same then the next 11 rows as the A/B/C columns are the same. i hope this makes sense thank you.
| A | B | C | D | E |
| Course A | 1 | Mdn | 36 | 4 |
| Course A | 1 | Mdn | 44.49 | 5 |
| Course A | 1 | Mdn | 5.29 | 3 |
| Course A | 1 | Mdn | 148.93 | 7 |
| Course A | 1 | Mdn | 3.78 | 2 |
| Course A | 1 | Mdn | 208.97 | 8 |
| Course A | 1 | Mdn | 2.19 | 1 |
| Course A | 1 | Mdn | 55.99 | 6 |
| Course A | 2 | CLS | 7 | 6 |
| Course A | 2 | CLS | 350 | 11 |
| Course A | 2 | CLS | 22.77 | 10 |
| Course A | 2 | CLS | 5.6 | 4 |
| Course A | 2 | CLS | 6.29 | 5 |
| Course A | 2 | CLS | 4.83 | 2 |
| Course A | 2 | CLS | 12.92 | 7 |
| Course A | 2 | CLS | 5.05 | 3 |
| Course A | 2 | CLS | 17.08 | 9 |
| Course A | 2 | CLS | 3.3 | 1 |
| Course A | 2 | CLS | 13.85 | 8 |
