I've created a dynamic named range called "Ingredients" using the following formula:
=OFFSET('Ingredient Cost Sheet'!$A$1,1,0,COUNTA('Ingredient Cost Sheet'!$A:$A)-1,1)
I then used that dynamic named range to setup a drop down menu which worked beautifully when I had a heading that used one row, but I now have a heading that encompasses 4 rows, and I can't figure out how to make the named range omit the first 4 rows of the column. I thought the following formula change would do it, but no go:
=OFFSET('Ingredient Cost Sheet'!$A$1,1,0,COUNTA('Ingredient Cost Sheet'!$A:$A)-4,1)
Here's a quick screen shot of my sheet:
Dynamic Range.jpg
Thanks a bunch.
(Using Excel 2003 if that makes a difference)
Bookmarks