The simple answer is no. Calc's LARGE function works with a single range of cells rather than a non-continuous group of cells.
Dan On Friday 09 September 2005 09:29 pm, Stephen R. Darragh wrote: > 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) --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
