How can i find the percentile in such non organized data?
my data look like this
Student A Subject 1 Score
Student A Subject 2 Score
Student A Subject 3 Score
Student B Subject 1 Score
Student B Subject 2 Score
Student B Subject 3 Score
Student C Subject 1 Score
Student C Subject 2 Score
Student C Subject 3 Score
how can i find the percentile of the Student A in Subject 1?
I am not going to sort that , or direct use the formula in a disjoint range because i need to find the percentile of that student that subject in every row, so that i can reuse it on my pivot table.
Many Thanks
my data look like this
Student A Subject 1 Score
Student A Subject 2 Score
Student A Subject 3 Score
Student B Subject 1 Score
Student B Subject 2 Score
Student B Subject 3 Score
Student C Subject 1 Score
Student C Subject 2 Score
Student C Subject 3 Score
how can i find the percentile of the Student A in Subject 1?
I am not going to sort that , or direct use the formula in a disjoint range because i need to find the percentile of that student that subject in every row, so that i can reuse it on my pivot table.
Many Thanks