My spreadheet has the entire MLB N/L schedule
COLUMNS are TEAM
ROWS are DATE
Each mmorning, W/L are updated.
Summary section contain cell the look for MAX and MIN
'E188" =MIN(E18:E103) E103 represents were the last new data is entered.
I would like to automate the reference to the last row filled in.
The referenced columns for games NOT YET PLAYED result in #N/A. This is
needed for graphing purposes. I curretly have to use the <Ctrl +H function
to update the ending cell across the MIN and MAX rows.
Thanks in advance for your support

Assumes ALL rows are filled in
=MIN(e1,OFFSET(e1,0,0,COUNTA(e:e),1))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Deskpilot" wrote in message
...
My spreadheet has the entire MLB N/L schedule
COLUMNS are TEAM
ROWS are DATE
Each mmorning, W/L are updated.
Summary section contain cell the look for MAX and MIN
'E188" =MIN(E18:E103) E103 represents were the last new data is entered.
I would like to automate the reference to the last row filled in.
The referenced columns for games NOT YET PLAYED result in #N/A. This is
needed for graphing purposes. I curretly have to use the <Ctrl +H
function
to update the ending cell across the MIN and MAX rows.
Thanks in advance for your support

Modified to =MIN(E3,OFFSET(E1,0,0,COUNTA(E5:E185),1)) to limit reference
because orig created circular reference. Result returned #NA

SAMPLE:
A B C D E

104 7/09/08 / 47 / 44 / SF /.516
185 9/28/08/ / / FLA / #NA

185 9/28/08 / / / FLA
/=IF(B185="",NA(),B185/SUM(B185:C185:C185))

E185 (and all above) prevents line graph from dropping to ZERO because graph
is formatted to extend to end of season.

I'm hoping to figure a way to have 187(MIN) and 188(MAX) look into the
respective column (3:185) and identify the last row with a numeric result and
change

"Don Guillett" wrote:

Assumes ALL rows are filled in
=MIN(e1,OFFSET(e1,0,0,COUNTA(e:e),1))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Deskpilot" wrote in message
...
My spreadheet has the entire MLB N/L schedule
COLUMNS are TEAM
ROWS are DATE
Each mmorning, W/L are updated.
Summary section contain cell the look for MAX and MIN
'E188" =MIN(E18:E103) E103 represents were the last new data is entered.
I would like to automate the reference to the last row filled in.
The referenced columns for games NOT YET PLAYED result in #N/A. This is
needed for graphing purposes. I curretly have to use the <Ctrl +H
function
to update the ending cell across the MIN and MAX rows.
Thanks in advance for your support