Forum Discussion
Using custom data validation with regex on cells
Thank youPeterBartholomew1
I will probably stick to google sheets if that's the case.
The document need to be given to other people to use And if i will use 365 insider or some other solution, it wont work those people probably. Cause they will have other versions of office.
I see you point. If you share with people that use Google sheets it make sense to retain compatibility. The particular add-in that I showed comes with a run-time version that can be shipped to clients (involves a one-off fee).
For me the issues are very different. Having once described the A1 notation as an abomination that should never have entered the world of the electronic spreadsheet, I am only too happy to enter the world of dynamic arrays and build solutions as if they were regular code.