Here is a variation on my original suggestion, which makes it easier to get multiple selections from a single database.
A. Worksheet with two tabs: 'Database' and 'Results'
On the Database sheet:
1. One database of names and criteria
2. A sequence table with all required combinations of criteria, and calculating the required sequence numbers:
with three components to the table -
a. A selection number in the first row
b. Criteria in rows 2 and 3
c. Sequence numbers starting in row 4
3. A linked copy of the names to the immediate right of the sequence table
On the Results sheet
1. A table with criteria headings and results for each criteria combination
Start the database of names with the first name in Cell A4
the criteria for the the first name are in cells B4 and C4
A B C
3 Name Criteria 1 Criteria 2
4 Sam Roberts Male Tall
5 Jill Roberts Female Tall
6 Arthur Buck Male Short
7 Tina Buck Female Short
8 Joan Armistice Female Tall
9 Bill Pertwee Male Tall
10 Billy Downturn Male Tall
11 Emily Banker Female Short
The sequence table has three parts:
In cell G1 enter 1, in H1 2, I1 3 and J1 4
(For this example there are four possible combinations of criteria).
In cells G2 to J2 enter Criteria 1 values
In cells G3 to J3 enter Criteria 2 values
(see example below)
In cell G4 enter this formula:
Drag this formula down to G11
then select G4 to G11 and drag the formulas across to column J
Cell J11 should have the following in it:
In cell K4 enter =A4
Drag the formula down to K11
This will provide a linked copy of the names in the database
The table (with headings) looks like this:
F G H I J K
1 Selection # 1 2 3 4
2 Criteria 1 Male Female Male Female
3 Criteria 2 Tall Tall Short Short Names
4 1 Sam Roberts
5 1 Jill Roberts
6 1 Arthur Buck
7 1 Tina Buck
8 2 Joan Armistice
9 2 Bill Pertwee
10 3 Billy Downturn
11 2 Emily Banker
In the Results worksheet:
In cells B3 to B9 enter the numbers 1 through 7
In cell C2 enter the following formula:
=Database!G2 & ", " &Database!G3
Drag the formula across to cell F2
This gives a descriptive selection heading for each result.
This heading is not part of the calculations, so can be changed to suit.
In cell C3 enter the following formula:
Note: I have split the formula onto two lines for ease of viewing.
Drag this formula down to C9 then drag C3 to C9 across to column F
Cell F9 should have the following in it:
This is what the results table looks like:
B C D E F
2 Count Male, Tall Female, Tall Male, Short Female, Short
3 1 Sam Roberts Jill Roberts Arthur Buck Tina Buck
4 2 Bill Pertwee Joan Armistice Emily Banker
5 3 Billy Downturn
I didn't include any instructions for adding most of the headings to columns, but you can see what I did in the examples above.
The Columns in the results table can be moved independently, and could be on separate pages - but it was easier to create one formula and drag it across a single table.
The $ signs in formulas are important as they allow the formulas to extend properly when dragged in different directions.
The results formulas e.g., in cell C3 include 6-Database!G$1
This uses the selection numbers in the sequence table, so that VLOOKUP() knows how many columns to the right is the list of names.