Posted By: Anonymous
Is it possible to iterate (loop) a group of rows in Excel without VBA or macros installed? A web search didn’t yield anything helpful.
=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.
I’m pretty good with PHP/SQL, but just learning Excel.
The way to get the results of your formula would be to start in a new sheet.
In cell A1 put the formula
=IF('testsheet'!C1 <= 99,'testsheet'!A1,"")
Copy that cell down to row 40
In cell B1 put the formula
In cell B2 put the formula
=B1 & A2
Copy that cell down to row 40.
The value you want is now in that column in row 40.
Not really the answer you want, but that is the fastest way to get things done excel wise without creating a custom formula that takes in a range and makes the calculation (which would be more fun to do).