0

I would like to create several Named Ranges in Excel that collect values in each column until the cell in a different row is blank. So for instance I have a Named Range called Weeks and the range is from DB3 to FA3. I would to dynamically get all the values until a blank is found in row 4. So if a blank is found at EO4, my Weeks range would pull in values from DB3 to EO3. Does that make sense? I am using Excel 2010 by the way. Thanks Mike

dmikester1
  • 1,374
  • 11
  • 55
  • 113

1 Answers1

2

define the name as =OFFSET($DB$3,0,0,1,COUNTA($DB$3:$FA$3))

This is using the info from ozgrid

SeanC
  • 15,695
  • 5
  • 45
  • 66
  • That last part COUNTA($DB$3:$FA$3)) just needs to be switched to COUNTA($DB$4:$FA$4)) or whichever row I am checking for empty data and it works perfect! Thank you! – dmikester1 Oct 02 '12 at 21:47