So I have a list of products that may show up on a report for consecutive dates. I'd like to count the current consecutive Workdays (Monday -Friday) the product has been on the list and reset the counter once it disappears for 1 day. Thank you in advance. Dean
<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>
A | B | |
---|---|---|
1 | Report Day | Product # |
2 | 5/1/2019 | 115112 |
3 | 5/1/2019 | 110123 |
4 | 5/1/2019 | 995000 |
5 | 5/2/2019 | 115112 |
6 | 5/2/2019 | 99500 |
7 | 5/3/2019 | 115112 |
8 | 5/3/2019 | 110123 |
9 | 5/6/2019 | 995000 |
10 | 5/6/2019 | 110123 |
11 | 5/6/2019 | 995000 |
12 | 5/7/2019 | 995000 |
13 | 5/8/2019 | 115112 |
14 | 5/8/2019 | 110123 |
15 | 5/8/2019 | 995000 |
16 | 5/9/2019 | 115112 |
17 | 5/9/2019 | 110123 |
18 | 5/9/2019 | 995000 |
19 | 5/10/2019 | 115112 |
<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet1