randomize a list without reinsertion

[lemontruck]

I am trying to generate a recurring randomized list of ten items in Excel. I can do the randomization but the list reuses items on the list. I have not been able to change the formula so that only one item gets used each time I randomize. I will take any suggestions.

 

[c_m]

lemontruck,
Welcome to the Board.

See:
http://www.tushar-mehta.com/excel/newsgroups/rand_selection/