Random selection (no duplicates) from a list in Excel

Download the example workbook for creating a random selection (no duplicates) here:

Goal: Generate random company names from a list, which will never duplicate any name from the list.

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?

[shjyoutuization]

Thank you for this demonstration, it is perfect for my needs.

[ubaidillahmuhammad]

nice. but please given the file, sir.