User Profile
tomsuters
Copper Contributor
Joined 2 years ago
User Widgets
Recent Discussions
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 cell references to the mandatory cells in a row>)))=0} I failed as it turned out that EXCEL does not allow the INDIRECT() function to be used in array formulas and you need INDIRECT() to create the list of references to the mandatory cells in a row of table 2 from the column names in table 1. I found a similar task with the same problem here:excel - Is it possible to have array as an argument to INDIRECT(), so INDIRECT() returns array? - Stack Overflow I look forward to your suggestions. Please bear in mind that the formula should not be changed if the content of table 1 is changed!
