S
Shub
I wish to produce a list of alternately male and females records.
With a gender field, how could this be achieved?
With a gender field, how could this be achieved?
D
Debra Dalgleish
With Gender in column B, create a new column for Count.
With the first gender in B2, enter the following in row 2 of
the Count column:
=COUNTIF($B$1:B1,B2)+1
Copy the formula down to the last row of data
Select a cell in the table
Choose Data>Sort
Sort by Count, then by Gender
With the first gender in B2, enter the following in row 2 of
the Count column:
=COUNTIF($B$1:B1,B2)+1
Copy the formula down to the last row of data
Select a cell in the table
Choose Data>Sort
Sort by Count, then by Gender
S
Shub
Many thanks
You can not believe how many people I've asked - who should know - how to do
this!
You can not believe how many people I've asked - who should know - how to do
this!