Ok, I see how that works.

What I am using is =INDEX($A$1:$M$1,RAND()*COUNTA($A$1:$M$1)), but I still end up with #value (###) error in some of 5 cells that I input this formula? Sorry, I didn't realize it was a #value error until I made the column width larger. If I hit F9 a couple times, I will get 5 numbers, some of them are duplicates, but I'm wondering why I end up with this #value error?? Would removing duplicate's solve this? How would I write it? Thanks again