Excel random function
up vote
-1
down vote
favorite
I have a Excel problem: I have 9 different numbers or letters (from 1 to 9 or a to i). For each number I need to assign 1 number from remaining numbers (same number can not be assigned to itself for example 1 can not be assigned to 1). Second requirement is that each number has to be used only 1 time. I already tried 1 example from here with modification: =IF(A1=A1, RANDBETWEEN(2, 9), RANDBETWEEN(2, 9)) Unfortunately this does not work for me and I suppose 1 more IF needs to be used. Can anyone help me with Excel code?
microsoft-excel
share | improve this question
edited Nov 21 at 10:28
Al