confused about contra entries formula

[kingjet]

column A: has invoice numbers but they have duplicates too so invoice numbers 12345, 12345, 123455 etc

then they have debit credit figures etc

what formula can i use to see which invoice number has the contra

i want to put this in column b

so client A invoice number is 12345 100

but another client 13456 -100

if i do a basic formula it will tell me that the 100 matches with -100 but they are two different clients i want it to based on the invoice number as opposed to only numbers

there are duplicate invoice numbers so theres an issue there too

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: what is the best formula for this contra entries? abit confused
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[kingjet]

please delete this thread

 

[Fluff]

No need to delete the thread.

 

[kingjet]

no it is a different query same file different queryt can you reopen my othe rthread please

 

[kingjet]

Hello

i think i had a good contra formula based on my columns I to L

they basically look at the value and then tell me if there is a same value elsewhere

so if you look at column L all the 2's mean there is a contra entry, which seems fine but it isnt

because if you look at row 2 and row 9

they are two different customers John and Gabby

1. can someone maybe tell me a better contra entry formula?
2. maybe i can add an IF statement somewhere to let me know if its the same customer?

i only want to see a 2 if the customer is the same otherwise it is not a contra