randomise numbers in cells

hi..i wanna make a very simple task in an excel spreadsheet

i wanna have three cells in a row...then each can show 1 or 2 or 3 in a random order. it means once i refresh and all three cells can have a new arragemnet of 1 and 2 and 3. anybody can help?


thanks

mike

Mike:

In cell A1 enter the =RAND() function and copy down to row 3, in cells B1 through B3 enter the numbers 1, 2 and 3 respectfully. Paste the formula in cell D1 and copy down to row 3. This will produce the three numbers in random order without duplicates.

Please Login or Register  to view this content.

Matt