I have a column represents a set of numbers. Lowest number is 0, highest is 195. What I am trying to do is create a scale of 1-10, where the largest number in the series represents a 10, and the lowest number equals 1.
I am hoping anyone of you can help me create a formula that will automatically scale this large string of numbers into a 1-10 scale.
Thanks in advance for helping me out here!
I am hoping anyone of you can help me create a formula that will automatically scale this large string of numbers into a 1-10 scale.
Thanks in advance for helping me out here!