[users] Calc question: sets of non-contiguous cells

[Stephen R. Darragh]

Hi all -

I'd like to know how (or if it's indeed possible) to use a set of 
non-contiguous cells in a function like LARGE().

For example, in Excel I can use

LARGE((A1,A2,A3), 1)

but the equivalent in OpenOffice (1.9.125)

LARGE((A1; A2; A3); 1)

gives a 508 (mis-matched pair) error.

--
Stephen Darragh
Technical Director
Informed Technology
Ph: +61 8 9380 4244  Fax: +61 8 9380 4354

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