J
Jeff McCann
Mr. Sjoblom kindly helped me get values for A:1, A:2, A:3,
etc., placed in B:600, B:603, B:606, etc. (allowing blank
spaces for B601.B602, B604.B605, etc.) with the following
formula and directions:
=INDIRECT("A"&(ROW(3:3/3))
"then F5 => 'special' => uncheck all
except 'constants'=> 'enter'=>'delete.'
Can you suggest how this same format can be accomplished
with use of a conditional, e.g., value for B:600 is A:1 if
A:1=x, (if not, 0); value B:603 =A:2 if A:2=x; etc.?
Your help is very much appreciated.
Jeff McCann
etc., placed in B:600, B:603, B:606, etc. (allowing blank
spaces for B601.B602, B604.B605, etc.) with the following
formula and directions:
=INDIRECT("A"&(ROW(3:3/3))
"then F5 => 'special' => uncheck all
except 'constants'=> 'enter'=>'delete.'
Can you suggest how this same format can be accomplished
with use of a conditional, e.g., value for B:600 is A:1 if
A:1=x, (if not, 0); value B:603 =A:2 if A:2=x; etc.?
Your help is very much appreciated.
Jeff McCann