The random function in excel is a bit lacking if you ask me, I may only use it a little but when I do it is always frustrating that when I want to assign random numbers to a list of something Just wack this in your spreadsheet or personal macros workbook: then you are free to use more »