randomise list without repeats

  • Thread starter Thread starter garetjax
  • Start date Start date
G

garetjax

Hi, I am trying to randomise a list of numbers 1-109(in column A) so
that no number is repeated and I have list of 109 numbers. (like
shuffling a deck of cards). Have tried rand, randbetween, match and
looked for other types of functions but cannot find one that will do
the job! Is there one? Or will I have to learn how to program in
VBasic to be able to do this? Can it be done in VBasic?

Any ideas please

Thanks

garet jax
 
One way without using VBA,

- enter 1-109 in A1:A109.
- enter =RAND() in B1:B109
- sort A1:B109 on column B
- delete column B

HTH
Anders Silvén
 
Back
Top