Split randomly names into 6 different groups [closed]

Question

Closed. This question needs details or clarity. It is not currently accepting answers.

Want to improve this question? As written, this question is lacking some of the information it needs to be answered. If the author adds details in comments, consider editing them into the question. Once there's sufficient detail to answer, vote to reopen the question.

Closed 22 days ago.

Improve this question

is there any formula which will help me split randomly a dynamic list of names into 6 different groups?.

I would like each group to have as equal as possible amount of names.

Here is a google sheet example:https://docs.google.com/spreadsheets/d/1ChIGf3WyfUzEsdCH8VfxaJDa7QNDJb8VIhBfV7p8b-w/edit?gid=0#gid=0

Questions should be self-contained and not rely on external links. Please edit your question and insert a table of sample data together with another table that shows your manually entered desired results. — doubleunary
– doubleunary, Commented Oct 27 at 11:34

doubleunary · Accepted Answer · 2025-10-27 11:29:23Z

2

Use wraprows(), sort() and randarray(), like this:

=wraprows(sort(tocol(A2:A, 1), randarray(counta(A2:A)), true), 6,)

The results will update every time you modify the spreadsheet. To fix the groups in place, use copy-paste as values (Edit > Paste special > Values only.)

See wraprows(), sort(), randarray() and your sample spreadsheet.

answered Oct 27 at 11:29

doubleunary

21.9k13 gold badges38 silver badges84 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

DaveL17 · Accepted Answer · 2025-10-27 11:19:33Z

0

You can use this formula in Google Docs to make six random groups of names!:

=MOD(RANK(RAND(), $A$2:$A), 6) + 1

This is what each individual command does:

RAND() assigns each name a random decimal
RANK() orders those randomly
MOD(..., 6) + 1 splits into 6 roughly equal groups

edited Oct 27 at 11:19

DaveL17

2,06110 gold badges30 silver badges48 bronze badges

answered Oct 27 at 11:14

Angelina B

1

1 Comment

RyuukuS Oct 27 at 11:23

Thank you for your input, unfortunately am getting error message "RANK has no valid input data.". I have added editor access to example sheet if you want to try yourself as i might miss something. Thank you once more for your answer.

Collectives™ on Stack Overflow

Split randomly names into 6 different groups [closed]

2 Answers 2

Comments

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Related