Hello! I am trying to find out if there is a function in Excel which allows
you to do the following:

I have a list of approximately 50 numbers. I need to fit these numbers into
a percentile range of 2% to 4% (to make it more understandable, I have a list
of "scores" for employees in an office, and need to fit them into a range of
2%-4% to figure out their annual salary increase). Is there any way to make
Excel assign a percentage to each number in the range, with the lowest number
in the range equalling 2% and the highest number equalling 4% with the rest
of the numbers calculated somewhere in between?

Thanks in advance for any assistance :)