Forum Discussion
evaluating duplicate inputs
There may be some confusion here. As far as I know, there is nothing in the formulas I have written that will not work on-line or on any other hardware platform. Although it looks like code, the formulas are just regular worksheet formulas that use the Excel 365 functions LET and FILTER (I think Google sheets has also implemented the functions) . The use of defined names, rather than direct range references, can cause issues because I don't think Name Manager or the AFE have been implemented within Excel 365 online (if that statement needs to be corrected, I would be delighted to hear).
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!