Obviously I did a terrible job trying to explain what I trying to do, so I start from scratch. I changed the A,B,C to a count to try to make more sense of it.
The same invoice number could appear on the list for several days, and then get back on the list. In the example the file contains three invoice numbers.
In the example, invoice # "1235" appears on the list on three consecutive date ranges. 1/5/17 - 1/6/17, which would get put in the queue for first time a -1 after the invoice #. Then on 1/11/17 it would be back in the queue as -2. And then again for 1/21/17 - 1/22/17 it would get a -3.
Column E is intended to just illustrate the values of what column C should be. (There won't actually be a column E queue)
PS... the formula I have in column C is clearly wrong, it was just my attempt at trying to get something to work.
Bookmarks