Hello,
can someone please help me? I need to look through 300K rows and identify unique count if 2 conditions are meet. Column A has dates which would be used to identify as unique column B contains Day mane witch it is the 1 st criteria and column C has store ID witch it is 2 criteria.
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
can someone please help me? I need to look through 300K rows and identify unique count if 2 conditions are meet. Column A has dates which would be used to identify as unique column B contains Day mane witch it is the 1 st criteria and column C has store ID witch it is 2 criteria.
A | B | C | D | E | F | G | H | I | J | K | L | M | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Date | Day | STORE_ID | Store | Day | Day | Day | Day | Day | Day | Day | ||
2 | 12/28/2017 | Thursday | 1 | 2 | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | ||
3 | 12/28/2017 | Thursday | 2 | ||||||||||
4 | 12/28/2017 | Thursday | 2 | Output | 4 | 0 | 0 | 3 | 0 | 0 | |||
5 | 12/28/2017 | Thursday | 3 | ||||||||||
6 | 1/4/2018 | Thursday | 5 | ||||||||||
7 | 1/4/2018 | Thursday | 2 | ||||||||||
8 | 1/4/2018 | Thursday | 1 | ||||||||||
9 | 1/11/2018 | Thursday | 2 | ||||||||||
10 | 1/11/2018 | Thursday | 2 | ||||||||||
11 | 1/18/2018 | Thursday | 1 | ||||||||||
12 | 1/18/2018 | Thursday | 5 | ||||||||||
13 | 1/25/2018 | Thursday | 6 | ||||||||||
14 | 1/25/2018 | Thursday | 2 | ||||||||||
15 | 1/25/2018 | Thursday | 2 | ||||||||||
16 | 12/28/2017 | Monday | 1 | ||||||||||
17 | 12/28/2017 | Monday | 8 | ||||||||||
18 | 12/28/2017 | Monday | 9 | ||||||||||
19 | 12/28/2017 | Monday | 6 | ||||||||||
20 | 1/4/2018 | Monday | 5 | ||||||||||
21 | 1/4/2018 | Monday | 2 | ||||||||||
22 | 1/4/2018 | Monday | 1 | ||||||||||
23 | 1/11/2018 | Monday | 2 | ||||||||||
24 | 1/11/2018 | Monday | 2 | ||||||||||
25 | 1/18/2018 | Monday | 1 | ||||||||||
26 | 1/18/2018 | Monday | 5 | ||||||||||
27 | 1/25/2018 | Monday | 6 | ||||||||||
28 | 1/25/2018 | Monday | 2 | ||||||||||
29 | 1/25/2018 | Monday | 2 |
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet1