Item costs - where the interface and invoice numbers are the same and amount different

[learningexcel]

Hi
Can a macro help me.
If would like to show that our system can allow payments more than one.
See attached file to make the point

Can a macro show where we have duplicates for
same item number
same cost
different invoice number and different interface date.
I will add those four column in a file to help.

This look complicated to me - but lets see.



Cheers

 

[Chihiro]

Why VBA? Formula should be able to do this without issue.

Something like...
=IF(COUNTIFS($A:$A,A2,$B:$B,"<>"&B2,$C:$C,"<>"&C2,$D:$D,D2)>=1,"Possible Duplicate","No")