# Determine if combination of data in Excel B referencing A, is correct

1. ## Determine if combination of data in Excel B referencing A, is correct

I am trying to determine if data Excel file B is correct relative to excel file A. Both files have the same headers except for File B, there is a Unique ID & Sub ID Group attached. There can be several rows of B that corresponds to a single row of A. Meaning to say A contains unique rows and B can contain multiple entries of A with a Unique ID for each row. Is there any way to automate the checking process using Excel formulas or VBA? I need to highlight the rows in B that do not correctly match its respective row in A.

I need a formula to search file A for the combination and not just one row...E.g row 23 on File A may contain the combination I want the formula to see that row 3 on 'sheet 2' contains the same combination and return the yes or formula to see that the combination does not exist in rows 3 through 200 and return a NO and highlight it

TLDR:
Is there a way for me to automate checking? If the data combination in each row cannot be found in reference File A, I need to highlight it. This is a HR file, Drilling down from Macro to Micro organization breakdown.

2. ## Re: Determine if combination of data in Excel B referencing A, is correct

You may use this formula at J17

=COUNTIFS(\$A\$4:\$A\$7,C17,\$B\$4:\$B\$7,D17,\$C\$4:\$C\$7,E17,\$D\$4:\$D\$7,F17,\$E\$4:\$E\$7,G17,\$F\$4:\$F\$7,H17,\$G\$4:\$G\$7,I17)

Note: need to enter ' in I17 , countifs not support true blank cell in criteria.

Regards.

3. ## Re: Determine if combination of data in Excel B referencing A, is correct

Not sure why it is not working on my large main file. The error that comes up is : "You've entered too many arguments for this function." I have placed the two files into one excel file on different sheets. Is my range too large to be handled? I am refercing 30,500 rows.

4. ## Re: Determine if combination of data in Excel B referencing A, is correct

Perhaps the following will work:
Formula:
`Please Login or Register  to view this content.`

Let us know if you have any questions.

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