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

1. 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. 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. 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. 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. 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. 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. Re: Formula to knock off positive and negative values from the same table

Did you read the post immediately above yours?

Users Browsing this Thread

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