Forum Discussion
Formula to extract results with criterial
choongko Sorry, you have lost me. Perhaps we are not looking at the same data. Task 1101 has 8 sub-tasks (1 mandatory, 7 performance). Why not fill in your schedule with manually calculated values, explaining the logic for whatever calculation you need?
Thanks for being patient. I have done up entire process (5 steps/tables) of this calculation for better understanding. Pse refer to the worksheet 'checklist dashboard excel 2016'. Because the process is a bit complicated, I chose not to use pivot table. Appreciate your advice.
choongko Thanks for explaining. Still don't really follow all the steps and the logic, but that may be my lack of imagination. One thing I can resolve for you, though, is the question of why some of the formulae return #N/A. That's because the underlying cell (K12) contains 2.85. This value does not exist in the "MPCS score" column where all scores are numbers with only 1 decimal. You need to round K12 to 2.8 or 2.9, whatever the logic is that you applied to determine the "Percent X" column in the first place.
- Thanks.