dunno if i give this the right title.
What I am after is this :
I have a list of numbers ( 1-100 ), in column A.
I want to choose a random number from that list ( eg 59 ).
I then want to be able to show in an another column, numbers 1 to 100, but not showing number 59.
I want to repeat this 10 times, so each time, choosing a random number, then producing a list, but not showing the number previously selected.
Ive tried for days, but now i am totally beaten.
Many Thanks,
What I am after is this :
I have a list of numbers ( 1-100 ), in column A.
I want to choose a random number from that list ( eg 59 ).
I then want to be able to show in an another column, numbers 1 to 100, but not showing number 59.
I want to repeat this 10 times, so each time, choosing a random number, then producing a list, but not showing the number previously selected.
Ive tried for days, but now i am totally beaten.
Many Thanks,