Re: Alternating sort question
- From: Pete_UK <pashurst@xxxxxxxxxxx>
- Date: Sun, 27 Apr 2008 12:34:29 -0700 (PDT)
Perhaps you could sort by gender first to get all the F's together
then all the M's. Then fill a sequence down a helper column 1, 2, 3
etc for just the females. Fill a new sequence 1, 2, 3 etc down the
column for just the males. Then you can sort the data plus the helper
column using the helper sequence as the sort key (plus gender as the
second key), and then you will get the sequence 1_F, 1_M, 2_F, 2_M,
3_F, 3_M etc. You can delete the helper column then.
Obviously, if you have more of one gender then these will all appear
together at the end.
Hope this helps.
Pete
On Apr 27, 8:17 pm, GaryM <Ga...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
My wife is working on a spreadsheet for a class roster and one column
specifies gender (M,F). She would like to sort the students by alternating M
& F instead of all M and then all F to assign a seating chart. Is this
possible? Thanks in advance!
GaryM
.
- References:
- Alternating sort question
- From: GaryM
- Alternating sort question
- Prev by Date: Re: calculation problem
- Next by Date: Conversion
- Previous by thread: Alternating sort question
- Next by thread: Re: Alternating sort question
- Index(es):
Relevant Pages
|
