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) -- PLEASE KEEP MESSAGES ON THE LIST. OpenOffice.org Documentation Co-Lead http://documentation.openoffice.org/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
