• 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.

Need to eliminate matching amount either in debit credit or in netting

aparvez007

Member
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
 

Attachments

  • Sample.xlsx
    22 KB · Views: 7
Try, with helper column formula solution.

In E3, formula copied down:

=IF((COUNTIF(H:H,G3)>0)*(C3=""),(COUNTIF(G$2:G3,G3)>COUNTIF(H:H,G3))*B3-C3,0)+IF(COUNTIF(G:G,H3)*COUNTIF(H:H,G3),0,B3-C3)

83421
 

Attachments

  • COUNTIF+IF.xlsx
    26 KB · Views: 8
Try, with helper column formula solution.

In E3, formula copied down:

=IF((COUNTIF(H:H,G3)>0)*(C3=""),(COUNTIF(G$2:G3,G3)>COUNTIF(H:H,G3))*B3-C3,0)+IF(COUNTIF(G:G,H3)*COUNTIF(H:H,G3),0,B3-C3)

View attachment 83421
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?
 
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?
Please open a new post for your new question

Regards
 
Back
Top