Normalize a range of numbers..

[mikesal57]

Hey Guys...

I like to normalize a set of numbers to 0-100

EX:

A. 200 numbers between top 94 ...bottom 35.......need the 94 set to 100 and the 35 set to 0


B. 875 numbers between 158 and -57......need 158 set to 100 and -57 set to 0...

yes, numbers are repeating.....like value 67 can have 43 of them

Thxs

Mike

 

[Kenneth Hobson]

In B2, with the absolute range set and fill down. This range is for 158 decreasing to -57 by 1 for each cell.

=ROUND(RANK(A2,$A$2:$A$217,1)/COUNT($A$2:$A$217),2)*100

 

[mikesal57]

Awesome ken...thxs!!!!!