Hi Experts,

can someone please help with output I am looking for in the sense of productivity at Quartile 2 and Quartile 3. I have tried with formula to get Productivity at Quartile 2 and 3 and same with Workout at Quartile 2 and 3. I want to create a sample which shows variance on productivity and workout. I have mentioned Productivity Baseline.

Attached Files

Ops Data.xlsx (12.9 KB, 15 views)

can someone pls atleast reply if my req is understable or have i missed something while explaining.

I'm guessing you're right, your requirement is probably not understandable.
A lack of response at Productivity Variance would support this, as well as neither me nor Peter Bartholomew being able to understand your similar (or same) requirement at I want to Analyze Productivity data for last 6 month | Chandoo.org Excel Forums - Become Awesome in Excel