Sometimes it's useful to select a random row or random set of rows in a Microsoft Excel spreadsheet. This can be useful if you want to randomly sample from a dataset, like a list of employees or customers, in o
Edit: it's in 'Selecting a cell in Excel goes to an incorrect cell': https://answers.microsoft.com/en-us/msoffice/forum/all/selecting-a-cell-in-excel-goes-to-an-incorrect/1f64c90e-4a48-475f-890e-e3aa26f3d8f0?page=4&messageId=8a33303f-09f4-41e2-b632...
In all cases, I have used built in trackpad and a 3 different wireless mice (with full batteries). Still randomly occurs. It's really just an annoyance and like I mentioned before, saving the workbook and restarting excel solves the issue... until next time (which could be...
My school does a choice day where students input their top choices (previously we've just said to do top 4 but we could have them pick top 5 or 6 if it helped with the coding/grouping) and then students are assigned to 4 different sessions throughout...
HandFoodler - perhaps it's in a parallel post, but an MS Excel chap Chris Hammond has been looking into this. He asks for feedback sent from the app, not sure how the huge world of MS can pick up and divert to Chris but best to mention his name in any report. This...
HandFoodler- perhaps it's in a parallel post, but an MS Excel chap Chris Hammond has been looking into this. He asks for feedback sent from the app, not sure how the huge world of MS can pick up and divert to Chris but best to mention his name in any report. ...
HandFoodler- perhaps it's in a parallel post, but an MS Excel chap Chris Hammond has been looking into this. He asks for feedback sent from the app, not sure how the huge world of MS can pick up and divert to Chris but best to mention his name in any re...
- perhaps it's in a parallel post, but an MS Excel chap Chris Hammond has been looking into this. He asks for feedback sent from the app, not sure how the huge world of MS can pick up and divert to Chris but best to mention his name in any report. ...
The inputs to the main LAMBDA call include the RANGE with the selection table (must be 1 column as a unique ID followed by any number of picks) and a Table with the list of options and corresponding max # spots for that option. ...
one student might pick Choice 1, 3, 5, 6 and 9 and need to be put into four sessions based on those selections. They might end up in Choice 3 for their first station, choice 1 for their second, and then have to get a random option for their third and fourth sta...