Loss1003
08-29-2016, 07:58 AM
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
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