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