How to group percentile?

I have the follow time sheet of employee paid scale. I need to group into 1
to 4 pay percentile groups, for example, the lowest paid 25% into group 1.


Column A (number of employee) Column B (Pay Scale) Column C Percentile
group 1-4
23 10 1
22 12.25
37 14
12 15.50
60 17
23 19
12 20
5 22
7 25 4

Can you please tell me how to calculate this? Thank you.