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]
