Forum Discussion
CHALLENGE: find column formula for validation of mandatory columns in a table with user data
You are challenged to come up with a solution for the problem described here: My first attempt was to try and use an array formula of the following form: {=SOM(N(ISEMPTY(INDIRECT(<a list of ...
yes that is simpler but I think they required it to work if they added columns and I believe by defining [col1]:[col4] that when you add col5 it doesn't automatically get included. I have done solutions like that where I use [start]:[end] where start and end are 'dummy' columns and tell the user they must insert columns between them if they want them added in.
dear mtarler JosWoolley Detlef_Lewin
just to let you know I am still looking into this and will get back to you in the coming days with an extensive analysis. Conclusion so far is that I still dhave not seen or found a solution.
Regards