On Wed, 2006-05-24 at 23:57 +0200, Frederic wrote: > Hello, > > I've 3 numbers in: > > A1: 5 > A2: 4 > A3: 65 > > in B1,B2,B3, the numbers must be sort by ascending > > in c1,c2,c3, the numbers must be sort by descending > > i found function max=(a1:a3) the biggest number is 65, and min=(a1:a3) > and the shortest number is 4 > > what's the function to sort by ascending in column B and descending in > column C >
Try Help > Content > Index > Search term > sorting;options in Data Pilot to use the DataPilot. Probably the best way to get what you want. -- 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]
