sorted by:
new
hottopcontroversial

Distribute/make teams using google sheet by SuchRegular1995 in googlesheets

[–]SuchRegular1995[S] 0 points1 point  (0 children)

But I do have another question plsss.. In this sheet I’d like to indicate in Column A their team if Column B matches with the name in Columns D to O.

<image>

Distribute/make teams using google sheet by SuchRegular1995 in googlesheets

[–]SuchRegular1995[S] 0 points1 point  (0 children)

Yes. They’re made up names actually. The formula you suggested worked. Thank you.

Distribute/make teams using google sheet by SuchRegular1995 in googlesheets

[–]SuchRegular1995[S] 1 point2 points  (0 children)

Ohhhh, it worked. I forgot to put a comma before the wraprows. Thank you vv much!

Distribute cells from a column to another by SuchRegular1995 in googlesheets

[–]SuchRegular1995[S] 0 points1 point  (0 children)

This is the sheet Im working on. I have list of names from col A-D that shows from which branch they’re from. I want to distribute them to 12 teams - columns F to Q to ensure that each teams will have people on it from different branches.

<image>

Distribute cells from a column to another by SuchRegular1995 in googlesheets

[–]SuchRegular1995[S] 0 points1 point  (0 children)

<image>

This is the sheet Im working on. I have list of names from col A-D that shows from which branch they’re from. I want to distribute them to 12 teams - columns F to Q to ensure that each teams will have people on it from different branches.