4 ms·
The only thing a super complex formula is missing is the notion of a for loop. In lieu of that, I used to pull a column down as many times as the loop needed to
by crisnoble 11y ago
The only thing a super complex formula is missing is the notion of a for loop. In lieu of that, I used to pull a column down as many times as the loop needed to run. Then I discovered macros, then I discovered javascript.
- mistermann 11y ago> Then I discovered macros, then I discovered javascript. Is the javascript comment somehow related to Excel, or had you moved beyond Excel at that point?
- crisnoble 11y agoI have move beyond Excel, and now I am a web developer. I still have a special place in my heart for overly complex spreadsheets.
- dang 11y agoSome spreadsheet users discover programming and take to it, which is great. Others have the opposite reaction—writing scripts doesn't fit how they like to think or work. It sounds like you are the first kind of user; the ones I was thinking of are the latter.