Prevent duplicates when selecting random string from list

[tulipxde]

Hello!

I have created a function for my project that randomly selects a string from a list. Depending on the value of the adjacent cell, my function chooses which list to randomly select a string from. It is working great but I really need to configure it so that it does not select a string that has already been selected (no duplicates). I have a column for the value that determines which list it will select a string from and I have a column for the function that randomly selects a string. What I also have is a column where I manually enter the string that was randomly selected so that it stays locked. I was thinking that perhaps this column could be useful to prevent duplicates but I do not know how.

I have attached the workbook. Column N, P & Q are those that I mentioned above. The lists are located on the third sheet. If anyone is able to figure out how to prevent duplicates I would be immensely grateful.

Note: I tried to give the list rows random values in an adjacent column but that method did not work in my case. I am decently certain I did it right.

[JeteMc]

Hello tulipxde and Welcome to Excel Forum.
This proposal employs a helper column which may be moved and/or hidden for aesthetic purposes.
The helper column on the Lagerplatser sheet (R) is populated using: =RAND()
The formula on the Automatiska påfyllnader sheet that displays the strings is:

Please Login or Register  to view this content.

Note that once the formula has displayed the strings you may select the range (i.e. P3:P10), press the Ctrl + c keys then press the Ctrl + Alt + v keys, select Values and OK.
Let us know if you have any questions.