ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Find values in one list that do not appear in a second list (https://www.excelbanter.com/excel-discussion-misc-queries/214534-find-values-one-list-do-not-appear-second-list.html)

Gwen Struve

Find values in one list that do not appear in a second list
 
I have a master set of values (List A), and a second set of working values
(List B). I would like to have Excel tell me which values are in List A that
are not in List B.

Pecoflyer[_55_]

Find values in one list that do not appear in a second list
 

Hi,
you'll find the solution 'here'
(http://www.cpearson.com/excel/ListFunctions.aspx)


--
Pecoflyer

Cheers -
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=43808



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

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