Random choosing of data in spreadsheet

[davidingilbert]

Hello all.
I am working on a spreadsheet for my company and what I am looking for is a program that will return to me randomly chosen pieces of information that is pulled from a report.
What I need Excel to do is to randomly pull two names from the column called "employee" in relation to another column called "Location".
For example, if I have a spreadsheet with 7 lines under the column "employee" with the name "John Smith" working in a location called "Whitefish Bay" & "Jan Smith" working in a location called "Whitefish Bay" & 6 lines named "Bob Johnson" under "Whitefish Bay".

Out of those 3 sets of names in location of Whitefish Bay, I need something that will randomly choose two "John Smith"s, two "Jane Smith" & Two "Bob Johnson". But I also need the program to be to do the same randomly choosing the same number of employees but with different locations.

Is this even possible?

Thanks.
Dave

PETE UK - you helped me with something similar a few days ago. But it took a different twist.

[mrice]

Try the following which denotes its choice with an X in column 3

Please Login or Register  to view this content.

Open up the VBA editor by hitting ALT F11

Insert a new module by hitting Insert - Module

Paste the macro into the empty sheet

Hit ALT F11 to get back to the worksheet.

Run the macro by going to tools-macro in Excel 2003 or the view ribbon in Excel 2007/2010.