I'm piecing together an Excel formula which is just a series of smaller formulas
Some formulas R actually text literals. Others R formulas 4 variable data
It's not difficult, but it can be tedious making sure output looks correct
It's not difficult, but it can be tedious making sure output looks correct
Playing with formulas for over a decade. They can be fun and tricky sometimes.
I'm experimenting w/ OFFSET() as an EZ way 2do lookups. I'm also using TEXT() 2handle formatting datetimes inline. Everything else is either literal text or a reference to a static value. Markdown is the reason I'm building these formulas.