•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Generating random names from a list without repeats
Our take
Are you tired of generating random names from a list only to find repeats? With Microsoft Office 365, you can harness the power of XLOOKUP to create a series of formulas that deliver unique names without duplication. Imagine a row where each formula seamlessly eliminates the names already chosen to ensure variety. In this guide, we'll explore how to set up these XLOOKUP formulas effectively, transforming your approach to random name selection while enhancing your productivity.
I trying to make a row of XLOOPUP formulas in a row that are all the same but as you move right along the row, the value of the one to the left is removed.
For example: I have a list of 10 names and i want five XLOOKUP formulas to give five different names without repeat. So if the first formula comes up as Charlie, I don't want any of the other formulas to come up as Charlie
Using Microsoft Office 365 home.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience