• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 215
  • Last Modified:

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
0
stmoritz
Asked:
stmoritz
  • 2
1 Solution
 
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.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now