A bit more difficult but try this

Next to your list of numbers type RAND() and drag down. Sort the selection
by the list of random numbers generated. The numbers 1 to 8 will also sort
with no repeats. Copy this sorted selection to where you want it to be.

"Bhupinder Rayat" wrote:

Thanks Mike,

I filled down, what about if i want each number to appear once only in my
new list, as described below?

Cheers.

"Mike" wrote:

Assuming your numbers are in D1 - D8. Adjust as necessary

=INDEX(D1:D8,RANDBETWEEN(1,COUNTA(D1:D8)),1)

"Bhupinder Rayat" wrote:

Hi,

if i have the following list on sheet1
1
2
3
4
5
6
7
8

i want to know how to return any random number from that list on another
sheet.

e.g. sheet2

2
4
5
1
3
6
8
7

and i want to the array to return them in a different order everytime the
code is executed.

can anyone help please?

Many thanks,

Bhupinder.