Creating unique list of variable and number of times each variable occurred.

I have the data of 200 students scores.

 Here, we need a discrete or ungrouped frequency distribution. ,where we count the number of times each value of a variable (score in above example) occurs in the above data.

In the first column we placed the raw data files , in second column we created unique list  of raw data files - (by formula) and in third column we found the number of times each value (score) is repeated (by formula). 

For unique list column, below is the formula that is used:-

{=IFERROR(INDEX(score,SMALL(IF(MATCH(score,score,0)=ROW(INDIRECT("1:"&ROWS(score))),ROW(INDIRECT("1:"&ROWS(score)))," "),ROW(INDIRECT("1:"&ROWS(score)))))," ")}

And for number of times each value (score) is repeated, we used:-

{=IFERROR(INDEX(IF(MATCH(score,score,0)=ROW(INDIRECT("1:"&ROWS(score))),COUNTIF(score,score)," "), SMALL(IF(MATCH(score,score,0)= ROW(INDIRECT("1:"&ROWS(score))), ROW(INDIRECT("1:"&ROWS(score)))," "), ROW(INDIRECT("1:"&ROWS(score)))))," ")}.

Remark: - Total of Frequency is the total number of students (here, 200).