A
alfred.cloutier
Weird problem:
I have a formula in a column that was created by pasting values from a
concatenation formula:
Individual cells contain the following text (one cell per line):
A1:"="
B1:"IF("
C1:"$A$17"
D1:">0,MULTICAT("
E1:"$F$17:$F44"
F1:",", "),"")""
G1:"=MULTICAT(A1:F1)"
H1:"=IF($A$17>O,MULTICAT($F$17:$F44,", "),"")"
So, what I did was copy G1 and paste special values into H1, and the
formula printed for H1 appears, but it doesn't actually calculate the
formula unless I manually click the Edit Formula (equal sign button on
the formula bar) and then hit ok.
I need to do this manual edit of the formulas for a whole column of
these, but I would really like to just do it for the whole column at
once. Is this possible?
(Mulitcat is a function that I added on to Excel).
Thanks!
I have a formula in a column that was created by pasting values from a
concatenation formula:
Individual cells contain the following text (one cell per line):
A1:"="
B1:"IF("
C1:"$A$17"
D1:">0,MULTICAT("
E1:"$F$17:$F44"
F1:",", "),"")""
G1:"=MULTICAT(A1:F1)"
H1:"=IF($A$17>O,MULTICAT($F$17:$F44,", "),"")"
So, what I did was copy G1 and paste special values into H1, and the
formula printed for H1 appears, but it doesn't actually calculate the
formula unless I manually click the Edit Formula (equal sign button on
the formula bar) and then hit ok.
I need to do this manual edit of the formulas for a whole column of
these, but I would really like to just do it for the whole column at
once. Is this possible?
(Mulitcat is a function that I added on to Excel).
Thanks!