Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 213
  • 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 HensonIT & Database AssistantCommented:
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 HensonIT & Database AssistantCommented:
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

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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