Forum Discussion
Solved
Get first TRUE boolean position from array formula
Hi!
Is it possible to get the first TRUE boolean position from an array formula? The array formula has results like this: FALSE;TRUE;FALSE;FALSE;FALSE
I want to get the position of the first TRUE, so in this situation it would be 2.
I've tried =MATCH(TRUE;myarrayfunction), but it didn't work. I don't wanna use VBA.
You skipped the third argument in the Match formula and you should use False or 0 as the third argument for the exact match like this...
=MATCH(TRUE;myarrayfunction;0)
1 Reply
You skipped the third argument in the Match formula and you should use False or 0 as the third argument for the exact match like this...
=MATCH(TRUE;myarrayfunction;0)