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
|