Forum Discussion
Rack of Lambda
There’s been a lot of content shared recently to commemorate the upcoming 40th anniversary of Microsoft Excel. Personally, I’ve only been using Excel for around half that time, but October also marks...
UPDATE: I just added a handful of additional functions to my gist, as well as to the primary sample file attached to this discussion. These include CALENDARRAY, REPTROWS, REPTCOLS, REPTINTV and RANDOMIZE, as well as REDUCE3 and REDUCE5 to compliment SCAN3 and SCAN5. I've also attached a separate sample file for the CALENDARRAY function to demonstrate possible conditional formatting options for highlighting holidays/events on the calendar.
Enjoy!