range of numbers

  • Thread starter Thread starter neuromoe
  • Start date Start date
N

neuromoe

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