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

Complex countif of array elements
 

Ooops!

Disregard, I posted the wrong formula!

Biff

"Biff" wrote in message
...
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