Home |
Search |
Today's Posts |
#5
![]() |
|||
|
|||
![]()
Hello,
I suggest to take my UDF UniqRandInt() from www.sulprobil.com. If your names are listed in A1:A16, for example, then select cells B1:B25 and enter =INDEX(A1:A16,UniqRandInt(16,2)) as array-formula (with CTRL+SHIFT+ENTER). Please keep in mind that my function returns an error value if the length of your list is less than 16 * 2 as B. R. Ramachandran already pointed out. HTH, Bernd |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Auto populate fields | Excel Discussion (Misc queries) | |||
Function for Auto Populate | Excel Worksheet Functions | |||
Auto populate cells based on 2 cells division. | Excel Discussion (Misc queries) | |||
Auto Populate a cell | Excel Discussion (Misc queries) | |||
excel links update not working in auto, calculations in auto | Excel Worksheet Functions |