Brian Barker <[EMAIL PROTECTED]> wrote: > At 21:09 26/12/2007 +1300, Zed Noname wrote: > > I have recently started using Calc and am having difficulty in sorting > > columns. Let me explain. > > > > I have two columns. The first one has First Names listed and the second > > (to the right) has Family Names, for example > > > > Alec Mackintosh Cedric Humblebee David Whistleton Edward > > Aldeburgh > > > > I want to sort them so they appear as follows: > > > > Edward Aldeburgh Cedric Humblebee Alec Mackintosh David > > Whistleton > > > > I have been into Data/Sort and endeavoured to choose the family name (in > > alphabetical order) to sort by and tried to change the parameters but > > try as I might, I cannot achieve what I want. > <snip> > > To sort the cells: o Go to Data Sort... . o On the Options tab, remove > the tick from "Range contains column labels" - unless your columns have > labels. o On the Sort Criteria tab, select "Column B" (or wherever your > family names are) - or the column label for them - under "Sort by". o > Also on the Sort Criteria tab, select "Column A" or your first names > column label under "Then by". o Press OK.
<snip> > I trust this helps. Indeed it did help, Brian. Thank you for the very clear explanation. I can now do what I wanted to. -- zed --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
