R1C1, can anyone tell me why this is not working? - Answered myself.

[Spurious]

Hello,

I got the following formula in a .R1C1:

"=IF(RC[-" & ClmDiff & "]=" & RET & ";IF(RC[-" & (LastColumn - Clm) & "]=R[1]C[-" & (LastColumn - Clm) & "];IF(RC[-" & ClmDiff & "]<>R[1]C[-" & ClmDiff & "];1;0);1);0)"

It doesnt work, anyone know why?

I do, I have to replace ; by ,.

Sorry for the spam.

 

[Marcelo Branco]

Hi,

Try change the semicolons (;) to commas (,)

M.

EDIT
I hadnt seen your edited version...