Microsift Office 2007
Posted 27 April 2009 - 07:12 PM
Posted 28 April 2009 - 10:35 AM
Posted 28 April 2009 - 04:19 PM
Day X X
Posted 28 April 2009 - 04:34 PM
So to find the highest number in a column of numbers from B2 to B10, use =MAX(B2:B10)
Posted 28 April 2009 - 06:19 PM
Posted 29 April 2009 - 01:40 AM
Select/highlight all the high temperatures in a row (press and hold the Ctrl key while clicking on all the relevant cells).
When all the cells have been selected, click in the Name Box (top left of the spreadsheet, showing the last cell selected).
Type a name, say, HighsX (where X is a row or day or whatever you use to identify different rows)
Do the same for all the low temperatures in a row and type a name, say, LowsX
Then use the formulae as needed =MIN(HighsX), =MAX(LowsX)
Posted 29 April 2009 - 11:40 AM
Posted 29 April 2009 - 12:35 PM
Start typing in the formula in the cell at the end of the row where you want the highest low to appear =MAX(
Then click on the first low cell, say that's B3. The formula will look like =MAX(B3
and press the comma on the keyboard. The formula will look like =MAX(B3,
Now click on the next low cell, say that D3. The formula will look like =MAX(B3,D3
and press the comma on the keyboard. The formula will look like =MAX(B3,D3,
Do the same for all the low cells. After clicking on the last low cell, press the close bracket on the keyboard so the formula will be something like =MAX(B3,D3,F3,H3,J3)
Then do the same for the high cells.
Posted 29 April 2009 - 05:03 PM
Posted 01 May 2009 - 03:23 AM
Do you know where the Name Box is? Here's a picture: http://www.cpearson....el/NameBox.aspx
As you move around the spreadsheet, the name box shows the active cell. Are you OK with that?
You need to create a named set of data.
Let's say you have a spreadsheet with days/months going down column A with High Low alternating in B/C, D/E, F/G in years. Something like:
..............High Low........High Low
First, set the name for the 01-Jan Highs. Click on the cell with 29 then, holding down the Control key, click on the next 01-Jan High figure (32). Keep clicking (selecting) all the High temperatures for 01-Jan until they are all selected.
With all the 01-Jan High temperatures still all selected, release the Control key and click into the Name Box.
Type High01Jan (or a similar unique name) and press Enter. Now when you refer to High01Jan, Excel knows you mean all the cells you previously selected.
To see how this works, go to the end of the 01 Jan row, where you want to display the maximum high temperature, and type =MAX(High01Jan)
Obviously, if you want the minimum high temperature for 01 Jan, you would type =MIN(High01Jan)
Repeat the naming process for all the Low temperatures for 01 Jan, selecting all the low temperatures and then typing Low01Jan in the Name Box. Then use =MAX(Low01Jan) and =MIN(Low01Jan) as needed.
Repeat the naming for each day/month so you would have names of High02Jan, Low02Jan, High03Jan, Low03Jan, etc.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users