Recent content by aparvez007

Thanks dear working fine

Hi, Need help to to get the formula for my alphabet code to number as per below example. A to J represent the number if I type the code JFGAA I need 15400 as output A 0 JFGAA 15400 B 9 JIAA 1200...

Is this what you want?

Hi Pascal, Not a summary actually, I just want to remove matching debit credit in each item number, Mr. Bosco's solution is working if there is no item number but If item number 166510152 has debit 500 and 166510153 has 500 credit it should not eliminate the formula should check matching debit...

Hi, Help to modify the formula Based on the Item number need to find matching debit credit one on one value. The formula solution provided by Mr. Bosco is attached. Regards, PaVi

Thanks

Ok Thanks

Thanks, Bosco it's working fine, but my question is if the same amount is there in a different item then it will not give the correct output. Can we match the item number also in the formula?

Hi All, Need the formula to find the matching amount in debit credit or netting based on Item Number. Thanks in advance for your support and help. Regards, PaVi

Thank you p45cal, work perfectly, I will learn this formula

Hi, Need the formula to distribute backlog value year-wise as per the end date. I really appreciate any help you can provide. Sample file attached. Regards, PaVi

Thanks vletm... work fine and sorry for title next time I will use better title. Thanks

Hi, I have two sheet in one sheet I have Total CTC for each employe in other sheet Jobwise number of hour each employee work in particular job, So I want to distribute the total CTC amount to each job. Sample fine attached with required output. Thanks in advance. Regards, Pavi

Thanks for your effort sir I am copy paste on same pivot that's why it's not working. In earlier version pivot not loosing Auto formatting when I am copy paste value.

Yes original copy have format but after copy paste special value pivot lose the format and paste special format is not working.