How to loop in excel without VBA or macros?
- by Jeff
Is there a better way for me to write this formula? Did some googling on "excel loops," but no luck. I don't have VBA or macros installed (it's not an option to install them, unfortunately).
=IF('testsheet'!$C$1 <= 99,'testsheet'!$A$1,"") &
IF('testsheet'!$C$2 <= 99, 'testsheet'!$A$2,"") &
IF('testsheet'!$C$3 <= 99, 'testsheet'!$A$3,"") &
... and so on through !$C$40, !$A$40 ...
As it is, I'll have to repeat the above code 40 times in each cell and I have over 200 cells which need the code. sniff
I'm pretty good with PHP/SQL, but just learning Excel.