Lottery Number Picker

  • Thread starter Thread starter scottymelloty
  • Start date Start date
S

scottymelloty

I have the numbers from 1-49 in column A1 downwards, in column B1
downwards i would like to have the numbers displayed from A1 in a
random order

Any Ideas, Thanks
 
scotty

You could put RAND() in B1 and fill down. Then you can sort on column B to
randomize column A. Each time you sort you'll get a different random result.

Andy.
 
I'd put =rand() in b1:b49 and then this in c1:c49,

=INDEX($A$1:$A$49,MATCH(LARGE($B$1:$B$49,ROW()),$B$1:$B$49,0))

But you don't actually need the column A in this situation:
Put this in column D and you'll see:

=MATCH(LARGE($B$1:$B$49,ROW()),$B$1:$B$49,0)

the =match() function returns the row of the match. And since you're using
1:49, you don't need those numbers.

(and copy down the formulas through row 49)
 
Thanks for the Help, Oneproblem i have with your answer dave is when
have copy and pasted the index line into c column it's coming up #NAME
, what am i doing wrong ??
 
I just tried it again and it worked ok for me.

did you copy and paste from the post or retype by hand?

(If it fails again, post the formula you're using in column C.)
 
Back
Top