How to make quintile of data??

[Ratan Bhushan]

Hi Team
I want to apply Quartile formula here, from arugement 0 to g. But I want to use it on both Categories:
Student Name
Category
And according to that I want my scores to be distributed in 5 Figures i.e.
Q1
Q2
Q3
Q4
Q5
I ll get the scores of all categories

Please help...

Thanks and Regards
Ratan Bhushan

 

[azumi]

Not sure but pls find the file attach, I have 2 results example, and using array formula

 

[Ratan Bhushan]

Not sure but pls find the file attach, I have 2 results example, and using array formula

FIrst formula worked the same way as I was looking..