Category | Item | VALUE |
Group A | Item-1 | 68 |
Group A | Item-2 | 81 |
Group A | Item-3 | 79 |
Group A | Item-4 | 84 |
Group A | Item-5 | 75 |
Group A | Item-6 | 75 |
Group A | Item-7 | 70 |
Group A | Item-8 | 70 |
Group B | Item-9 | |
Group B | Item-10 | 70 |
Group B | Item-11 | 65 |
Group B | Item-12 | 74 |
Group B | Item-13 | |
Group C | Item-14 | 77 |
Group C | Item-15 | 82 |
Group C | Item-16 | 68 |
Group C | Item-17 | 79 |
Group C | Item-18 | 79 |
Group C | Item-19 | 80 |
Group C | Item-20 | |
Group C | Item-21 | 69 |
Group C | Item-22 | 76 |
Group C | Item-23 | 74 |
Group C | Item-24 | |
Group C | Item-25 | 79 |
Group C | Item-26 | 84 |
Group C | Item-27 | |
Group C | Item-28 | 73 |
Group C | Item-29 | 71 |
Group C | Item-30 | 57 |
Group D | Item-31 | 71 |
Group D | Item-32 | |
Group D | Item-33 | 79 |
Group D | Item-34 | 75 |
Group D | Item-35 | 77 |
Group A | QUARTILE(IF($B$3:$B$37=$H3,$D$3:$D$37),3) | 79.2 Correct | |
Group B | 70.4 Wrong | 72.3 Correct | |
Group C | 78.8 Wrong | 79.2 Correct | |
Group D | 77.1 Wrong | 77.6 Correct |
When I use the formula shown, I'm getting incorrect results. I've determined that it's not capturing the correct data. It's offset by a couple of rows.