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
and the fact the there are duplicate invoice numbers maybe an issue too
There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.
A good sample workbook has just 10-20 rows of representative data that has been desensitised. The sample layout accurately matches that of your real data. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
ok ill attach a file but its just got one column with invoice numbers and one with the amounts
column A has all the invoice numbers it has duplciate invoice numbers too
column b has the debits and credits
I would rather see a sample of your data before helping.
ok but i have client data on it so i need to change it abit before i can send
OK. In the meantime ...
Administrative Note:
We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so. Cross-posts are allowed but you must provide a link to your posts on other sites.
Please see Forum Rule #7 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/
(Note: this requirement is not optional. No help to be offered until you provide a link or, for members with fewer than 10 posts, a comment telling us where else you have posted this query.)
o i ahve attacehd the file
i had to take client names out
if you filter on sum 995
you will see a load of 995 and some -995
my question is if its bases the formula on numbers only it will look at the numbers but i have different clients
so i ideally want to see the formula maybe say like true of false
e.g. gabby may have 995 and a -995
lets say aj has -995
what if gabbsy positive 995 contras aj's -995
because alot of the formulas just look at the numbers so they will contra any number that matches
Thank you. Please read post #3 again, in particular:
A good sample workbook has just 10-20 rows of representative data that has been desensitised. The sample layout accurately matches that of your real data. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.
Is this the same question?
https://www.excelforum.com/excel-gen...ght-thing.html
Administrative Note:
Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.
Please see Forum Rule #2 about thread duplication.
I am closing this thread, but you may continue here in the original thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks