I asked this question before but it wasn't answered correctly
So i will pose the question again in a different way.
i have a spreadsheet of 3000 company names with associated data
for example...
column A - company name (text) - alphabetical order descending
column B - numbers
I want to sort the list (text - company names) randomly to take the stats of
only 500 companies but randomly chosen. Is there anyway to automatically
scatter column A randomly to accomplish this.
Thanks