Hi could you please look at my excel document. I am trying to generate a 4 digit number with no repeats. The first digit also cant be 0. I've wrote a formula for the first 3 digits but I don't know how to do the last digit. Could you please help. I tried putting another IF statement but it comes up with "too many arguements". The formula I tried was =SMALL(IF(A2={0;1;2;3;4;5;6;7;8;9},"",IF(B2={0;1;2;3;4;5;6;7;8;9},"",IF({0;1;2;3;4;5;6;7;8;9},"",{0;1;2;3;4;5;6;7;8;9}))),RANDBETWEEN(1,7))
Bookmarks