Dynamic Lists

N

Nandhu

I have created a dynamic list usin
=OFFSET(SETUP!$C$100,0,0,COUNTA(SETUP!$C$197:$C$200)) and defined
name as above, i used this name in a list under data validation,
the range i specified has formulae,
The dynamic lists seems to work only for cells with values not an
formula.
the combo where i used this name is listing all blank values 10
entries even if formula evaluates to "".
*How can i create dynamic lists for cells with formula?
 
J

JulieD

Hi Nandhu

you're saying start the list at C100, but only count the number of items
between row 197 & 200 (ie 3 rows)
change the 197 to 100 and it should work.

Cheers
JulieD
 
F

Frank Kabel

Hi
try something lik
=OFFSET(SETUP!$C$1,0,0,SUMPRODUCT(MAX((SETUP!$C$1:$C$200<>"")*(ROW(SETUP!$C$1:$C$200)))))
 
Top