Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Im using the following to produce a random picking of names in the B column.
=INDEX($B$1:$B$100,RAND()*100+1) Each name is entered a different number of times in the B column, so that the names entered the most have a higher probability if hitting. What Id like to have is another cells/columns that will auto-enter the names in the B column the proper # of times. E.g. If I have the following: R S 1 Steve 4 2 Tom 7 3 Don 9 So that Steve is entered in the B column 4 times, Tom 7 times, Don 9 times, etc. Is this possible ? Thanks, Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I enter a Formula for entire column? | Excel Worksheet Functions | |||
enter formula once for entire column | Excel Worksheet Functions | |||
i don't want to enter dublicate data in a specific column | Excel Discussion (Misc queries) | |||
count the number of times a specific word appears in a column | Excel Worksheet Functions | |||
how to enter a formula using column() function for a range | Excel Worksheet Functions |