Need Advice on duplication records autosum

[frody]

Dear All,

I have a excel pay sheet with data on around 550 rows & 16 columns (attached herewith).


where i have a duplication check on Employee ID that is Column B. if you can please help me with getting automated sum on number of days and net payable amount in a new row for every single employee and the duplicate entries should automatically be deleted for e.g.

EmpID Name No of days NetPay
1624086 XYZ 7 1000
1624086 XYZ 3 350
1624086 XYZ 10 1500
New Row:
1624086 XYZ 20 2850

Same for other entries.

Regards,

[e4excel]

Hey Frody,

I will be more than Happy to help you but I am afraid that I have not understood the exact requirement but if you just want to get the Series then,

Cell Q2

Please Login or Register  to view this content.

This would give you a Series WITH bLANK spACES and if you want to just give a Unique No then you can use one more column..
Cell R2

Please Login or Register  to view this content.

tHIS WOULD GIVE YOU A Unique repeatitive serial no which you can use to get a summation for the same Employee, I would appreciate if you can add more expected results..

Warm Regards
e4excel

[arlu1201]

frody, will have something ready for you shortly.

[arlu1201]

Try this code - put in a blank module of your file -

Please Login or Register  to view this content.