Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
array formula to show differences in 2 lists?
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Show Top 10 with array formula | Excel Worksheet Functions | |||
Formula to calculate differences between dates?? | Excel Discussion (Misc queries) | |||
How can I differences in two Excel Workbook lists automaticall | Excel Discussion (Misc queries) | |||
How do I compare 2 text columns & show differences in 3rd? | Excel Worksheet Functions | |||
Array Formula? Lists? | Excel Worksheet Functions |