[users] OOo Calc Tip

[James Lang]

The MODE function in calc only works if some value appears more than once. 
This is documented.

I have found a way to extend its functionality to the instance where all of 
the values are unique:

IF(ISNUMBER(ERRORTYPE(MODE(reference)));MIN(reference);MODE(reference))

--
Jim

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]