News for hackers. Stuff that matters.
Re:Array Languages vs. the Curse of the Spreadsheet by analog31 on Tuesday March 05, 2024 @06:02PM (#39610228)
I did exactly that with a VBA macro, that indicated whether something was a formula, a constant, or empty. I would just put it next to my column of calculations. It was not what I would call "clean code" but sure made it easier to follow my thought process and find bugs.

The macro was the first thing that came to mind. Your formula is cleaner.

There are no comments on this comment yet.