Hi,

I would like to generate a column of data based on the following probability distribution:

80 percent of cells = 1A
10 percent of cells = 2B
5 percent of cells = 3C
3.5 percent of cells = 4D
1.5 percent of cells = 5E

I suspect a formula can generate this distribution of numbers but am not sure


I have Excel 2010. Thanks for any help