ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Compare Two Lists (https://www.excelbanter.com/excel-worksheet-functions/93511-compare-two-lists.html)

steve_g

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.


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



Compare Two Lists
 
Hi Steve

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

Andy.

"steve_g" wrote in
message ...

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





All times are GMT +1. The time now is 08:13 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com