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
Bookmarks