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 ...
Can you clarify why you have marked the third row in Table 2 as TRUE? That row has 'user data' in col1, col2 and col4? Should not col3 contain 'user data'?
Also, I assume from your previous posts that any solution must be for pre-O365 versions of Excel?
Regards