G
ghobbit
Hi
I'm a bit of a newbie to excel and am having a problem with generatin
a random alpha-numeric figure.
I need to generate 30 random figures from a list between aa0000 an
aa1000. I know I could just use the numbers (0000,1000) in the ran
function but without going into details I cant do that.
I have looked at the =randbetween(x,y) function and entered
=randbetween(aa0000,aa1000) but without success - all I got was #NAME.
Is there some other way that I could this perhaps a combination o
functions preferably not going into VBA as I'm not a programmer an
wouldnt have a clue.
any advice would be most appreciated.
many thanks
stev
I'm a bit of a newbie to excel and am having a problem with generatin
a random alpha-numeric figure.
I need to generate 30 random figures from a list between aa0000 an
aa1000. I know I could just use the numbers (0000,1000) in the ran
function but without going into details I cant do that.
I have looked at the =randbetween(x,y) function and entered
=randbetween(aa0000,aa1000) but without success - all I got was #NAME.
Is there some other way that I could this perhaps a combination o
functions preferably not going into VBA as I'm not a programmer an
wouldnt have a clue.
any advice would be most appreciated.
many thanks
stev