randomise list without repeats

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
 
A

Anders S

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
 
Top