Complex countif of array elements

Hi Folks!

This is extremely difficult to try to explain, so ........

I have this portion of an array formula:

SMALL(IF(OFFSET(INDEX($A$2:$A$10,MATCH($A13,$A$2:$A$10,0)),,4,,-4)=MAX($B$2:$E$10),COLUMN($B1:$E1)-COLUMN($B1)+1)

For each element of::

OFFSET(INDEX($A$2:$A$10,MATCH($A13,$A$2:$A$10,0)),,4,,-4)

The formula returns an array like:

1,1,FALSE,1

Does anybody know a way to count the nth SMALL value generated in that
array?

Something like:

SMALL({1,1,FALSE,1},1) = 3

Biff

Ooops!

Disregard, I posted the wrong formula!

Biff

"Biff" <[email protected]> wrote in message
news:%[email protected]...
> Hi Folks!
>
> This is extremely difficult to try to explain, so ........
>
> I have this portion of an array formula:
>
> SMALL(IF(OFFSET(INDEX($A$2:$A$10,MATCH($A13,$A$2:$A$10,0)),,4,,-4)=MAX($B$2:$E$10),COLUMN($B1:$E1)-COLUMN($B1)+1)
>
> For each element of::
>
> OFFSET(INDEX($A$2:$A$10,MATCH($A13,$A$2:$A$10,0)),,4,,-4)
>
> The formula returns an array like:
>
> 1,1,FALSE,1
>
> Does anybody know a way to count the nth SMALL value generated in that
> array?
>
> Something like:
>
> SMALL({1,1,FALSE,1},1) = 3
>
> Biff
>
>
>