Hi all SIFUS,

I have been in this situation for a about a month and finally need all SIFUS help on my problem.

I need to do a force ranking/ normal distribution for bell curve, which has been set as follow:

Score 90 - 100% = 5%
Score 80 - 89.9% = 5%
Score 70 - 79.9% = 5%
Score 50 - 69.9% = 70%
Score 30 - 49.9% = 5%
Score below 30% = 5%

At this moment, my data are as follow:

Score 90 - 100% = 10%
Score 80 - 89.9% = 30%
Score 70 - 79.9% = 20%
Score 50 - 69.9% = 40%
Score 30 - 49.9% = 0%
Score below 30% = 0%

How can i do a force ranking and normalised the distribution of the score based on bell curve.

Im too amateur in Excell. I do appreciate if SIFUs can give me a proper example step by step and sample of the templates.

Honestly, i already do searching in this forum, but i cannot understand the way it works.