+ Reply to Thread
Results 1 to 7 of 7

Formula to knock off positive and negative values from the same table

  1. #1
    Registered User
    Join Date
    04-26-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    21

    Post Formula to knock off positive and negative values from the same table

    Hiii...I need a Formula to knock off positive and negative values from the same table by a given criteria,
    I am attaching working sheet for the same.knock off positive and negative values.xlsx

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Formula to knock off positive and negative values from the same table

    =if(vlookup(c2,$a$2:$b$9,2,0)=(0-b2),"y","n")

  3. #3
    Registered User
    Join Date
    04-26-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    21

    Thumbs up Re: Formula to knock off positive and negative values from the same table

    Hii..

    I think its working...

    Thank you very much for your help...

  4. #4
    Registered User
    Join Date
    10-12-2016
    Location
    Lagos
    MS-Off Ver
    2013
    Posts
    1

    Re: Formula to knock off positive and negative values from the same table

    Please I need to know how to knock off items of same value from a debit and credit side .

  5. #5
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,598

    Re: Formula to knock off positive and negative values from the same table

    You will see in the Forum Rules (at the top of this page) that you should not hijack someone else's thread (Rule 02). Rather, you should start a new thread of your own, with a link back to this one if you think it is relevant.

    This particular thread is over three years old, and it is unlikely to be monitored by the posters who contributed to it originally.

    Pete

  6. #6
    Registered User
    Join Date
    10-17-2016
    Location
    Haryana
    MS-Off Ver
    Excel 2013
    Posts
    1

    Re: Formula to knock off positive and negative values from the same table

    How to knock off various positive and negative values in a set of huge data, where values are repeating. Say for example 25 is appearing 6 times and -25 is 4 times. Is there a formula to knock that off those 4 values and leave 2.

  7. #7
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Formula to knock off positive and negative values from the same table

    Did you read the post immediately above yours?
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ 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