+ Reply to Thread
Results 1 to 6 of 6

Matching the positive cells with the Negative Cells values

  1. #1
    Registered User
    Join Date
    03-03-2012
    Location
    colombo
    MS-Off Ver
    Excel 2003
    Posts
    31

    Matching the positive cells with the Negative Cells values

    Hi

    I have been trying to check in many excel sheets that the positive and negative values which need to finally zero at the every month.
    let say if there is one value has (477077.38) and the corresponding value has 477077.38 in same sheet. i need to filter those positive balalnces and the negative balances in a order.

    please help me to get solve this
    Attached Files Attached Files

  2. #2
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,444

    Re: Matching the positive cells with the Negative Cells values

    Hi,

    In L2 add the formula =ABS(G2)

    Copy the contents of L2 down the length of your data

    Sort by Column L
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

  3. #3
    Registered User
    Join Date
    03-03-2012
    Location
    colombo
    MS-Off Ver
    Excel 2003
    Posts
    31

    Re: Matching the positive cells with the Negative Cells values

    Hi Sweep

    Thank you Very much it's works for me.

    regards,
    Dan789

  4. #4
    Registered User
    Join Date
    03-03-2012
    Location
    colombo
    MS-Off Ver
    Excel 2003
    Posts
    31

    Re: Matching the positive cells with the Negative Cells values

    Dear Sweep,

    Is there have any possibility to get the unmatched amounts seperately in another cloumn or highlight those values.

    Thank you
    Dan789

  5. #5
    Registered User
    Join Date
    03-03-2012
    Location
    colombo
    MS-Off Ver
    Excel 2003
    Posts
    31

    Re: Matching the positive cells with the Negative Cells values

    Dear Sweep,

    Is there have any possibility to get the unmatched amounts separately in another column or highlight those values.

    Thank you
    Dan789

  6. #6
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,444

    Re: Matching the positive cells with the Negative Cells values

    In M2 enter this:

    =OR(L2=L1,L2=L3)

    Which should return TRUE when the value in L is matched and FALSE when it isn't. Note that this could fail where there is a pair of values that are matched (eg £200 and -£200) and a subsequent unmatched £200 or -£200 in the next row.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. sumproduct of positive or negative cells only
    By vickyho1008 in forum Excel General
    Replies: 6
    Last Post: 03-30-2024, 05:17 PM
  2. Matching positive to negative values
    By harrison298 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-08-2017, 11:52 PM
  3. Replies: 2
    Last Post: 09-10-2014, 08:56 AM
  4. Replies: 8
    Last Post: 07-28-2012, 03:22 PM
  5. Adding cells that are positive and not negative
    By HHR in forum Excel General
    Replies: 2
    Last Post: 06-13-2011, 11:37 AM
  6. Replies: 4
    Last Post: 09-26-2005, 06:05 PM
  7. Replies: 4
    Last Post: 06-24-2005, 05:05 PM

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