DynamicRangeNames

DynamicRangeNames - CREATING&USINGDYNAMICRANGENAMES This is...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
This is a really useful feature* in Excel and well worth learning!     an operation like a chart, a list, a control, etc. and your     list or range may change in size, either getting larger or     smaller. Below is an overview of how to create a dynamic range name. Then see the worksheets that follow for examples. The syntax of the formula you need is: =OFFSET(Sheet1!$A$1, 0, 0, COUNTA($A:$A), 3) The OFFSET function has 5 parameters.          rows and columns to move from the anchor. For         our purposes here, zero rows and zero columns.         rows in the range. The COUNTA function as          used above counts cells with data in Column A.         should be included in the defined range. dynamic range. Enter the OFFSET function in the "Refers to" box. For example:    *Thanks for this technique to this Excel tips website: http://www.beyondtechnology.com/projrqst.shtml Q:  When might you  use a dynamic range name? A:  Any time you're using a list or range of data in Excel in     The  first  parameter establishes an "anchor cell".     The  second  and  third  parameters indicate how many     The  fourth  parameter establishes the number of     The 
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 12/20/2011 for the course BUS 101 taught by Professor Ecklund during the Spring '01 term at Duke.

Page1 / 5

DynamicRangeNames - CREATING&USINGDYNAMICRANGENAMES This is...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online