I would like to know how I can get excel to randomly select one line of data for each of the people listed below (so one for bob, one for jenny, one for Trish etc.). I have been trying a mixture of vlookup and rand but to no avail, below is just a sample list but i would like to try it on a large set of data. any ideas of method would be greatful, i have been able to get a random transaction but not one for each person.
REF_ID NAME DATE BILL TOTAL
BA2234340 Bob 10/12/2012 € 22.00
BA7377373 Jenny 11/12/2012 € 45.00
BA6326363 Paul 19/12/2012 € 29.00
BA6366363 Mary 14/12/2012 € 51.00
BA6363663 Max 11/12/2012 € 21.00
BA4545394 Pat 14/12/2012 € 28.00
BA0028737 Neil 11/12/2012 € 37.00
BA7326722 Katy 14/12/2012 € 33.00
BA1111123 Trish 10/12/2012 € 12.00
BA7324734 Max 14/12/2012 € 124.00
BA7324732 Trish 10/12/2012 € 33.00
BA8934832 Max 11/12/2012 € 44.00
BA2345566 Trish 14/12/2012 € 55.00
BA0000333 Bob 18/12/2012 € 57.00
BA9999999 Bob 14/12/2012 € 8.00
BA7777777 Bob 01/12/2012 € 97.00
BA4432444 Benny 11/12/2012 € 87.00
Jenny
Paul
Mary
Max
Pat
Neil
Katy
Trish
Benny
REF_ID NAME DATE BILL TOTAL
BA2234340 Bob 10/12/2012 € 22.00
BA7377373 Jenny 11/12/2012 € 45.00
BA6326363 Paul 19/12/2012 € 29.00
BA6366363 Mary 14/12/2012 € 51.00
BA6363663 Max 11/12/2012 € 21.00
BA4545394 Pat 14/12/2012 € 28.00
BA0028737 Neil 11/12/2012 € 37.00
BA7326722 Katy 14/12/2012 € 33.00
BA1111123 Trish 10/12/2012 € 12.00
BA7324734 Max 14/12/2012 € 124.00
BA7324732 Trish 10/12/2012 € 33.00
BA8934832 Max 11/12/2012 € 44.00
BA2345566 Trish 14/12/2012 € 55.00
BA0000333 Bob 18/12/2012 € 57.00
BA9999999 Bob 14/12/2012 € 8.00
BA7777777 Bob 01/12/2012 € 97.00
BA4432444 Benny 11/12/2012 € 87.00
Jenny
Paul
Mary
Max
Pat
Neil
Katy
Trish
Benny