# Excel 2007 : Matching negative values with a corresponding positive values within multiple CATEGORIES

1. ## Matching negative values with a corresponding positive values within multiple CATEGORIES

I have a spreadsheet hundreds of rows where I need to match multiple negative values with a corresponding positive values but within multiple CATEGORIES. For example: headers in row 1, values in column B starting in row 2, and category in column A starting in row 2.....

Invoice Amount
19221 -110
19221 -100
19221 +110
19211 -210
19222 -300
19211 -210
19222 -300
19222 +300

So I need a formula to put in column C that somehow match corresponding negative and positive values within Invoice 19221 and Invoice 19222. Hope this makes sense and someone can help. Thanks.

2. ## Re: Matching negative values with a corresponding positive values within multiple CATEGORI

Can you show example of expected results in column C?

3. ## Re: Matching negative values with a corresponding positive values within multiple CATEGORI

No specific results is needed. Ill take anything at this point. I just need something.....a highlited tab, yes or no, etc., I just need to seperate them from the others. I later want to filter the spreadsheet to just show those corresponding values that match to review them for another project. I hope I make sense.

4. ## Re: Matching negative values with a corresponding positive values within multiple CATEGORI

It's not making sense. Just post a sample workbook showing what you have and want. I don't understand your request at all.

5. ## Re: Matching negative values with a corresponding positive values within multiple CATEGORI

Sorry for the confusion...

Here is the file.

Thanks.

6. ## Re: Matching negative values with a corresponding positive values within multiple CATEGORI

I still don't know what I am doing with it

7. ## Re: Matching negative values with a corresponding positive values within multiple CATEGORI

From the workbook, one invoice number can have multiple values (referred to BALANCES on my workbook). Within those values, I need to match up corresponding positive and negative values.
For Example:
At the top of my workbook, it lists invoice number 50001 with 11 seperate values (balances). 10 of those values match due to thier corresponding positive and negatice values. What formula can I put in column C and run it down to the end that will list Yes or No, if it has a corresponding value in column B within a invoice number in column A. (*Keep in mind I put invoice number 50001 to the top of the workbook to show my issue but they were originally mix within other invoices as the others are too. Plus some invoices will not have corresponding positive and negative values.)

8. ## Re: Matching negative values with a corresponding positive values within multiple CATEGORI

Hi All Gurus.

I am also in need of same solution above.. Can anyone help us please???

9. ## Re: Excel 2007 : Matching negative values with a corresponding positive values within mult

@Logu, Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1