help to keep a ratio between numbers after changing the range

[formratings]

hi
am not too good at this and could do with your help please, not sure if it is a formula I need
I have a column of numbers ranging from 1 to 200 and anything in between, the top number could be anything within that range
I want the Max to always be 100 so what ever the highest number is it has to equal 100
0 always to equal 50
Want to keep the ratio the same except between 0 and the next lowest number,
So I think I want to measure the % difference between each number except 0 which is static
thanks dave

 

[diddi]

if you put the scaled number into column "B", the formula you can use is

=(A1-MIN(A$1:A$300))/(MAX(A$1:A$300) - MIN(A$1:A$300))*50 +50

in cell B1 and fill down
change the $300 to your bottom row in the list. but if you dont use all 300 rows it does not matter