How to use Numbers for automatic selction of pairs

Question

How to use Numbers for automatic selction of pairs

I would like to solve the following problem:
I am organising the monthly meetings of a small bowling club. The members of the club can vary each meeting and some show up but are not bowling.

So I prepareda a table where I can insert the names in the order of arrival and in a second row a check-box bowling Yes/No.
The mode of the game is each player versus each player. That means for five players: the first versus second, third versus forth, first versus fifth and so on.
How can I select the names of the bowling players in sequence of appearance from the table and create pairs of bowler automatically?

Please excuse my bad english, is there a similar forum in german?

Thanks for your help

Posted on Sep 16, 2018 3:21 AM

Reply

Answer 1

Best reply

Yellowbox

Level 7

20,383 points

Sep 16, 2018 7:35 PM in response to uwefromgeestland

Hi Uwe,

Here is a way for 5er. You can fill this formula right and down for 6er etc.

I have split paarung (pairing) into 2 columns so that we can look up a number and match it to a name.

Formula in C2 (and Fill Right and Fill Down)

=INDEX($B,MATCH(Table 2::C2,$A,0))

INDEX($B;VERGLEICH(Table 2::C2;$A;0))

IFERROR will hide the error triangles.

Regards,

Ian.

Reply

Answer 2

Yellowbox

Level 7

20,383 points

Sep 16, 2018 5:31 AM in response to uwefromgeestland

Hi uwe,

Just some ideas to get us started.

Does your blank table look like this?

And after everyone has arrived, does your table look like this?

Keep Table 1 as the attendance record. Duplicate the table (to Table 1-1)

Sort Table 1-1 descending by Column C (Bowling?)

Delete rows for members who are not bowling

Perhaps we are getting towards a solution? I shall have another think, and other users may reply with ideas.

Your English is excellent 🙂.

Edit: Numbers für Mac - Apple Community

Regards,

Ian.

Reply

Answer 3

Sep 16, 2018 6:23 AM in response to Yellowbox

Hi Ian,

thanks for your prompt reply. My arrival table quit the same as yours with one big difference. I omitted the first colum "Order of arrival". I tried to put this information into the "Name Colum" by creating a pull down menu with the available Names and the check box in the second colum.

Ankunft means arrival; Anzahl Spieler means number of bowling members.

The table below is a list who plays versus whom depending on the number of players. My idea was to select the colum according to the "Anzahl Spieler" and replace the digits with the respective names.

I'll try your proposal with the extra colum. It should be possible to reference the cells to the pairs. But is that possible without using a recursive method?

Regards

Uwe

Reply