B Biyani Sep 13, 2009 #1 I have numbers from 0 to 9 and I want to generate 3 digits from them, please let me know how?
J JoeU2004 Sep 13, 2009 #3 Biyani said: I have numbers from 0 to 9 and I want to generate 3 digits from them, please let me know how? Click to expand... Does the following meet your needs? =RANDBETWEEN(0,999) formatted with the custom format 000.
Biyani said: I have numbers from 0 to 9 and I want to generate 3 digits from them, please let me know how? Click to expand... Does the following meet your needs? =RANDBETWEEN(0,999) formatted with the custom format 000.
G Gary''s Student Sep 13, 2009 #4 If you do not want any repeated digits, then in A1 thru A10 enter: =RAND() and use: =(MATCH(LARGE(A1:A10,1),A1:A10,0)-1)&(MATCH(LARGE(A1:A10,2),A1:A10,0)-1)&(MATCH(LARGE(A1:A10,3),A1:A10,0)-1)
If you do not want any repeated digits, then in A1 thru A10 enter: =RAND() and use: =(MATCH(LARGE(A1:A10,1),A1:A10,0)-1)&(MATCH(LARGE(A1:A10,2),A1:A10,0)-1)&(MATCH(LARGE(A1:A10,3),A1:A10,0)-1)
