I need to create 2 million random, non-dublicating aphla-numeric codes each
month. Can a function in Excel provide me with this?
--
Thanks for your suggestions.

Select columns A thru AE and run this tiny macro:

Sub MakeRandum()
i = 1
v1 = 65
v2 = 90
For Each r In Selection
r.Value = i & Chr(Int(((v2 - v1 + 1) * Rnd) + v1))
i = i + 1
Next
End Sub
--
Gary''s Student - gsnu200812


"SRK" wrote:

I need to create 2 million random, non-dublicating aphla-numeric codes each
month. Can a function in Excel provide me with this?
--
Thanks for your suggestions.

For Non MACRO usage, I've tried a formula:

req:-

create a array of alphabets "A to Z" and 10 numerals in a 6 by 6 grid (i pu
the grid from cells f7 to k12.

then i put:


=INDIRECT(CHAR(MOD(LEFT(RAND()*10,1),6)+6+64)&(MOD (LEFT(RAND()*10,1),6)+7))

to generate a single alphanumeric character.

you can concatenate the complete formula to gerate more digits.

so for 3 digit no generation, it will be

=INDIRECT(CHAR(MOD(LEFT(RAND()*10,1),6)+6+64)&(MOD (LEFT(RAND()*10,1),6)+7))
&
INDIRECT(CHAR(MOD(LEFT(RAND()*10,1),6)+6+64)&(MOD( LEFT(RAND()*10,1),6)+7))
&
INDIRECT(CHAR(MOD(LEFT(RAND()*10,1),6)+6+64)&(MOD( LEFT(RAND()*10,1),6)+7))

spaces in between are only for clarity.

--
Kind Regards,
Satti Charvak
Only an Excel Enthusiast
Noida, India


"SRK" wrote:

I need to create 2 million random, non-dublicating aphla-numeric codes each
month. Can a function in Excel provide me with this?
--
Thanks for your suggestions.