View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Craig[_4_] Craig[_4_] is offline
external usenet poster
 
Posts: 5
Default Function help needed!

I'm wondering if it is possible to create a function that will list items
missing from one list to another.

A B C
1 Master List B List C List
2 one two one
3 two four three
4 three five seven
5 four six nine
6 five eight
7 six
8 seven
9 eight
10 nine


In this example I would like the function to list the missing items in
column "C", I would like it to update if the B list changes.

I have inserted a picture of my example in case this text formatting doesn't
hold out when I post it.

Any Help is much Appreciated!

Craig