A trick that I learned when I first started doing spreadsheets long ago (was
it visicalc?) was to use some sort of border at the end of each range.  i.e.
If you are adding a column, you might put repeating asterisks in cell A4 and
repeating underscores in cell A10, and then add the range A4-A10.
Subsequently, if you are going to insert rows, you would do it between A4
and A10, which would mean that any calculation would include the new cells.
Ditto for columns.  Your end columns, which would be included in your range,
might be a single asterisk.

What character you use is unimportant.  In fact, you could conceivably leave
it blank.  But the idea, when doing some kind of function on a range is for
you to have a visual border for that range, and that there are no problems
when you insert a column or row within that range . . . because the end of
the range are the text items, anything inserted between them would be
included in the calculation.

Eb Lund


----- Original Message -----
>
> Date:    Sun, 16 Mar 2003 14:39:25 -0800
> From:    Peter Shkabara <[log in to unmask]>
> Subject: Re: Fun with Excel
>
> Look at the MIN() and MAX() functions of Excel. They should do what you
> want. Just select the entire range of cells to check, including future
> cells. There are also an Average() function in case you want that also.
>
> Peter
> -----------------------------------------------
> The NoSpin Group
> [log in to unmask]
>
> -----Original Message-----
> I know there are a couple of Excel gurus on this list and since I'm a
> mathematical moron I'll pose my query here. I am trying to use the Large =
> and
> Small functions,not at the same place of course, to get those values =
> from
> one column on Sheet2 to cells on Sheet1. I'm looking for High and low =
> prices
> of a large list of values. It is Column B starting at cell 2 running =
> through
> B202 at this point. The quantity of cells increases each month so it =
> needs
> to be fluid. I want those Large and Small values to be in Sheet 1, B8 =
> for
> Large and B9 for Small. I'm afraid I don't understand the Array thingy.
> Mathematical moron.....
>
> Brad Loomis

             PCSOFT maintains many useful files for download
                     visit our download web page at:
                  http://freepctech.com/downloads.shtml