I have a named range in Excel called DC01 and it contains 2 columns. The columns could contain a 100 rows one week and 5 rows the next. Because the size of the range changes each week I want to make the range dynamic. I am using the following formula:
This does not include the second column.
Could someone help me with this formula so both columns are dynamically named?