Perhaps another way. Copy/paste Store# (like column F below) > remove duplicates and then in G2 this and filled down. There are also formula methods for removing duplicates. The Remove Duplicates feature is simpler and without calculation overhead.
|
A |
B |
C |
D |
E |
F |
G |
1 |
Date |
Store |
Product |
Store Date |
|
Store |
Counts |
2 |
1/1/2018 |
1234 |
A |
123443101 |
|
1234 |
2 |
3 |
2/18/2018 |
7890 |
Z |
789043149 |
|
7890 |
3 |
4 |
2/18/2018 |
7890 |
Y |
789043149 |
|
|
|
5 |
2/18/2018 |
7890 |
X |
789043149 |
|
|
|
6 |
3/1/2018 |
1234 |
B |
123443160 |
|
|
|
7 |
3/1/2018 |
1234 |
C |
123443160 |
|
|
|
8 |
6/5/2018 |
7890 |
M |
789043256 |
|
|
|
9 |
7/15/2018 |
7890 |
N |
789043296 |
|
|
|
Does this help?
Bookmarks