Dear All,
I am attaching one excel in which in "Analytical Tab" i have score in G Column " Score ". Now i have another tab "Master Capability" in which i have listed down many Capabilities against each Value stream.
I want output in Master Capability - Proficiency score.
Whenever i enter some score in "Analytical" tab, it should match the "Value stream- Analytical Engineering" & corresponding "capability" in "Master Capability" TAB and give the average of score for each capability.
Ex. for capability "CFD/Flow Analysis" the Proficiency score should be "2.66".
Please resolve
Regards
Mohammad
Bookmarks