Array Formula Clarity

[David Evans]

I have an array formula that returns the following
{FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;TRUE;FALSE}

I want to return the position of the second TRUE as a Row Number in the array, but I cannot get my head around it this morning ...

Any help is greatly appreciated.

D

 

[eibi]

{=SMALL($A$1:$A$8*ROW($A$1:$A$8),COUNTIF($A$1:$A$8,"=FALSE")+2)}

or

{=LARGE($A$1:$A$8*ROW($A$1:$A$8),COUNTIF($A$1:$A$8,"=TRUE")-1)}

perhaps?

or as an alternative to COUNTIF()

{=LARGE($A$1:$A$8*ROW($A$1:$A$8),SUM(--$A$1:$A$8)-1)}

 

[David Evans]

{=SMALL($A$1:$A$8*ROW($A$1:$A$8),COUNTIF($A$1:$A$8,"=FALSE")+2)}

perhaps?

Thanks for your help - I came up with something similar but appreciate your help. I was working on a simpler solution for another Chandooer .....

 

[bines53]

Hello friends,

Another way, without CSE

=AGGREGATE(15,6,ROW(A1:A8)/(A1:A8=TRUE),2)

David

 

[John Jairo V]

Hi to all!

@bines53... your formula could using like this:
=AGGREGATE(15,6,ROW(A1:A8)/A1:A8,2)

=TRUE is not needed. Blessings!

 

[bines53]

Hi John,

You are the master, whatever you say, I accept.