Forum Discussion
evaluating duplicate inputs
Thanks Sergei. That is useful to know. Perhaps I should try the cloud version of Excel again! As you will have observed, I only use named arrays to build solutions, so my experience of using Excel on-line from a couple of years ago was not encouraging.
Oh, if you don't use VBA, data models (Power Pivot with Power Query), some functions like CELL("filename") and don't try to align text vertically - Excel for web works even better.
I did go through a phase where every workbook I wrote seemed to require VBA event handlers to operate. By way of example:
2048 game version for Excel (spreadsheet1.com)
I even used VBA classes and events to synchronise a process diagram created by linking shapes with connecters with the underlying data structure defining the process. I would be hard pressed to repeat that now but building a solution comprising one Lambda function per sheet offers some compensation!