Complex countif of array elements

  • Thread starter Thread starter Biff
  • Start date Start date
B

Biff

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
 
Back
Top