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!
|