Normalize Scaling

[mikesal57]

Hi Mrexcel

I'd like to scale columns of number to be TOP=100 BOTTOM = 0

Is there an easy way?

Thxs

[TABLE="width: 512"]
<tbody>[TR]
[TD="width: 64, align: right"]113[/TD]
[TD="width: 64, align: right"]99[/TD]
[TD="width: 64, align: right"]118[/TD]
[TD="width: 64, align: right"]84[/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"]TOP[/TD]
[TD="width: 64, align: right"]100[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]-8[/TD]
[TD="align: right"]16[/TD]
[TD][/TD]
[TD][/TD]
[TD]BOTTOM[/TD]
[TD="align: right"]0[/TD]
[/TR]
</tbody>[/TABLE]

 

[shg]

[table="width:, class:grid"][tr][td="bgcolor:#c0c0c0"][/td][td="bgcolor:#c0c0c0"]

a​

[/td][td="bgcolor:#c0c0c0"]

b​

[/td][td="bgcolor:#c0c0c0"]

c​

[/td][/tr][tr][td="bgcolor:#c0c0c0"]

1​

[/td][td]

113​

[/td][td="bgcolor:#ccffcc"]

85.3​

[/td][td="bgcolor:#ccffcc"]b1: =100 * (a1 - min($a$1:$a$4)) / (max($a$1:$a$4) - min($a$1:$a$4))[/td][/tr]
[tr][td="bgcolor:#c0c0c0"]

2​

[/td][td]

99​

[/td][td="bgcolor:#ccffcc"]

44.1​

[/td][td][/td][/tr]
[tr][td="bgcolor:#c0c0c0"]

3​

[/td][td]

118​

[/td][td="bgcolor:#ccffcc"]

100.0​

[/td][td][/td][/tr]
[tr][td="bgcolor:#c0c0c0"]

4​

[/td][td]

84​

[/td][td="bgcolor:#ccffcc"]

0.0​

[/td][td][/td][/tr]
[/table]

 

[mikesal57]

Awesome shg!!!

thank You

 

[shg]

You're welcome.

 

[mikesal57]

Hello Guys...

RE-visiting a old one here....

Formula worked great ...

Just want to know if the lowest value in the list can be a 1 and not a zero

thank you