[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 115
  • Last Modified:

Comparison between 2 columns

Here's attached an excel sheet of 2 columns copied from two different sheets to compare them and then come up with the Delta, can anyone help?
0
Naser Gabaj
Asked:
Naser Gabaj
  • 3
  • 3
1 Solution
 
NBVCCommented:
Try attaching file again please.
0
 
Naser GabajAuthor Commented:
0
 
NBVCCommented:
Can you give an example of what you are looking for?  Ie.  what is the result you expect in E3 and why?
0
NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

 
Naser GabajAuthor Commented:
I'm looking for whatever of combination of Column A and B exist and not exist in Column C and D.... is that make sense?
0
 
NBVCCommented:
Try:

=IF(ISNUMBER(MATCH(1,INDEX(($C$3:$C$595=A3)*($D$3:$D$595=B3+0),0),0)),"Match","No Match")

copied down length of column A range.  Match means combo in A/B found in C/D
0
 
Naser GabajAuthor Commented:
I figure it out my self but I decided to reward you the points as an instant answer... Thanks.
0

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now