One construct which will deliver it here ..

In Application,
Data/Formulas is running in L2 down,
with possibility of blank intervening cells or cells containing formula
blanks: ""
In M2: =IF(L2="","",ROW())
In N2: =INDEX(L:L,SMALL(M:M,ROWS($1:1)))
Copy M2:N2 down to cover the max extent expected in col L

Then you could use this amendment of your posted expression (pointing now to
col N) as the dynamic range for your DVs elsewhe
=Application!$N$2:INDEX(Application!$N$2:$N$100,SU MPRODUCT(--ISNUMBER(Application!$N$2:$N$100)))

The above dynamic range will return the required compacted list devoid of
intervening blanks in the DVs
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:370 Subscribers:66
xdemechanik
---
"The Narcissist" wrote:
I'm using some dynamic ranges on an excel file I'm working on. One range has
a problem though. The column contains fomulas and the default result is a
blank. When I reference this range, it also takes in the blank values. This
is impacting some other fomulas on the file. Is there a way I can modify the
range to exclude blanks?

This is how the range is defined.

=Application!$L$2:INDEX(Application!$L:$L,COUNTA(A pplication!$L:$L))