Copying a DV Formula Q

[John]

I have this DV formula, kindly supplied by this NG, and I wish to copy its
relative references down 50 rows, but because of the " " in C10, once I copy
it, it remains at C10. It's easy to change, but is there a quicker way to do
this?

=AND(INDIRECT("C10")<>"",LEN(E10)<=18)


Thanks

 

[Roger Govier]

Hi John

One way
=AND(INDIRECT("C"&ROW(C10))<>"",LEN(E10)<=18)

However, did you notice the posting by Dave Peterson which said he didn't
need to use the Indirect method if you uncheck Ignore Blanks on the DV dialogue.

Try
=AND(C10<>"",LEN(E10)<=18) with the box uncehcked.

Regards

Roger Govier

 

[John]

Thanks Roger, I did but I thought I had it unckecked anyway. These posts
have taught me alot that I didn't know.