View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
halem2[_41_] halem2[_41_] is offline
external usenet poster
 
Posts: 1
Default Comparing two lists


Hi:

I have two lists in the same sheet side to side. List one has 80
values and list 2 has 400 values. Is there a sub that would compar
every value in list 1 against every value in list 2 and if the valu
does not exist in list 2, create another list with the values not foun
in list 2 ?

* _List_1_ *
2
3
4