On Monday May 29 2006 07:23 am, 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
What about Data > Sort ? This will allow you to sort by one column and then sort further by a second column. Dan --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
