Hi,
This is my first post so I am not sure how this works but I am posting this anyways.
I have a huge file approx. 50K rows and 14 columns. File basically contains data of employees which are approx. 2,500. In every month deductions are made from employees salary. I want to SUM all the deductions made by employees. Every employee has a unique Employee Code e.g. 5132, but the problem is that the deductions are monthly e.g. Jan, Feb, March so I can't use VLOOKUP function as it only selects 1st value.
Please find below a rough idea that how the data is
Date Employee Code Deductions
31-March 5132 500
31-March 5133 480
30-April 5132 510
30-April 5133 500
I have tried my best to explain the problem but if further clarification I can attach the excel file.
Can some one help me on this.
Thanks
Bookmarks