software

I have compiled a spreadsheet which uses the following dependant validation
formula. Is there a way to copy the validation amp; it's formula to all cells in
that column without incrementing the source.

E.g. replicate $A134 and A134 without next cell becoming $A135 and A135 etc=OFFSET(INDIRECT($A134),0,0,COUNTA(INDIRECT(A134amp;quot; Colquot;)),1)
Fix A134 by using the quot; $ quot; sign i.e. $A$134 in both occurrences in the formula

quot;martbquot; wrote:

gt; I have compiled a spreadsheet which uses the following dependant validation
gt; formula. Is there a way to copy the validation amp; it's formula to all cells in
gt; that column without incrementing the source.
gt;
gt; E.g. replicate $A134 and A134 without next cell becoming $A135 and A135 etc
gt;
gt;
gt; =OFFSET(INDIRECT($A134),0,0,COUNTA(INDIRECT(A134amp;quot; Colquot;)),1)
gt;
gt;