normalize data to scale from 1 to 10

Posted by Matjaz Lipus on Stack Overflow See other posts from Stack Overflow or by Matjaz Lipus
Published on 2011-02-07T13:16:44Z Indexed on 2011/02/07 15:25 UTC
Read the original article Hit count: 245

Filed under:
|
|

I have a following data set:

A   B   N
1   3   10
2   3   5
3   3   1
3   6   5
10  10  1
20  41  5
20  120 9

I'm looking for an excel function that will normalize A and B to N on scale from 1 to 10.

In above example it would be

1 of 3 is best so N = 10
2 of 3 is in the middle N = 5
3 of 3 is worst N=1
20 of 120 is in second decade N=9

A >= 1 && A <= B

B is natural number

1 <= N <= 10

© Stack Overflow or respective owner

Related posts about excel

Related posts about data