This video is a follow-on to an earlier video (https://youtu.be/m0_3e9DVtIQ), which looked at one approach to generate random, yet specific values from a list in an Excel spreadsheet.

As previously demonstrated, there was a list of companies, which needed random sales volumes generated by using a customised Excel function.

However, what if we wanted to generate random company names from a list, which would never duplicate any name from the list?

Download Spreadsheet Vault SpreadsheetVault – Random values (no duplicates) from list (solution).xlsb