•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
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]
Want to read more?
Check out the full article on the original site
Tagged with
#row zero
#Excel alternatives for data analysis
#rows.com
#natural language processing for spreadsheets
#AI formula generation techniques
#generative AI for data analysis
#Excel compatibility
#XLOOKUP
#Excel
#no repeats
#random names
#list of names
#formulas
#unique values
#row of formulas
#Microsoft Office 365
#Excel formulas
#data generation
#spreadsheet
#removal of values