Solved

correct formula for dynamic range EXCEL

Posted on 2011-09-12
3
203 Views
Last Modified: 2012-08-13
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
Comment
Question by:stmoritz
  • 2
3 Comments
 
LVL 32

Accepted Solution

by:
Rob Henson earned 100 total points
ID: 36521240
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
 
LVL 32

Expert Comment

by:Rob Henson
ID: 36521249
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
 

Author Closing Comment

by:stmoritz
ID: 36521307
thanks a lot, works perfect!
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question