Column A is the Ticket Date of Service, Column B is Ticket Date Entered.
Column C is the number of tickets entered on the Date in Column B for the
date in Column A. Column D is Date Entered minus Date of Service using
networkdays. In Column E are formula's that extract the unique numbers from
Column D. I now need formula's in Column F to find each occurrence of a
number in Column E from Column D and add the number of tickets in Column C.
That is: I need to know how many tickets were entered X days after the Date
of Service. For example: In Column E, the following numbers were extracted
from Column D: 3, 4, 5, 7, 8 and 10. I need to know how many tickets were
entered 3 days after the date of service, 4 days after, 5, 7, 8 and 10 days
after. These numbers may occur multiple times in Column D. I sure hope
this makes sense. Everyone here has been so helpful and I'm hoping someone
can assist me with this last formula. Thank you, Diane