G. Roderick Singleton wrote: > 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.
I found the buttons A/Z (Ascending) and Z/a (Descending) but for school, i must found a function to sort by ascending and descending, i only found fx max (biggest value) and min (smallest value).. See you Frédéric --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
