moogeedoo2
New Member
- Joined
- May 23, 2016
- Messages
- 5
Excel Emperors,
Greetings,,,
I lose my mind to trying calculate this, I have this table below and I try to extract how many indian student are in the highest 25% of scores. or in other way: I have 12 student. 25% of them = 3 I want to know who are the highest 3 students in the score and then how many indians students in these 3 students. in one formula. anyone HELP PLZ.
<tbody>
</tbody>
Greetings,,,
I lose my mind to trying calculate this, I have this table below and I try to extract how many indian student are in the highest 25% of scores. or in other way: I have 12 student. 25% of them = 3 I want to know who are the highest 3 students in the score and then how many indians students in these 3 students. in one formula. anyone HELP PLZ.
student ID | student name | nationality | score | class |
4983 | Jhon | india | 51 | 2 |
3517 | edward | india | 64 | 3 |
2834 | peter | Yemeni | 57 | 11 |
5167 | adam | Egyptian | 59 | 7 |
2074 | amanda | Pakistani | 72 | 7 |
1050 | younes | Jordanian | 48 | 2 |
3337 | arnel | Palestinian | 86 | 8 |
5672 | Jhoseph | Indian | 74 | 3 |
1082 | jannet | Palestinian | 51 | 2 |
5143 | kaila | Yemeni | 80 | 11 |
5234 | inka | algeria | 54 | 2 |
1506 | idward | Palestinian | 77 | 8 |
<tbody>
</tbody>