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
