Friends,
I have a workbook with around 200 items, indexed from 1 to 200.
I need excel to generate several random numbers from this list...
BUT...
Certain items in the list need to be more likely to be generated. I was thinking of a assigning an "Importance Factor" of sorts to certain items in the list which would alter the likelyhood of that item's index number being selected.
Does anyone have any ideas?
Bookmarks