I'm needing to compare two lists of stores each week, and am wondering if
this can be done using some kind of array formula, or if vba would be needed.
From one week to the next, the list of stores will not change much, but
there could be a few stores that drop off, and a few new stores added. I
eventually want to graph for a given week, the count of stores, and the
number of new stores added, as well as the number of stores that fell off the
list. The data could look something like this:

week1 week2
1 1
2 2
3 4
4 5
5 6
7

In this example, my store count in week2 would be 6, with 1 store falling
off, and 2 new stores being added. Is there a formula that would tell me the
number of stores that fell off? And another formula to tell me the number of
stores that were added?

Jeff