Verify contents of one row are in another

[DougStroud]

I have a series of alpha values in column "I" and a control group of values in column "B". I need to find any missing values in column "B" that may exist in column "I".

Example-
Column I has: P, BS, SS, A, W, P, INV
Column B has everything except P and INV.

This is a simplification, there are a lot more values involved. That is the reason for coming up with a formula to check for missing values.


Thanks!

 

[Joe4]

One way is to use Conditional Formatting.

Assuming that you only have one value per cell, let's say that you have entries in column I from rows 1 to 10. Then do the following:
1. Select range I1:I10
2. Go to Conditional Formatting, and enter the following formula:

=COUNTIF(B:B,I1)=0

3. Choose a formatting option (like yellow highlighting)

This will highlight all the values in column I that are not found in column B.