I need to sort an excel spreadsheet (list of customers & locations) into 3 separate random lists (for survey)?

On my excel spreadsheet I have about 400 Company names listed in the rows and as columns have their city, state, zip, etc. I need to sort the data so that every 3rd contact (or row) is somehow exported or separated from the others. I have 3 people who will be using the lists to conduct a market survey and need the random sort so that it is statistically accurate and fair. PLEASE any suggestions are appreciated. It is Excel 2003 and I've already searched the microsoft help page and the internet for help!

I need to sort an excel spreadsheet (list of customers %26amp; locations) into 3 separate random lists (for survey)?
Designate a column and fill it with this formula:


=RAND()


Then sort by that column. This is outside of your "every 3rd" criteria, but you can give third of the list to a person.
Reply:LOL, Michael B got there first! Perfect.
Reply:insert a column in front of the business name column. In the first cell of the new column enter "=RAND" then fill down to the last entry. Highlight that column and select copy. Then rehighlight the column and select paste special. Select "values" as the thing to be pasted. If you don't use paste special, the random numbers will be resampled everytime u try to sort and will make the numbers difficult to reproduce or can get messed up easily. once it is pasted. highlight the entire spreadsheet and click on sort. This basically assigns each item a random number then rearranges them according to those random numbers.