Seriously awesome! I can think of several different applications for this method/process! The first one I am going to use it for will be walking through a demo on how to build out complex series of layered formulas using the show/hide rows method to walk through the stages of the formula build process. Permission to include a link to this video where I drew the the inspiration from please.
Very clever, Wyn. Thanks! Incidental benefit to me from this tutorial was learning your naming convention for LET parameters: i.e., begin with _. I have prefixed mine with “v” (for variable) since LET was released to GA, but see that _ is better: stands out a bit more in the “code”; sorts to top in Intellisense. I’m switching. Thanks! BTW, when i write long/complex LET statements (fairly often), I document them with lines of (without ). Comes in handy when i go back to an old workbook that breaks or otherwise needs to be updated.
Thanks. Nice documentation tip Jim. It’s such a shame we don’t have // as an option. Maybe one day we’ll have something like the Advanced Formula Editor built in as standard
Cool! Just be careful when sharing this file with users that don't have "English" as a language. Formulas translate themselves, but the parameters in "CELL" do not and will most likely throw you an error.
