Forum Discussion
element of a column equal any element of a list
Not exactly. I'm not sure on what the user ticks and what is generated as result. The key is generated list is the reference, i.e. part of the grid, or an array generated by the formulae. If the latest that could be like
=LET(source, TOCOL(C:C,3), targets, {"c111";"c151"}, NOT( ISNA(XMATCH( source, targets))) )for the
It is calculated.
Essentially the users of the spreadsheet tick options of what comes into the list so it will change and the formula needs to be able to recalculate as the options are ticked in/out.
Was that what you were asking ?
Not exactly. I'm not sure on what the user ticks and what is generated as result. The key is generated list is the reference, i.e. part of the grid, or an array generated by the formulae. If the latest that could be like
=LET(source, TOCOL(C:C,3), targets, {"c111";"c151"}, NOT( ISNA(XMATCH( source, targets))) )for the
You are welcome
SergeiBaklan, Genius !
That worked, Thank you soo much