Compare Two Lists

I have two lists of values. I want to compare both lists, and return a list of values that are in list 1, but not in list 2. In this example, the lists are in column a and b.

Hi Steve

Check out Chip's site here:
http://www.cpearson.com/excel/duplic...#InOneNotOther

Andy.

"steve_g" <steve_g.29araq_1150128611.5589@excelforum-nospam.com> wrote in
message news:steve_g.29araq_1150128611.5589@excelforum-nospam.com...
>
> I have two lists of values. I want to compare both lists, and return a
> list of values that are in list 1, but not in list 2. In this example,
> the lists are in column a and b.
>
>
> --
> steve_g
> ------------------------------------------------------------------------
> steve_g's Profile:
> http://www.excelforum.com/member.php...o&userid=24410
> View this thread: http://www.excelforum.com/showthread...hreadid=551067
>