Sufiyan97
Well-known Member
- Joined
- Apr 12, 2019
- Messages
- 1,538
- Office Version
- 365
- 2013
- Platform
- Windows
I have below table and expected results are given in column K
Excel.xlsx | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | |||
1 | Group A | Group A | Match 1 | Match 2 | Total | |||||||||||
2 | Group A | 60 | R | 30 | 30 | 60 | Match 13 | |||||||||
3 | Group A | 57 | J | 27 | 30 | 57 | ||||||||||
4 | Group A | 49 | M | 25 | 24 | 49 | Group A | 60 | Manual | A's Top | ||||||
5 | ||||||||||||||||
6 | Group B | Group B | Group B | 58 | Expected | B's Second | ||||||||||
7 | Group B | 57 | K | 32 | 25 | 57 | ||||||||||
8 | Group B | 58 | A | 31 | 27 | 58 | This should be the result | Group C | 78 | Expected | C's second | |||||
9 | Group B | 59 | V | 31 | 28 | 59 | ||||||||||
10 | ||||||||||||||||
11 | Group C | Group C | ||||||||||||||
12 | Group C | 60 | K | 29 | 30 | 78 | This should be the result | |||||||||
13 | Group C | 61 | A | 31 | 29 | 79 | ||||||||||
14 | Group C | 62 | V | 25 | 24 | 75 | ||||||||||
15 | ||||||||||||||||
16 | ||||||||||||||||
17 | ||||||||||||||||
Absolute Points |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B2:B4,B7:B9 | B2 | =+F2 |
F2:F4,F7:F9 | F2 | =+D2+E2 |
A2:A14 | A2 | =IF(C2="","",IF(ISNUMBER(SEARCH("Group",C2)),C2,A1)) |