Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
random of 4 names
Have cells B4 to B84 with names in them in cell C4 to C84 have 4
differance titles in it, in cell E I need one of each title in blocks of 4 at random |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
random of 4 names
The first step is to sort the data by title, Here is typical B4 thru
C84, sorted: Michael Baron William Baron David Baron Richard Baron Charles Baron Joseph Baron Thomas Baron Christopher Baron Daniel Baron Paul Baron Mark Baron Donald Baron George Baron Kenneth Baron Steven Baron Edward Baron Brian Baron Ronald Baron Anthony Baron Kevin Baron Jason Baron Matthew Duke Gary Duke Timothy Duke Jose Duke Larry Duke Jeffrey Duke Frank Duke Scott Duke Eric Duke Stephen Duke Andrew Duke Raymond Duke Gregory Duke Joshua Duke Jerry Duke Dennis Duke Walter Duke Patrick Duke Peter Duke Harold Duke Douglas Earl Henry Earl Carl Earl Arthur Earl Ryan Earl Roger Earl Joe Earl Juan Earl Jack Earl Albert Earl Jonathan Earl Justin Earl Terry Earl Gerald Earl Keith Earl Samuel Earl Willie Earl Ralph Earl Lawrence Earl Nicholas Earl Roy Count Benjamin Count Bruce Count Brandon Count Adam Count Harry Count Fred Count Wayne Count Billy Count Steve Count Louis Count Jeremy Count Aaron Count Randy Count Howard Count Eugene Count Carlos Count Russell Count Bobby Count Victor Count Clearly the Barons are in rows 4 thru 24. The Dukes are in rows 25 thru 44. The Earls are in rows 45 thru 64. The Counts are in rows 65 thru 84. To pick a Baron,Duke, Earl, and Count at random, use these formulae: =OFFSET(B1,RANDBETWEEN(4,24)-1,0) =OFFSET(B1,RANDBETWEEN(25,44)-1,0) =OFFSET(B1,RANDBETWEEN(45,64)-1,0) =OFFSET(B1,RANDBETWEEN(65,84)-1,0) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
random draw from list of names | Excel Worksheet Functions | |||
Selecting random names from lists | Excel Worksheet Functions | |||
create a random list of names from a list of names in EXCEL | Excel Worksheet Functions | |||
Random Names | Excel Discussion (Misc queries) | |||
random non-repeating names | Excel Programming |