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