Hi,

You will probably have to resort to a macro to do this.
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"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