+ Reply to Thread
Results 1 to 9 of 9

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

  1. #1
    Registered User
    Join Date
    07-13-2012
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    4

    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. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

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

    Can you show example of expected results in column C?
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Registered User
    Join Date
    07-13-2012
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    4

    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. #4
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    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. #5
    Registered User
    Join Date
    07-13-2012
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    4

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

    Sorry for the confusion...

    Here is the file.

    Thanks.
    Attached Files Attached Files

  6. #6
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

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

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

  7. #7
    Registered User
    Join Date
    07-13-2012
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    4

    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. #8
    Registered User
    Join Date
    03-03-2012
    Location
    chennai
    MS-Off Ver
    Excel 2007
    Posts
    5

    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. #9
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,572

    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.
    Last edited by protonLeah; 07-28-2012 at 03:25 PM.
    Ben Van Johnson

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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