Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to select top six numbers from a of range of random numbers | Excel Worksheet Functions | |||
two columns range of numbers need to list all numbers in the range | New Users to Excel | |||
split range of numbers in two columns to as many as numbers in ran | Excel Discussion (Misc queries) | |||
How I can see distict numbers among range of numbers? | Excel Discussion (Misc queries) | |||
Count comma separated numbers, numbers in a range with dash, not t | Excel Discussion (Misc queries) |