1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Randomize from a list, with no repeats?

I'm making an Excel sheet for use with a board game, which randomly assigns each player 2 options to choose from, pulled from a list in a separate sheet. Here's how it currently looks:

https://preview.redd.it/6b1v9aghikmg1.png?width=1487&format=png&auto=webp&s=fc2c0138cebb54d113ee1394a7b34984dde6e485

Is there a way to make it exclude repeats? I'm using Excel 2013.

submitted by /u/Crixler
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#Excel compatibility
#Excel alternatives
#rows.com
#financial modeling with spreadsheets
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel
#exclude repeats
#board game
#Excel 2013
#no repeats
#randomly assigns
#randomize
#options
#separate sheet
#player
#list
#options to choose from
#assignments