Claudia Drechsle wrote: > Hi >> 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).. >> > > - Mark the whole table > - Menu: Data/Sort > You can choose for each column ascending or descending. > > Functions like MAX can only give you one result in one cell, but not sort y > whole table. As I see the only functions that might help are SMALL and > LARGE in combination f.e. with ROW. > The formula: =SMALL($A$1:$A$15;ROW()) will sort A1:A15 ascending and the > formula LARGE($A$1:$A$15;ROW()) will sort it descending. But I've yet no > idea how to proceed with 2 columns. > > so long > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > >
Thank you very much, i'll try it. See you soon!!! Frédéric --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
