• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Based on Item number need to find matching debit credit one on one value

aparvez007

Member
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
 

Attachments

  • COUNTIF+IF.xlsx
    26 KB · Views: 3
Is this what you're after?:

View attachment 83426
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 credit in each item number. Hope I explain my query.

Regards,
PaVi
 
Back
Top