Description:
Need to randomly group data in Excel? This video shows two easy methods:
① For Microsoft 365 users, use the WRAPROWS + RANDARRAY formula to create balanced random groups automatically;
② For all Excel versions, use CHOOSE + RANDBETWEEN for a simple lottery-style grouping — quick to set up but groups may be uneven.
Group your data instantly without manual work!
Share this link via
Or copy link