LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Don Don is offline
external usenet poster
 
Posts: 487
Default Dynamic Range (again)

All,
I am lost on this (Excel 2003) one. I have two different dynamic ranges I
use for validation. The first is a text list of various items. This seems to
work fine, but the second, is simply a range of numeric quantities (eg:
1-100) with the ability to add more.

While first list does NOT display blanks at the bottom of the dropdown, the
numeric one ALWAYS seems to do so and starts at the bottom.
I've read the contextures article - but do not see what I'm doing wrong
several suggestions said to delete blank cells in the range, but I have done
this to the bottom of the sheet.

Here are the formulas I use for the dynamic ranges. I should add that both
ranges have a header in row 1.
The text based list:
=OFFSET(MasterContentsList!$A$2,0,0,COUNTA(MasterC ontentsList!$A:$A),1)

and the Numeric one:
=OFFSET(MasterContentsList!$E$2,0,0,COUNTA(MasterC ontentsList!$E:$E),1)

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dynamic Range Arnie New Users to Excel 3 June 25th 08 12:46 PM
Dynamic Range jlg5454 Charts and Charting in Excel 2 March 8th 06 05:31 PM
Dynamic Range with unused formula messing up x axis on dynamic graph [email protected] Charts and Charting in Excel 2 February 2nd 06 08:02 PM
dynamic range GEORGIA Excel Discussion (Misc queries) 10 June 29th 05 03:02 AM
Dynamic Range Dan Chupinsky Excel Discussion (Misc queries) 4 May 6th 05 04:18 AM


All times are GMT +1. The time now is 04:23 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"