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,