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
277 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

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

756 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