ok heres the promise i own a giant collection of information. contained by column 'a' at hand are the year groups. i have need of to arrange the year groups within ascending demand... next i call for to arrange column 'e' into the sexual category of the individuals. how do i do so?
Answers: time of war and peace-
first you are going to highlite adjectives the information on your spreadsheet.
second you will select the selection Data Sort
you can sort by three different columns, so pick the primary to be Column e ---so you will own adjectives females by age later adjectives males by age.
after select Column A as you secodnary sort.
vote OK.
your done
flawless luck :)