Solved

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

Posted on 2011-03-17
2
274 Views
Last Modified: 2012-05-11
I think the question explains itself somewhat. The attached workbook will make it completely clear I hope.

Thanks!

John
CompareLists.xls
0
Comment
Question by:gabrielPennyback
2 Comments
 
LVL 24

Accepted Solution

by:
StephenJR earned 500 total points
ID: 35160110
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
 
LVL 1

Author Comment

by:gabrielPennyback
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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
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 …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question