Hi Excel Champs,
Please help me getting this calculated
I have data like this
<tbody>
</tbody>
And data goes on for upcoming dates in next Rows.
Where i need to make a productivity report out of above data like this
<tbody>
</tbody>
Right now i am using SUMIFS but my data expands upto 50000 Rows and SUMIFS is very slow. Can you please help me with a VBA code which calculates this for above table.
Please help me getting this calculated
I have data like this
Date | Emp Code | Emp Name | Productivity | AHT |
15-02-2018 | 726462 | ABC | 254 | 10 Min |
15-02-2018 | 734840 | DEF | 123 | 12 Min |
15-02-2018 | 746569 | GHI | 656 | 3 Min |
15-02-2018 | 726462 | ABC | 153 | 20 Min |
15-02-2018 | 734840 | DEF | 345 | 6 Min |
15-02-2018 | 746569 | GHI | 234 | 10 Min |
15-02-2018 | 726462 | ABC | 484 | 5 Min |
15-02-2018 | 734840 | DEF | 556 | 2 Min |
16-02-2018 | 726462 | ABC | 645 | 12 Min |
16-02-2018 | 746569 | GHI | 937 | 2 Min |
16-02-2018 | 734840 | DEF | 294 | 10 Min |
16-02-2018 | 734840 | DEF | 475 | 5 Min |
16-02-2018 | 746569 | GHI | 284 | 10 Min |
<tbody>
</tbody>
And data goes on for upcoming dates in next Rows.
Where i need to make a productivity report out of above data like this
Emp Code | Emp Name | 15-02-2018 | 16-02-2018 | 17-02-2018 | 18-02-2018 |
726462 | ABC | =SUMIFS() | =SUMIFS() | ||
734840 | DEF |
<tbody>
</tbody>
Right now i am using SUMIFS but my data expands upto 50000 Rows and SUMIFS is very slow. Can you please help me with a VBA code which calculates this for above table.