I am stuck

[Ujpest]

The numbers represent rounds.

So a name will go with a round (number) but some names know more than one
round.

Name a 1
name b 2
name c 3

name d knows round 1 and 2
name e knows round 2 and 3

Is there an automatic function that would allocate "name d" or "name e" to a
round if "name a, b or c" were not available for that day?

The table would look like this

Name a 1
name b 2
name c 3
name d
name e

Say for example "name a" was not available how would "name d" get allocated
to round 1

 

[zvkmpw]

The numbers represent rounds.

So a name will go with a round (number) but some names know more than one
round.

Name a       1
name b       2
name c       3

name d knows round 1 and 2
name e knows round 2 and 3

Is there an automatic function that would allocate "name d" or "name e" to a
round if "name a, b or c" were not available for that day?

The table would look like this

Name a       1
name b       2
name c       3
name d
name e

Say for example "name a" was not available how would "name d" get allocated
to round 1

Not quite sure exactly what's intended here, but maybe this will help
get started.

I put the prescribed data in columns A1:B3 with the two extra names in
A4:A5.

Then I put this in B4:
=IF(COUNTIF(B1:B3,1)=0,1,IF(COUNTIF(B1:B3,2)=0,2,""))
and this in B5:
=IF(COUNTIF(B1:B4,2)=0,2,IF(COUNTIF(B1:B4,3)=0,3,""))

With this setup, I can delete any one number from B1:B3, or any two of
them, and the extra names get allocated the unassigned rounds.