View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
neuromoe neuromoe is offline
external usenet poster
 
Posts: 2
Default 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!