#1
|
|||
|
|||
[HOWTO] -Make Random selection in Excel
Hi Fellow Users,
I need some help. I want to create rotating random selections(teams) in excel Lets say I have a total of 20 cells with data (in this case names) and I need a formula that will divide them in 5 teams (rows) of 4 persons. What is the function I need to use so I will get random rotations without any name appearing twice? |
#2
|
||||
|
||||
Hi,
Essentially what you want to do is put the teams in a random order.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can I make a selection when opening document | shreked | Word | 4 | 01-11-2012 02:32 PM |
how can i make random variant | neezeen | Word | 0 | 11-22-2011 08:08 AM |
Excel 2010 Printing Issues - Random Quality Changes | EW-ARRI | Excel | 2 | 08-18-2011 05:38 AM |
Problem with document map--cannot make selection | Darren2 | Word | 1 | 03-14-2011 03:20 PM |
Howto programetically Create Notebook and sectiongroup in office Onenote 2007 | shobha.swami | OneNote | 3 | 06-19-2009 06:09 AM |