Formula, Function or Macro that will find all values in List 1 that are missing in List 2

I think the question explains itself somewhat. The attached workbook will make it completely clear I hope.

Thanks!

John
CompareLists.xls
LVL 1
John CarneyReliability Business Tools Analyst IIAsked:
Who is Participating?
 
StephenJRConnect With a Mentor Commented:
What about conditional formatting?

Select B3 and down, and (in xl 2003) use Formula Is =COUNTIF(List2,B3)=0 and select your formatting.

Then select C3 and down, Formula Is =COUNTIF(List1,C3)=0 and select formatting.
0
 
John CarneyReliability Business Tools Analyst IIAuthor Commented:
Thanks, Stephen. And of course I can use that in a formula to produce a phrase or value in an offset cell, which is actually my ultimate goal.

Thanks,
John
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.