correct formula for dynamic range EXCEL

what is the correct formula to have the non-empty fields of the yellow marked fields defined as dynamic range STOP1?
time-trial-calculator.xls
stmoritzAsked:
Who is Participating?
 
Rob HensonFinance AnalystCommented:
Amost there with your formula in C9:

=OFFSET(Sheet1!$B$3,0,0,COUNTA(Sheet1!$B$3:$B$3333),1)

OFFSET(Reference,OffsetRow,OffsetColumn,Height,Width)

Cheers
Rob H
0
 
Rob HensonFinance AnalystCommented:
BTW it may not work on the worksheet and needs to be entered in the Refers To box for the named range.

Thanks
Rob H
0
 
stmoritzAuthor Commented:
thanks a lot, works perfect!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.