Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Misc
Segregating Duplicate Transactions
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="Jacob Skaria, post: 3287721"] In cell D2 apply the below formula and copy down as required =IF(OR(SUMPRODUCT(($A$2:$A3=A2)*($B$2:$B3=B2)* ($C$2:$C3=C2))>1,SUMPRODUCT(($A$2:$A$1000=A2)* ($B$2:$B$1000=B2)*($C$2:$C$1000=-C2))=0),"Bill","Cancelled") [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Misc
Segregating Duplicate Transactions
Top
