Assuming your lists are in columns A and B, and column a goes from row 1 (A1)
to row 1000 (A1000), and you want to find out if a value from that column
also appears in (or is missing from) column B, then in a column put this
formula in row 1 and fill it down to the end of the list in column A. This
assumes that the list in B goes from row 1 to row 500, but it could be of any
length, just change the address in the formula:
=IF(COUNTIF(B$1:B$500,A1)=0,A1 & " is Missing from Second Column","")

"damanwitdaplan" wrote:

I have 2 different sets of values in 2 columns that are constantly changing.
I want excel to be able to find a missing value between the 2 columns data
and list the missing values in order. Which function(s) should I use.

If you want me to email the worksheet to you, just email me at


Thanks in advance