Re: Alternating sort question

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 spread*** 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

.

Quantcast