Generating random outcomes based on probability

[Loss1003]

What is the best method or formula to get results based on assigned probability (%) in each row?

Result can only be A , B, C, D, or E. Additionally, If the cell = 0.00% it should not be factored into the result

A	B	C	D	E	Desired Result
0.00%	0.00%	29.41%	58.82%	11.76%	C, or D, or E
0.00%	0.00%	5.88%	47.06%	47.06%	C, or D, or E
0.00%	0.00%	11.76%	41.18%	47.06%	C, or D, or E
5.88%	0.00%	5.88%	17.65%	70.59%	A, or C, or D, or E
11.76%	0.00%	11.76%	11.76%	64.71%	A, or C, or D, or E
5.88%	17.65%	11.76%	35.29%	29.41%	A, B, C, D, or E
25.00%	12.50%	6.25%	31.25%	25.00%	A, B, C, D, or E
17.65%	5.88%	0.00%	11.76%	52.94%	A, or B, or D, or E
11.76%	29.41%	0.00%	29.41%	29.41%	A, or B, or D, or E
35.29%	29.41%	0.00%	11.76%	0.00%	A, or B, or D

[p45cal]

You've already had the answer to this here http://www.vbaexpress.com/forum/show...ula&highlight= but you acknowledged nothing.

[Loss1003]

Sorry brain freeze forgot I posted that or didn’t see the responses. Tried both suggestions and both work perfectly. Please close this post out and much appreciated all the help J