Forum Discussion
evaluating duplicate inputs
Hello, I have a database of faults itemised by codes and vehicle numbers. Column C is my vehicle number, Column D is a location reference number and Column G is a Fault description. My formula wo...
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!