indi visual
Member
Normally, because I have no idea what I'm doing (lol), I record a macro and type in the formula. Once I view what the macro recorded I get the R1C1 version.
I need the R1C1 version of the following formulas:
[pre]<br />
=COUNTIF(Z1,"0"<br />
=COUNTIF(Z1,"1"<br />
=COUNTIF(Z1,"2"<br />
=COUNTIF(Z1,"3"<br />
=COUNTIF(Z1,"4"<br />
=COUNTIF(Z1,"5"<br />
=COUNTIF(Z1,"6"<br />
=COUNTIF(Z1,"7"<br />
=COUNTIF(Z1,"8"<br />
=COUNTIF(Z1,"9"<br />
=COUNTIF(Z1,"10"<br />
=COUNTIF(Z1,"11"<br />
=COUNTIF(Z1,"12"<br />
=COUNTIF(Z1,"13"<br />
=COUNTIF(Z1,"14"<br />
=COUNTIF(Z1,"15"<br />
=COUNTIF(Z1,"16"<br />
=COUNTIF(Z1,"17"<br />
=COUNTIF(Z1,"18"<br />
=COUNTIF(Z1,"19"<br />
=COUNTIF(Z1,"20"<br />
=COUNTIF(Z1,"21"<br />
=COUNTIF(Z1,"22"<br />
=COUNTIF(Z1,"23"<br />
=COUNTIF(Z1,"24"<br />
=COUNTIF(Z1,"25"<br />
[/pre]
I tried what I normally do as mentioned above, but for one reason or another when I test the version the macro recorded, it doesn't translate quite right.
Any ideas on how to get this translated to R1C1?
Side note: Any translation help with the formulas above is appreciated, but I cannot have them condensed, they actually all have to remain separate for what I'm doing.
I need the R1C1 version of the following formulas:
[pre]<br />
=COUNTIF(Z1,"0"<br />
=COUNTIF(Z1,"1"<br />
=COUNTIF(Z1,"2"<br />
=COUNTIF(Z1,"3"<br />
=COUNTIF(Z1,"4"<br />
=COUNTIF(Z1,"5"<br />
=COUNTIF(Z1,"6"<br />
=COUNTIF(Z1,"7"<br />
=COUNTIF(Z1,"8"<br />
=COUNTIF(Z1,"9"<br />
=COUNTIF(Z1,"10"<br />
=COUNTIF(Z1,"11"<br />
=COUNTIF(Z1,"12"<br />
=COUNTIF(Z1,"13"<br />
=COUNTIF(Z1,"14"<br />
=COUNTIF(Z1,"15"<br />
=COUNTIF(Z1,"16"<br />
=COUNTIF(Z1,"17"<br />
=COUNTIF(Z1,"18"<br />
=COUNTIF(Z1,"19"<br />
=COUNTIF(Z1,"20"<br />
=COUNTIF(Z1,"21"<br />
=COUNTIF(Z1,"22"<br />
=COUNTIF(Z1,"23"<br />
=COUNTIF(Z1,"24"<br />
=COUNTIF(Z1,"25"<br />
[/pre]
I tried what I normally do as mentioned above, but for one reason or another when I test the version the macro recorded, it doesn't translate quite right.
Any ideas on how to get this translated to R1C1?
Side note: Any translation help with the formulas above is appreciated, but I cannot have them condensed, they actually all have to remain separate for what I'm doing.