# Microsift Office 2007

Started by
munleyj
, Apr 27 2009 07:12 PM

###
#1
Posted 27 April 2009 - 07:12 PM

###
#2
Posted 28 April 2009 - 10:35 AM

Yes, but it depends what you are trying to do. Any more information?

###
#3
Posted 28 April 2009 - 04:19 PM

I have several columns with temperature data. I need to find the highest minimum temperature in a in a row.

Example:

_____Year________________

High Low

Day X X

X X

Example:

_____Year________________

High Low

Day X X

X X

###
#4
Posted 28 April 2009 - 04:34 PM

To find the highest number in a range, use =MAX(range). For the lowest number, use =MIN(range)

So to find the highest number in a column of numbers from B2 to B10, use =MAX(B2:B10)

So to find the highest number in a column of numbers from B2 to B10, use =MAX(B2:B10)

###
#5
Posted 28 April 2009 - 06:19 PM

I understand that. I need to find the highest minimum and the minimum column is every other column. How Do I set the formula to omit every other column? Its High Low High Low. I want to find the highest minimum of the lows going horizontaly with out typing each cell. Is that possible?

###
#6
Posted 29 April 2009 - 01:40 AM

One way...

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)

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)

###
#7
Posted 29 April 2009 - 11:40 AM

I am not very good at this. Whats another way. Here is the file. I want to find the highest low in a row for any given day.

###
#8
Posted 29 April 2009 - 12:35 PM

Another way...

Start typing in the formula in the cell at the end of the row where you want the highest low to appear

Then click on the first low cell, say that's B3. The formula will look like

and press the comma on the keyboard. The formula will look like

Now click on the next low cell, say that D3. The formula will look like

and press the comma on the keyboard. The formula will look like

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

Press Enter.

Then do the same for the high cells.

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)**Press Enter.

Then do the same for the high cells.

###
#9
Posted 29 April 2009 - 05:03 PM

I have 32 column for the lows. It tell me I have too many arguments than is allowed in teh current cell format. What dioI do. I just need it for the Lows for any given day (horizontally).

###
#10
Posted 30 April 2009 - 12:27 AM

The first option would work.

###
#11
Posted 30 April 2009 - 06:45 AM

I don't understand or how to do it.

###
#12
Posted 01 May 2009 - 03:23 AM

Open your spreadsheet.

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:

.................1900..............1901

..............High Low........High Low

01-Jan......29....6............32....14

02-Jan......26....4............28....10

03-Jan......33...12...........29.....9

First, set the name for the 01-Jan Highs. Click on the cell with 29 then,

With all the 01-Jan High temperatures still all selected, release the Control key and click into the Name Box.

Type

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

Obviously, if you want the minimum high temperature for 01 Jan, you would type

Repeat the naming process for all the Low temperatures for 01 Jan, selecting all the low temperatures and then typing

Repeat the naming for each day/month so you would have names of High02Jan, Low02Jan, High03Jan, Low03Jan, etc.

OK?

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:

.................1900..............1901

..............High Low........High Low

01-Jan......29....6............32....14

02-Jan......26....4............28....10

03-Jan......33...12...........29.....9

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.

OK?

### Similar Topics

#### 0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users