anish.ms
01-01-2021, 05:15 AM
Dear All,
Happy New Year to Everyone!
Request help in attached file where I need to replace the dynamic array formulas in "Dashboard 1" with VBA codes.
#
Function
# Sub Process
Likelihood Score
Impact Score
Risk Rating
Numbering
Unique values from Table PQ_Append[Function].
To be sorted in descending order based on the multiplied value of likelihood score and impact score. So that the order will be High to Low
Number of sub process in the function from Table PQ_Append[Sub Process]
Average of Likelihood Score from all the sub process in the function.
Table PQ_Append[Likelihood Score]
Average of Impact Score Score from all the sub process in the function. Table PQ_Append[Impact Score]
VBA code already there in the sheet for risk rating [Could you please check and suggest is it fine have have so many If statements]
I have the same file attached in https://chandoo.org/forum but that is for the help in positioning of data labels in the scatter chart
Happy New Year to Everyone!
Request help in attached file where I need to replace the dynamic array formulas in "Dashboard 1" with VBA codes.
#
Function
# Sub Process
Likelihood Score
Impact Score
Risk Rating
Numbering
Unique values from Table PQ_Append[Function].
To be sorted in descending order based on the multiplied value of likelihood score and impact score. So that the order will be High to Low
Number of sub process in the function from Table PQ_Append[Sub Process]
Average of Likelihood Score from all the sub process in the function.
Table PQ_Append[Likelihood Score]
Average of Impact Score Score from all the sub process in the function. Table PQ_Append[Impact Score]
VBA code already there in the sheet for risk rating [Could you please check and suggest is it fine have have so many If statements]
I have the same file attached in https://chandoo.org/forum but that is for the help in positioning of data labels in the scatter chart