title: How to loop in excel without VBA or macros?
body: <p>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.</p>
  
  <pre><code>=IF('testsheet'!$C$1 &lt;= 99,'testsheet'!$A$1,"") &amp;
  IF('testsheet'!$C$2 &lt;= 99, 'testsheet'!$A$2,"") &amp;
  IF('testsheet'!$C$3 &lt;= 99, 'testsheet'!$A$3,"") &amp;
  ... and so on through !$C$40, !$A$40 ...
  </code></pre>
  
  <p>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.</p>
  
  <p>I'm pretty good with PHP/SQL, but just learning Excel.</p>