Hi,
I have thousands of invoices and some of the invoices are offsetting invoices equaling to 0. Is there is a VBA code or any other way we can determine or highlight all invoices with the same Booking ID equaling to 0?
Attached are some example of invoices I have.
I used =If(A2=A1,"",sumif(A:A,A2,C:C)) but this only works if all invoices within the booking equal to 0.
In the attached example: The formula worked on the below example because the total of all invoices is 0.
However, it didn't work on the others like the examples below because Not all invoices are equal to 0:
I tried the solver but it doesn't seem to work on my end. I am not very good at coding and stuff and I would appreciate any help.
Thank you in advance.