Sorry, bad example from me.
I meant something like (A1; T2; X4)
Non-contiguous. Excel allows this in a notation like above. So not a
range of cells.
G. Roderick Singleton wrote:
On Sat, 2005-09-10 at 09:57 +0800, Stephen R. Darragh wrote:
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.
I think you have the syntax wrong. Help says,
"=LARGE(A1:C50; 2) gives the second largest value in A1:C50."
so I would expect your statement to be
=LARGE(a1:a3; 1)
--
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]
