Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
Solved

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

Posted on 2011-03-17
Medium Priority
301 Views
I think the question explains itself somewhat. The attached workbook will make it completely clear I hope.

Thanks!

John
CompareLists.xls
0
Question by:gabrielPennyback
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 24

Accepted Solution

StephenJR earned 2000 total points
ID: 35160110

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

LVL 1

Author Comment

ID: 35160440
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

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
###### Suggested Courses
Course of the Month12 days, left to enroll