Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
this can be done with the countif function.
In Cell C25 =COUNTIF(A$25:A$37,A25) A25 to A37 is the names "JB" wrote: This is a scheduling routine. I have a list of names in one column to which I assign a random number, in an adjacent column. Once the random numbers are assigned, I sort the two columns together, by the random numbers, to randomize the list of names. The refinement: Each name in the list will ultimately be repeated anywhere from 0 to 3 times. I would like to assign each name a frequency value, and then automatically generate a list with the names repeating in accordance with the frequency number. This can be done manually, but it would be more elegant if I could add a name and a frequency and let Excel generate the list accordingly. Is this doable? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Repeat text a number define of times | Excel Worksheet Functions | |||
How can I count how many times different texts repeat in a column? | New Users to Excel | |||
how do I count the number of times text in column A matches text i | Excel Worksheet Functions | |||
How I can print full text bigger than column, in repeat column | Excel Discussion (Misc queries) | |||
in excel can one repeat the text from a the last used column cell. | Excel Discussion (Misc queries) |