I'm having trouble getting an array expression to work in calc. What I want is this:
{ COUNT( (MIN(B2:B10; C2:C10) = B2:B10) ) } That is, count the number of rows in which the minimum across columns B and C is in column B. The expression MIN(B3; C3) = B3 works fine when entered in an individual row... Any help would be much appreciated. I do know to use <ctrl><shift><enter> Thanks, Gary --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org