worker performance analyze

Hi,

I want to analyze the performance of the workers,
criteria is the quantity and time of production
please check attached excel .
production performance.xls
I need to display as follows,
for example when I choose product nr 1. (I want to do this for each product separately, I have 6 products)

product nr:1
total quantity:172.984 pcs
total time: 309 hours

worker nr :25
quantity:25.621 pcs
time: 47 hours

worker nr :32
quantity:1.932 pcs
time: 2 hours

worker nr :65
quantity:63.155 pcs
time: 117 hours

worker nr :73
quantity:9.816 pcs
time: 20 hours

worker nr :80
quantity:10.893 pcs
time: 14 hours

worker nr :80
quantity:61.5962 pcs
time: 109 hours

many thanks in advance
Kaan

Hi,

A pivot table might do the trick. Hope this works for you.

/Masun

Hi,

Look at Sheet2.

I hope this helps

I THANK YOU ALL. BOTH HAVE ADVANTAGES. I WOULD BE HAPPY TO UNDERSTAND HOW YOU MAKE THEM. COULD YOU EXPLAIN ME? I AMBIGINNER