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 it

5