Dear All,
I am attaching one excel in which i have 3 TABS. (1.Master Capability, 2. Analytical, 3. Turbo ).
Now the process is:
1. In Analytical Tab i have score in Column F against Capability and Maturity selected from Drop down menu
2. In Turbo Tab i have score in Column F against Capability and Maturity selected from Drop down menu
In Anlytical Tab, if we calculate "Aero-Thermo / Mechanical Design" capability has avg score of 2.66 & "Optimization / Test Validation" has avg score 2.5 and so on.
Same is the case with Turbo Tab.
Now i have listed all the capabilities against each value stream in "Master Capability" TAB.
OUTPUT REQUIRED
I want to display avg score calculated for each capability as above in Column F "Proficiency Score" of Master Capability TAB.
Note: Capabilities are not unique so to get the average score for each capability against particular value stream validation is required.
Like, After filling the score, the formula matches the capability and value stream and then display the average score.
I have manually entered the output for reference.
Please help
Regards
Mohammad
Bookmarks