Can someone help me with excel or google sheets please?

[MagisCapulus]

Ok, so I have a table, picture a calendar format to make it easier. Basically a bunch of squares.

Then each "day" needs to have text in it from either group A or group B. So, taking the calendar example, Mondays would be group A, Tuesdays Group B, Wednesday Group C, Thursdays A, Fridays C etc. Basically whatever group on whatever day.

This text is selected from the group lists. So group A might be a group of animals, group B might be a group of cars. Whatever.

So this could be done with dropdowns. But I want them to auto fill. Maybe press a button to run a script? Then all the "days" would populate, with none of the for eg Mondays being the same animal. or that same animal appearing on the other days Group A animals are selected.

Taking this further, if we added another tab/"month" then it would do the same without again repeating the animals already used. OR only repeating them once the end of the list of animals had been reached - so it would cycle through the list.

Any ideas?

I'm not sure I understand exactly what you mean, but could you populate a sheet with a table with the words you want to use (eg animals) and a number. Then use the look up function and formula such as +1 to autofill?

For a random selection from a list, use a random number generator plus vlookup on a numbered list of items.

@roundtwist

I'm not sure I understand exactly what you mean, but could you populate a sheet with a table with the words you want to use (eg animals) and a number. Then use the look up function and formula such as +1 to autofill?

hmm. could this run as a script? And how would I make it not repeat the list until all of the list has been used?

@TorkTorkBam

For a random selection from a list, use a random number generator plus vlookup on a numbered list of items.

Can you get rid of the numbers once they are used so there are no repeats?

Try this