Adjusting a formula cell range

[Guest]

I have a formula that uses cells D220, the problem is the info that it is
using is updated through a query, so I might need the range to be D230, if
I set the range to larger than what i need it causes an error in the formula,
is there a way to make excel recognize whether there is a value in the cell
or not and include it in the formula range so the formula range floats with
the data that arrives through the query.

Thanks

 

[Daniel CHEN]

Use the following to create a dynamic range:

OFFSET(D2,0,0,COUNT(D299),1)

Replace D220 in your formula with the above dynamic range.
99 can be changed to any big number.

--
Best regards,
---
Yongjun CHEN
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download
Free Excel / VBA Training Materials is Available for Download
=================================