•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Randomize from a list, with no repeats?
Our take
Are you looking to enhance your board game experience with an Excel sheet that randomly assigns options to players without repeats? If you're currently using Excel 2013, there’s a straightforward way to achieve this. By leveraging Excel's functions, you can create a dynamic setup that ensures each player receives unique selections from your designated list. Explore how to implement this solution seamlessly, allowing for engaging gameplay and streamlined organization.
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:
Is there a way to make it exclude repeats? I'm using Excel 2013.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Generating a random selection of rows based on multiple criteriaI am trying to create a force building tool for a tabletop wargame. I would like it to generate multiple rows of unit info from a table based on certain criteria and have it working for the most part but keep ending up with #SPILL errors. I am sure that there is a much more efficient way of going about this. Here's the overview: https://preview.redd.it/4ghjhqiupksg1.png?width=1256&format=png&auto=webp&s=a6bdc0749397463685bc7f52d8e90f9199fb8d62 The breakdown: A random rom is selected from a table in the worksheet https://preview.redd.it/5telq4v4qksg1.png?width=757&format=png&auto=webp&s=f25aeec460a6b8e5c5750f9d3ff55acaef477658 Then a filter is applied to sort the results according to what is selected in the dropdown menu at B2 https://preview.redd.it/8mt7wxadqksg1.png?width=1236&format=png&auto=webp&s=1e2e6bc4cde488809447de96e1a8d38e8182e8f2 For the most part this method seems to work. The issue is that every few refreshes i get a #SPILL error https://preview.redd.it/ndkvd72nqksg1.png?width=257&format=png&auto=webp&s=57bbb4d9217c9166376c2935a0ce4f85c4b386c0 I have set this formula to run at the bottom of the sheet and ensured there was no data in any cells to the farthest right and down. BONUS: If there is also a way to get this to work and have the random rows be equal to a determined point value. that would be amazing. submitted by /u/simpson95338 [link] [comments]
- How do i control the randomization of the values? (For mapmaking)So i want to create a map in Excel, like an actual fantasy map. The values in the cell are the elevation. Then based on the elevation values, the color changes with conditional formatting. I know I could manually input the values yes but I want to automatically generate them while still keeping a semblance of landmasses. Right now I'm using the RAND() to randomize the values but as you can see the values are all over the place (see image below). How do I control the values randomization so that <0.1 (water) will group together and >0.1 (land) will not be isolated? https://preview.redd.it/816vd1wxpjyg1.png?width=1918&format=png&auto=webp&s=0b29eaa40ffc7f55944549ac2fd1c9f832d2d84d submitted by /u/Irfanugget [link] [comments]
- Help & Advice: I need to make an excel spreadsheet linked to a form that randomly selects ~11 responses/rows & moves those responses to a different tabI am working for a free healthcare clinic, and I desperately need help with excel. For our clinic, interested patients fill out a microsoft form, and then they are randomly selected to be seen by us in the excel spreadsheet linked to the form. However, I have no experience in making this happen in excel. I am working with someone familiar with excel to make this happen, but I wanted to ask this here in case anyone has specific experience and advice in these areas. Ideally, I need: To get a list of 11 random patients/rows/responses from the patient lottery responses To then move those responses off this tab to a “Selected Patients” tab To be able to delete responses every 6 months To automatically delete duplicate responses (likely using duplicate phone numbers) Any help is appreciated - links, tips, etc. Thank you so much. submitted by /u/shrekedyourlastshrak [link] [comments]
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