Get first TRUE boolean position from array formula

[MrBond]

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.

[#2 · Accepted solution]

@MrBond 

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)