Really really need help with this: Contra entries with customer names :(

[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 aswell if it isnt it should say 1

i had to uplaod an image

but the formulas are:


i have also posted this here:

Really really need help with this: Contra entries with customer names :(

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

www.excelforum.com

 

[Fluff]

Duplicate to: confused about contra entries formula

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.