LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 120
Default Random Selection

I have my 30 students listed in a spreadsheet, I would like to find a way in
excel that I can set up a formula that will randomly pair them up in groups
of 2.

I have them listed like the example below

1 Person A
2 Person B
3 Person C
etc.
I would like the result of the formula to random pair up the students.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Random Selection carl Excel Worksheet Functions 7 June 13th 08 11:12 PM
Random Selection Craig Excel Worksheet Functions 3 September 27th 07 05:18 PM
Random Selection Cookie New Users to Excel 2 May 3rd 06 12:05 AM
Random Selection Cris Excel Worksheet Functions 2 October 16th 05 06:15 PM
How can I set up the random selection of a cell from within a ran. nybbac Excel Discussion (Misc queries) 5 January 1st 05 05:39 AM


All times are GMT +1. The time now is 02:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"