Spreadsheet: 740243d1626253158-formula-to-look-up-how-many-records-there-are-for-a-serial-number-on-a-certain-date-find-date
Sheet: Sheet2

Column1 | Date | S# | Column15 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12 | Column13 | Column14
 | 2021-06-16 00:00:00 | S_001702
 | 2021-06-16 00:00:00 | S_001762
 | 2021-06-16 00:00:00 | S_001641
 | 2021-06-16 00:00:00 | S_001641
 | 2021-06-16 00:00:00 | S_001673
 | 2021-06-16 00:00:00 | S_000716
 | 2021-06-16 00:00:00 | S_001754
 | 2021-06-16 00:00:00 | S_001023
 | 2021-06-16 00:00:00 | S_001900
 | 2021-06-17 00:00:00 | S_001702
 | 2021-06-17 00:00:00 | S_001754
 | 2021-06-17 00:00:00 | S_001023
 | 2021-06-17 00:00:00 | S_000898
 | 2021-06-17 00:00:00 | S_001900
 | 2021-06-18 00:00:00 | S_002015
 | 2021-06-18 00:00:00 | S_001979
 | 2021-06-18 00:00:00 | S_001979
 | 2021-06-18 00:00:00 | S_001979
 | 2021-06-18 00:00:00 | S_001762
 | 2021-06-18 00:00:00 | S_001762
 | 2021-06-18 00:00:00 | S_001762
 | 2021-06-18 00:00:00 | S_001762
 | 2021-06-18 00:00:00 | S_002039
 | 2021-06-18 00:00:00 | S_002039
 | 2021-06-18 00:00:00 | S_002039
 | 2021-06-18 00:00:00 | S_002039
 | 2021-06-18 00:00:00 | S_001754
 | 2021-06-18 00:00:00 | S_002014
 | 2021-06-18 00:00:00 | S_001023
 | 2021-06-18 00:00:00 | S_001023
 | 2021-06-18 00:00:00 | S_000898
 | 2021-06-18 00:00:00 | S_000898
 | 2021-06-18 00:00:00 | S_000898
 | 2021-06-18 00:00:00 | S_000898
 | 2021-06-18 00:00:00 | S_001900
 | 2021-06-19 00:00:00 | S_000716
 | 2021-06-19 00:00:00 | S_001762
 | 2021-06-19 00:00:00 | S_001023
 | 2021-06-19 00:00:00 | S_000898
 | 2021-06-20 00:00:00 | S_001762
 | 2021-06-20 00:00:00 | S_001023
 | 2021-06-20 00:00:00 | S_000898
 | 2021-06-21 00:00:00 | S_001023
 | 2021-06-21 00:00:00 | S_002014
 | 2021-06-21 00:00:00 | S_000898
 | 2021-06-22 00:00:00 | S_001979
 | 2021-06-22 00:00:00 | S_001979
 | 2021-06-22 00:00:00 | S_001762
 | 2021-06-22 00:00:00 | S_000898
 | 2021-06-23 00:00:00 | S_001900
 | 2021-06-23 00:00:00 | S_001762
 | 2021-06-23 00:00:00 | S_000898
 | 2021-06-23 00:00:00 | S_001023
 | 2021-06-23 00:00:00 | S_001023
 | 2021-06-24 00:00:00 | S_001762
 | 2021-06-24 00:00:00 | S_000898
 | 2021-06-24 00:00:00 | S_001023
 | 2021-06-25 00:00:00 | S_002015
 | 2021-06-25 00:00:00 | S_001979
 | 2021-06-25 00:00:00 | S_002014
 | 2021-06-25 00:00:00 | S_002014
 | 2021-06-25 00:00:00 | S_002014
 | 2021-06-25 00:00:00 | S_002039
 | 2021-06-25 00:00:00 | S_002039
 | 2021-06-25 00:00:00 | S_002039
 | 2021-06-25 00:00:00 | S_000898
 | 2021-06-25 00:00:00 | S_001762
 | 2021-06-25 00:00:00 | S_001023
 | 2021-06-25 00:00:00 | S_001023
 | 2021-06-25 00:00:00 | S_001023
 | 2021-06-26 00:00:00 | S_001754
 | 2021-06-26 00:00:00 | S_000716
 | 2021-06-27 00:00:00 | S_001641
 | 2021-06-27 00:00:00 | S_001673
 | 2021-06-27 00:00:00 | S_001754
 | 2021-06-27 00:00:00 | S_000716
 | 2021-06-27 00:00:00 | S_000716
 | 2021-06-28 00:00:00 | S_000716
 | 2021-06-28 00:00:00 | S_000716
 | 2021-06-27 00:00:00 | S_001762
 | 2021-06-27 00:00:00 | S_001702
 | 2021-06-27 00:00:00 | S_001641
 | 2021-06-27 00:00:00 | S_001641
 | 2021-06-27 00:00:00 | S_001641
 | 2021-06-27 00:00:00 | S_001023
 | 2021-06-27 00:00:00 | S_001979
 | 2021-06-27 00:00:00 | S_001979
 | 2021-06-27 00:00:00 | S_001023
 | 2021-07-01 00:00:00 | S_001023
 | 2021-07-02 00:00:00 | S_001023
 | 2021-07-02 00:00:00 | S_001023
 | 2021-06-30 00:00:00 | S_002039
 | 2021-07-02 00:00:00 | S_002039
 | 2021-07-02 00:00:00 | S_002039
 | 2021-07-04 00:00:00 | S_001023
 | 2021-06-26 00:00:00 | S_001900
 | 2021-06-27 00:00:00 | S_001900
 | 2021-06-29 00:00:00 | S_001900
 | 2021-06-30 00:00:00 | S_001900
 | 2021-07-01 00:00:00 | S_001900
 | 2021-07-02 00:00:00 | S_001900
 | 2021-07-02 00:00:00 | S_001979
 | 2021-06-16 00:00:00 | S_001905
 | 2021-06-16 00:00:00 | S_002050
 | 2021-06-16 00:00:00 | S_001978
 | 2021-06-17 00:00:00 | S_001905
 | 2021-06-17 00:00:00 | S_001401
 | 2021-06-17 00:00:00 | S_002050
 | 2021-06-17 00:00:00 | S_001978
 | 2021-06-17 00:00:00 | S_002012
 | 2021-06-18 00:00:00 | S_001401
 | 2021-06-18 00:00:00 | S_002050
 | 2021-06-18 00:00:00 | S_001978
 | 2021-06-18 00:00:00 | S_002012
 | 2021-06-19 00:00:00 | S_001532
 | 2021-06-19 00:00:00 | S_001401
 | 2021-06-19 00:00:00 | S_001978
 | 2021-06-20 00:00:00 | S_001905
 | 2021-06-20 00:00:00 | S_001532
 | 2021-06-20 00:00:00 | S_001401
 | 2021-06-20 00:00:00 | S_002050
 | 2021-06-20 00:00:00 | S_001978
 | 2021-06-21 00:00:00 | S_001905
 | 2021-06-21 00:00:00 | S_001532
 | 2021-06-21 00:00:00 | S_001401
 | 2021-06-21 00:00:00 | S_001978
 | 2021-06-21 00:00:00 | S_002012
 | 2021-06-22 00:00:00 | S_001532
 | 2021-06-22 00:00:00 | S_001401
 | 2021-06-22 00:00:00 | S_001978
 | 2021-06-22 00:00:00 | S_002012
 | 2021-06-23 00:00:00 | S_001905
 | 2021-06-23 00:00:00 | S_001532
 | 2021-06-23 00:00:00 | S_001401
 | 2021-06-23 00:00:00 | S_002012
 | 2021-06-24 00:00:00 | S_001905
 | 2021-06-24 00:00:00 | S_001401
 | 2021-06-24 00:00:00 | S_001978
 | 2021-06-24 00:00:00 | S_002012
 | 2021-06-25 00:00:00 | S_001401
 | 2021-06-25 00:00:00 | S_002012
 | 2021-06-26 00:00:00 | S_001532
 | 2021-06-26 00:00:00 | S_001401
 | 2021-06-26 00:00:00 | S_002012
 | 2021-06-27 00:00:00 | S_001905
 | 2021-06-27 00:00:00 | S_001532
 | 2021-06-27 00:00:00 | S_001401
 | 2021-06-27 00:00:00 | S_001978
 | 2021-06-28 00:00:00 | S_001905
 | 2021-06-28 00:00:00 | S_001532
 | 2021-06-28 00:00:00 | S_001401
 | 2021-06-28 00:00:00 | S_001978
 | 2021-06-28 00:00:00 | S_002012
 | 2021-06-29 00:00:00 | S_001905
 | 2021-06-29 00:00:00 | S_001532
 | 2021-06-29 00:00:00 | S_002050
 | 2021-06-29 00:00:00 | S_002012
 | 2021-06-30 00:00:00 | S_001532
 | 2021-06-30 00:00:00 | S_001401
 | 2021-06-30 00:00:00 | S_002050
 | 2021-07-01 00:00:00 | S_001905
 | 2021-07-01 00:00:00 | S_001532
 | 2021-07-01 00:00:00 | S_001401
 | 2021-07-01 00:00:00 | S_001978
 | 2021-07-02 00:00:00 | S_001532
 | 2021-07-02 00:00:00 | S_001978
 | 2021-07-02 00:00:00 | S_002012
 | 2021-07-03 00:00:00 | S_001401
 | 2021-07-03 00:00:00 | S_001978
 | 2021-07-03 00:00:00 | S_002012
 | 2021-07-04 00:00:00 | S_001905
 | 2021-07-04 00:00:00 | S_001532
 | 2021-06-18 00:00:00 | S_002014
 | 2021-06-21 00:00:00 | S_002014
 | 2021-06-27 00:00:00 | S_002014
 | 2021-07-02 00:00:00 | S_002014
 | 2021-07-07 00:00:00 | S_002014
 | 2021-07-07 00:00:00 | S_002014
 | 2021-06-26 00:00:00 | S_001754
 | 2021-06-27 00:00:00 | S_001754
 | 2021-06-28 00:00:00 | S_001754
 | 2021-06-29 00:00:00 | S_001754
 | 2021-06-30 00:00:00 | S_001754
 | 2021-07-01 00:00:00 | S_001754
 | 2021-07-02 00:00:00 | S_001754
 | 2021-07-06 00:00:00 | S_001754
 | 2021-07-07 00:00:00 | S_001023
 | 2021-07-07 00:00:00 | S_001023
 | 2021-07-07 00:00:00 | S_001900
 | 2021-07-07 00:00:00 | S_001673
 | 2021-07-09 00:00:00 | S_001023
 | 2021-06-30 00:00:00 | S_001762
 | 2021-07-03 00:00:00 | S_001762
 | 2021-07-04 00:00:00 | S_001762
 | 2021-07-05 00:00:00 | S_001762
 | 2021-07-06 00:00:00 | S_001762
 | 2021-07-07 00:00:00 | S_001762
 | 2021-07-08 00:00:00 | S_001762
 | 2021-07-09 00:00:00 | S_001762
 | 2021-07-02 00:00:00 | S_001979
 | 2021-07-09 00:00:00 | S_001979
 | 2021-07-09 00:00:00 | S_001979
 | 2021-07-10 00:00:00 | S_001979
 | 2021-07-05 00:00:00 | S_001905
 | 2021-07-05 00:00:00 | S_001905
 | 2021-07-06 00:00:00 | S_001905
 | 2021-07-06 00:00:00 | S_001905
 | 2021-07-07 00:00:00 | S_001905
 | 2021-07-08 00:00:00 | S_001905
 | 2021-07-09 00:00:00 | S_002014
 | 2021-07-09 00:00:00 | S_002014
 | 2021-07-09 00:00:00 | S_002014
 | 2021-07-09 00:00:00 | S_002014
 | 2021-06-17 00:00:00 | S_001483
 | 2021-06-17 00:00:00 | S_001483
 | 2021-06-18 00:00:00 | S_001483
 | 2021-06-20 00:00:00 | S_001483
 | 2021-06-20 00:00:00 | S_001483
 | 2021-06-20 00:00:00 | S_001483
 | 2021-06-21 00:00:00 | S_001483
 | 2021-06-21 00:00:00 | S_001483
 | 2021-06-22 00:00:00 | S_001483
 | 2021-06-23 00:00:00 | S_001483
 | 2021-06-24 00:00:00 | S_001483
 | 2021-06-24 00:00:00 | S_001483
 | 2021-06-24 00:00:00 | S_001483
 | 2021-06-25 00:00:00 | S_001483
 | 2021-06-26 00:00:00 | S_001483
 | 2021-06-30 00:00:00 | S_001483
 | 2021-07-02 00:00:00 | S_001483
 | 2021-07-03 00:00:00 | S_001483
 | 2021-07-04 00:00:00 | S_001483
 | 2021-06-17 00:00:00 | S_002011
 | 2021-06-18 00:00:00 | S_002011
 | 2021-06-19 00:00:00 | S_002011
 | 2021-06-21 00:00:00 | S_002011
 | 2021-06-21 00:00:00 | S_002011
 | 2021-06-22 00:00:00 | S_002011
 | 2021-06-23 00:00:00 | S_002011
 | 2021-06-24 00:00:00 | S_002011
 | 2021-06-25 00:00:00 | S_002011
 | 2021-06-30 00:00:00 | S_002011
 | 2021-06-30 00:00:00 | S_002011
 | 2021-07-01 00:00:00 | S_002011
 | 2021-07-01 00:00:00 | S_002011
 | 2021-07-02 00:00:00 | S_002011
 | 2021-07-04 00:00:00 | S_002011
 | 2021-07-04 00:00:00 | S_002011
 | 2021-07-04 00:00:00 | S_002011
 | 2021-07-05 00:00:00 | S_002011
 | 2021-07-05 00:00:00 | S_002011
 | 2021-07-06 00:00:00 | S_002011
 | 2021-07-06 00:00:00 | S_002011
 | 2021-06-18 00:00:00 | L_052689
 | 2021-06-21 00:00:00 | L_052689
 | 2021-06-25 00:00:00 | L_052689
 | 2021-06-25 00:00:00 | L_052689
 | 2021-06-25 00:00:00 | L_052689
 | 2021-06-27 00:00:00 | L_052689
 | 2021-06-30 00:00:00 | L_052689
 | 2021-07-01 00:00:00 | L_052689
 | 2021-07-02 00:00:00 | L_052689
 | 2021-07-09 00:00:00 | L_052689
 | 2021-07-09 00:00:00 | L_052689
 | 2021-07-09 00:00:00 | L_052689
 | 2021-06-29 00:00:00 | S_000898
 | 2021-07-02 00:00:00 | S_000898
 | 2021-07-03 00:00:00 | S_000898
 | 2021-07-04 00:00:00 | S_000898
 | 2021-07-05 00:00:00 | S_000898
 | 2021-07-06 00:00:00 | S_000898
 | 2021-07-07 00:00:00 | S_000898
 | 2021-07-08 00:00:00 | S_000898
 | 2021-07-09 00:00:00 | S_002039
 | 2021-07-09 00:00:00 | S_002039
 | 2021-07-09 00:00:00 | S_002039
 | 2021-06-28 00:00:00 | S_002015
 | 2021-07-02 00:00:00 | S_002015
 | 2021-07-09 00:00:00 | S_002015
 | 2021-07-12 00:00:00 | S_001023
 | 2021-07-12 00:00:00 | S_001979
 | 2021-07-12 00:00:00 | S_001762
 | 2021-06-27 00:00:00 | S_001641
 | 2021-06-27 00:00:00 | S_001641
 | 2021-06-27 00:00:00 | S_001641
 | 2021-06-27 00:00:00 | S_001641
 | 2021-07-09 00:00:00 | S_001641
 | 2021-07-12 00:00:00 | S_001641
 | 2021-07-12 00:00:00 | S_001641
 | 2021-06-27 00:00:00 | S_001702
 | 2021-07-12 00:00:00 | S_001702
 | 2021-07-10 00:00:00 | S_001900
 | 2021-07-11 00:00:00 | S_001900
 | 2021-07-12 00:00:00 | S_001900
 | 2021-07-04 00:00:00 | S_001532
 | 2021-07-05 00:00:00 | S_001532
 | 2021-07-06 00:00:00 | S_001532
 | 2021-07-09 00:00:00 | S_001532
 | 2021-07-10 00:00:00 | S_001532
 | 2021-07-11 00:00:00 | S_001532