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 ...
It's not clear why you would use INDIRECT().
Maybe I don't understand the 'challenge'.
=LET(
t,table_2,
r,INDEX(t,ROW()-ROW(table_2[#Headers]),0),
a,FILTER(r,COUNTIFS(table_1[mand cols],table_2[#Headers])),
b,FILTER(a,a<>0),
c,COUNTA(b)=COUNTA(table_1[mand cols]),
IF(COUNTA(b)>1,c,IF(ISERROR(b),FALSE,c)))