I have two lists of 75 items each (we'll call them FirstName and LastName). I need to randomly pick from these two lists to create 75 New FullNames (FirstName, LastName) list, but I only want to randomly pull each item once (to make them unique). I have tried the parameter tool but I get duplicates. I have played with/using Sequential, Unique, and Random but either get duplicates or the original lists sequentially.
Your assistance/code ;-) would be helpful. I am trying to get this done before tomorrow afternoon so I am hoping there is a guru out there to help.
Hold first name as Unique, do not advance with each iteration. Hold second name as sequential advance with each iteration. You now have unique first name/last name combos with no duplicates for up to 75 users. Each gets a unique first name and cycles through the last names. Unique for up to 75 iterations.
Want more uniqueness? Add the alphabet as a middle initial. Pick Randomly. That alone may guarantee uniqueness without having to worry about cycling of the first and last names.