range of numbers
 

I have a bunch of data that indicates scores given and how much the score
changed from year to year. I would like to calculate the range of scores for
a single person, as well as the range of change. This should be pretty
simple, but I can't figure it out.

I'm in Excel 2007, and here's a sample of my data:

D e F g H i
2 4.9 0.0 4.8 -1.0 4.9 1.0

So I am looking to calculate the range of numbers among D2, F2, H2, and then
separately the range of numbers in e2, g2, i2.

I could really use some help!

range of numbers
 

Not sure how you want the range to be expressed. You could use this to
get the range of numbers:

=MIN(D2,F2,H2)&" to "&MAX(D2:F2:H2)

or show it like this:

=MAX(D2:F2:H2)-MIN(D2:F2:H2)

Use this to get the range of change:

=MIN(E2,G2,I2)&" to "&MAX(E2,G2,I2)

or like this:

=MAX(E2,G2,I2)-MIN(E2,G2,I2)

Hope this helps.

Pete

On Sep 4, 10:03*pm, neuromoe
wrote:
I have a bunch of data that indicates scores given and how much the score
changed from year to year. *I would like to calculate the range of scores for
a single person, as well as the range of change. *This should be pretty
simple, but I can't figure it out.

I'm in Excel 2007, and here's a sample of my data:

* * * * *D * * * e * * * F * * g * * *H * * *i
2 * * * 4.9 * *0.0 * 4.8 * -1.0 * 4.9 * 1.0

So I am looking to calculate the range of numbers among D2, F2, H2, and then
separately the range of numbers in e2, g2, i2.

I could really use some help!