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
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
=if(vlookup(c2,$a$2:$b$9,2,0)=(0-b2),"y","n")
Hii..
I think its working...
Thank you very much for your help...
Please I need to know how to knock off items of same value from a debit and credit side .
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
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.
Did you read the post immediately above yours?
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks