Spreadsheet: 740248d1626254847-formula-to-look-up-how-many-records-there-are-for-a-serial-number-on-a-certain-date-find-date
Sheet: Data

Column1 | Date | S no | Plate# | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12 | Column13 | Column14
 | 2021-06-16 00:00:00 | S_001702 | ASB 5985
 | 2021-06-16 00:00:00 | S_001762 | VAB 6976
 | 2021-06-16 00:00:00 | S_001641 | TDB 3717
 | 2021-06-16 00:00:00 | S_001641 | HRB 1544
 | 2021-06-16 00:00:00 | S_001673 | ZHA 1255
 | 2021-06-16 00:00:00 | S_000716 | HRB 1544
 | 2021-06-16 00:00:00 | S_001754 | HRB 1506
 | 2021-06-16 00:00:00 | S_001023 | TDB 3717
 | 2021-06-16 00:00:00 | S_001900 | ASB 5663
 | 2021-06-17 00:00:00 | S_001702 | HRB 1646
 | 2021-06-17 00:00:00 | S_001754 | HRB 1506
 | 2021-06-17 00:00:00 | S_001023 | HRB 1544
 | 2021-06-17 00:00:00 | S_000898 | VAB 6976
 | 2021-06-17 00:00:00 | S_001900 | ASB 5663
 | 2021-06-18 00:00:00 | S_002015 | HRB 1544
 | 2021-06-18 00:00:00 | S_001979 | HRB 1646
 | 2021-06-18 00:00:00 | S_001979 | HRB 1506
 | 2021-06-18 00:00:00 | S_001979 | HRB 1506
 | 2021-06-18 00:00:00 | S_001762 | HBB 8423
 | 2021-06-18 00:00:00 | S_001762 | HBB 8423
 | 2021-06-18 00:00:00 | S_001762 | HBB 8423
 | 2021-06-18 00:00:00 | S_001762 | HBB 8423
 | 2021-06-18 00:00:00 | S_002039 | HBB 8423
 | 2021-06-18 00:00:00 | S_002039 | VAB 6976
 | 2021-06-18 00:00:00 | S_002039 | ASB 5985
 | 2021-06-18 00:00:00 | S_002039 | ASB 5985
 | 2021-06-18 00:00:00 | S_001754 | VAB 6976
 | 2021-06-18 00:00:00 | S_002014 | HRB 1646
 | 2021-06-18 00:00:00 | S_001023 | HBB 8423
 | 2021-06-18 00:00:00 | S_001023 | HRB 1646
 | 2021-06-18 00:00:00 | S_000898 | VAB 6976
 | 2021-06-18 00:00:00 | S_000898 | ASB 5985
 | 2021-06-18 00:00:00 | S_000898 | ASB 5663
 | 2021-06-18 00:00:00 | S_000898 | ASB 5663
 | 2021-06-18 00:00:00 | S_001900 | ZHA 1255
 | 2021-06-19 00:00:00 | S_000716 | ASB 5985
 | 2021-06-19 00:00:00 | S_001762 | HBB 8423
 | 2021-06-19 00:00:00 | S_001023 | HRB 1646
 | 2021-06-19 00:00:00 | S_000898 | VAB 6976
 | 2021-06-20 00:00:00 | S_001762 | HBB 8423
 | 2021-06-20 00:00:00 | S_001023 | HRB 1506
 | 2021-06-20 00:00:00 | S_000898 | VAB 6976
 | 2021-06-21 00:00:00 | S_001023 | VAB 6976
 | 2021-06-21 00:00:00 | S_002014 | HRB 1646
 | 2021-06-21 00:00:00 | S_000898 | ASB 5663
 | 2021-06-22 00:00:00 | S_001979 | HRB 1646
 | 2021-06-22 00:00:00 | S_001979 | HRB 1421
 | 2021-06-22 00:00:00 | S_001762 | HRB 1421
 | 2021-06-22 00:00:00 | S_000898 | ASB 5663
 | 2021-06-23 00:00:00 | S_001900 | HRB 1646
 | 2021-06-23 00:00:00 | S_001762 | HRB 1421
 | 2021-06-23 00:00:00 | S_000898 | ASB 5663
 | 2021-06-23 00:00:00 | S_001023 | HRB 1646
 | 2021-06-23 00:00:00 | S_001023 | HRB 1421
 | 2021-06-24 00:00:00 | S_001762 | HRB 1421
 | 2021-06-24 00:00:00 | S_000898 | ASB 5663
 | 2021-06-24 00:00:00 | S_001023 | HRB 1506
 | 2021-06-25 00:00:00 | S_002015 | HRB 1544
 | 2021-06-25 00:00:00 | S_001979 | ASB 5985
 | 2021-06-25 00:00:00 | S_002014 | ASB 5985
 | 2021-06-25 00:00:00 | S_002014 | ASB 5985
 | 2021-06-25 00:00:00 | S_002014 | ASB 5985
 | 2021-06-25 00:00:00 | S_002039 | HRB 1646
 | 2021-06-25 00:00:00 | S_002039 | HRB 1646
 | 2021-06-25 00:00:00 | S_002039 | HRB 1646
 | 2021-06-25 00:00:00 | S_000898 | ASB 5663
 | 2021-06-25 00:00:00 | S_001762 | HRB 1421
 | 2021-06-25 00:00:00 | S_001023 | ASB 5663
 | 2021-06-25 00:00:00 | S_001023 | ASB 5663
 | 2021-06-25 00:00:00 | S_001023 | ASB 5663
 | 2021-06-26 00:00:00 | S_001754 | HRB 1421
 | 2021-06-26 00:00:00 | S_000716 | ASB 5985
 | 2021-06-27 00:00:00 | S_001641 | ASB 5663
 | 2021-06-27 00:00:00 | S_001673 | TDB 3979
 | 2021-06-27 00:00:00 | S_001754 | HRB 1421
 | 2021-06-27 00:00:00 | S_000716 | HRB 1646
 | 2021-06-27 00:00:00 | S_000716 | HRB 1646
 | 2021-06-28 00:00:00 | S_000716 | HRB 1506
 | 2021-06-28 00:00:00 | S_000716 | HRB 1506
 | 2021-06-27 00:00:00 | S_001762 | DDB 9141
 | 2021-06-27 00:00:00 | S_001702 | ASB 5985
 | 2021-06-27 00:00:00 | S_001641 | NRB 8096
 | 2021-06-27 00:00:00 | S_001641 | NRB 8096
 | 2021-06-27 00:00:00 | S_001641 | ASB 5663
 | 2021-06-27 00:00:00 | S_001023 | HRB 1421
 | 2021-06-27 00:00:00 | S_001979 | HRB 1646
 | 2021-06-27 00:00:00 | S_001979 | HRB 1506
 | 2021-06-27 00:00:00 | S_001023 | HRB 1646
 | 2021-07-01 00:00:00 | S_001023 | HRB 1421
 | 2021-07-02 00:00:00 | S_001023 | ASB 5985
 | 2021-07-02 00:00:00 | S_001023 | ASB 5985
 | 2021-06-30 00:00:00 | S_002039 | ASB 5985
 | 2021-07-02 00:00:00 | S_002039 | HRB 1646
 | 2021-07-02 00:00:00 | S_002039 | ASB 5985
 | 2021-07-04 00:00:00 | S_001023 | ASB 5663
 | 2021-06-26 00:00:00 | S_001900 | ASB 5663
 | 2021-06-27 00:00:00 | S_001900 | ASB 5663
 | 2021-06-29 00:00:00 | S_001900 | ASB 5663
 | 2021-06-30 00:00:00 | S_001900 | ASB 5663
 | 2021-07-01 00:00:00 | S_001900 | NRB 8096
 | 2021-07-02 00:00:00 | S_001900 | ASB 5663
 | 2021-07-02 00:00:00 | S_001979 | ASB 5663
 | 2021-06-16 00:00:00 | S_001905 | ASB 5983
 | 2021-06-16 00:00:00 | S_002050 | 8984
 | 2021-06-16 00:00:00 | S_001978 | HRB 1545
 | 2021-06-17 00:00:00 | S_001905 | ASB 5983
 | 2021-06-17 00:00:00 | S_001401 | EDB 8944
 | 2021-06-17 00:00:00 | S_002050 | 8984
 | 2021-06-17 00:00:00 | S_001978 | 5983&5656
 | 2021-06-17 00:00:00 | S_002012 | ASB 5656
 | 2021-06-18 00:00:00 | S_001401 | EDB 8944
 | 2021-06-18 00:00:00 | S_002050 | 8984
 | 2021-06-18 00:00:00 | S_001978 | 8943 &5656
 | 2021-06-18 00:00:00 | S_002012 | ZHA 1255
 | 2021-06-19 00:00:00 | S_001532 | HRB 1545
 | 2021-06-19 00:00:00 | S_001401 | EDB 8944
 | 2021-06-19 00:00:00 | S_001978 | 8944 &5656
 | 2021-06-20 00:00:00 | S_001905 | ASB 5983
 | 2021-06-20 00:00:00 | S_001532 | HRB 1545
 | 2021-06-20 00:00:00 | S_001401 | EDB 8944
 | 2021-06-20 00:00:00 | S_002050 | 8984
 | 2021-06-20 00:00:00 | S_001978 | ASB 5656
 | 2021-06-21 00:00:00 | S_001905 | ASB 5983
 | 2021-06-21 00:00:00 | S_001532 | HRB 1545
 | 2021-06-21 00:00:00 | S_001401 | EDB 8944
 | 2021-06-21 00:00:00 | S_001978 | ASB 5656
 | 2021-06-21 00:00:00 | S_002012 | VJB 8365
 | 2021-06-22 00:00:00 | S_001532 | HRB 1545
 | 2021-06-22 00:00:00 | S_001401 | EDB 8944
 | 2021-06-22 00:00:00 | S_001978 | ASB 5656
 | 2021-06-22 00:00:00 | S_002012 | VJB 8365
 | 2021-06-23 00:00:00 | S_001905 | ASB 5983
 | 2021-06-23 00:00:00 | S_001532 | HRB 1545
 | 2021-06-23 00:00:00 | S_001401 | EDB 8944
 | 2021-06-23 00:00:00 | S_002012 | VJB 8365
 | 2021-06-24 00:00:00 | S_001905 | ASB 5983
 | 2021-06-24 00:00:00 | S_001401 | EDB 8944
 | 2021-06-24 00:00:00 | S_001978 | 1545 &5656
 | 2021-06-24 00:00:00 | S_002012 | VJB 8365
 | 2021-06-25 00:00:00 | S_001401 | ASB 5656
 | 2021-06-25 00:00:00 | S_002012 | VJB 8365
 | 2021-06-26 00:00:00 | S_001532 | HRB 1545
 | 2021-06-26 00:00:00 | S_001401 | ASB 5656
 | 2021-06-26 00:00:00 | S_002012 | VJB 8365
 | 2021-06-27 00:00:00 | S_001905 | ASB 5983
 | 2021-06-27 00:00:00 | S_001532 | HRB 1545
 | 2021-06-27 00:00:00 | S_001401 | ASB 5656
 | 2021-06-27 00:00:00 | S_001978 | ASB 5989
 | 2021-06-28 00:00:00 | S_001905 | ASB 5983
 | 2021-06-28 00:00:00 | S_001532 | HRB 1545
 | 2021-06-28 00:00:00 | S_001401 | ASB 5661
 | 2021-06-28 00:00:00 | S_001978 | HRB 1545
 | 2021-06-28 00:00:00 | S_002012 | ASB 5656
 | 2021-06-29 00:00:00 | S_001905 | ASB 5983
 | 2021-06-29 00:00:00 | S_001532 | ASB 5661
 | 2021-06-29 00:00:00 | S_002050 | HRB 1545
 | 2021-06-29 00:00:00 | S_002012 | ASB 5656
 | 2021-06-30 00:00:00 | S_001532 | ASB 5661
 | 2021-06-30 00:00:00 | S_001401 | ASB 5656
 | 2021-06-30 00:00:00 | S_002050 | ASB 5984
 | 2021-07-01 00:00:00 | S_001905 | ASB 5983
 | 2021-07-01 00:00:00 | S_001532 | HRB 1545
 | 2021-07-01 00:00:00 | S_001401 | ASB 5661
 | 2021-07-01 00:00:00 | S_001978 | 1545& 5656
 | 2021-07-02 00:00:00 | S_001532 | ASB 5661
 | 2021-07-02 00:00:00 | S_001978 | DDB 9142
 | 2021-07-02 00:00:00 | S_002012 | HRB 1545
 | 2021-07-03 00:00:00 | S_001401 | ASB 5661
 | 2021-07-03 00:00:00 | S_001978 | ASB 5989
 | 2021-07-03 00:00:00 | S_002012 | HRB 1545
 | 2021-07-04 00:00:00 | S_001905 | ASB 5983
 | 2021-07-04 00:00:00 | S_001532 | ASB 5656
 | 2021-06-18 00:00:00 | S_002014 | HRB 1646
 | 2021-06-21 00:00:00 | S_002014 | HRB 1646
 | 2021-06-27 00:00:00 | S_002014 | ARB 3622
 | 2021-07-02 00:00:00 | S_002014 | ASB 5985
 | 2021-07-07 00:00:00 | S_002014 | HRB 1421
 | 2021-07-07 00:00:00 | S_002014 | DDB 9136
 | 2021-06-26 00:00:00 | S_001754 | HRB 1421
 | 2021-06-27 00:00:00 | S_001754 | HRB 1421
 | 2021-06-28 00:00:00 | S_001754 | HRB 1421
 | 2021-06-29 00:00:00 | S_001754 | HRB 1421
 | 2021-06-30 00:00:00 | S_001754 | HRB 1421
 | 2021-07-01 00:00:00 | S_001754 | HRB 1421
 | 2021-07-02 00:00:00 | S_001754 | NRB 8096
 | 2021-07-06 00:00:00 | S_001754 | HRB 1421
 | 2021-07-07 00:00:00 | S_001023 | ASB 5985
 | 2021-07-07 00:00:00 | S_001023 | ASB 5663
 | 2021-07-07 00:00:00 | S_001900 | HRB 1646
 | 2021-07-07 00:00:00 | S_001673 | HRB 1544
 | 2021-07-09 00:00:00 | S_001023 | ASB 5663
 | 2021-06-30 00:00:00 | S_001762 | HRB 1421
 | 2021-07-03 00:00:00 | S_001762 | NRB 8096
 | 2021-07-04 00:00:00 | S_001762 | NRB 8096
 | 2021-07-05 00:00:00 | S_001762 | NRB 8096
 | 2021-07-06 00:00:00 | S_001762 | NRB 8096
 | 2021-07-07 00:00:00 | S_001762 | NRB 8096
 | 2021-07-08 00:00:00 | S_001762 | HRB 1544
 | 2021-07-09 00:00:00 | S_001762 | HRB 1544
 | 2021-07-02 00:00:00 | S_001979 | ASB 5663
 | 2021-07-09 00:00:00 | S_001979 | HRB 1646
 | 2021-07-09 00:00:00 | S_001979 | HRB 1646
 | 2021-07-10 00:00:00 | S_001979 | ASB 5985
 | 2021-07-05 00:00:00 | S_001905 | ASB 5983
 | 2021-07-05 00:00:00 | S_001905 | ASB 5983
 | 2021-07-06 00:00:00 | S_001905 | ASB 5983
 | 2021-07-06 00:00:00 | S_001905 | ASB 5983
 | 2021-07-07 00:00:00 | S_001905 | ASB 5983
 | 2021-07-08 00:00:00 | S_001905 | ASB 5983
 | 2021-07-09 00:00:00 | S_002014 | ASB 5985
 | 2021-07-09 00:00:00 | S_002014 | ASB 5985
 | 2021-07-09 00:00:00 | S_002014 | ASB 5985
 | 2021-07-09 00:00:00 | S_002014 | ASB 5985
 | 2021-06-17 00:00:00 | S_001483 | HRB 1337
 | 2021-06-17 00:00:00 | S_001483 | EDB 6746
 | 2021-06-18 00:00:00 | S_001483 | EDB 6746
 | 2021-06-20 00:00:00 | S_001483 | EDB 6746
 | 2021-06-20 00:00:00 | S_001483 | EDB 6746
 | 2021-06-20 00:00:00 | S_001483 | EDB 6746
 | 2021-06-21 00:00:00 | S_001483 | EDB 6746
 | 2021-06-21 00:00:00 | S_001483 | HRB 1337
 | 2021-06-22 00:00:00 | S_001483 | EDB 6746
 | 2021-06-23 00:00:00 | S_001483 | EDB 6746
 | 2021-06-24 00:00:00 | S_001483 | EDB 6746
 | 2021-06-24 00:00:00 | S_001483 | 9476
 | 2021-06-24 00:00:00 | S_001483 | HRB 1337
 | 2021-06-25 00:00:00 | S_001483 | EDB 6746
 | 2021-06-26 00:00:00 | S_001483 | EDB 6746
 | 2021-06-30 00:00:00 | S_001483 | EDB 6746
 | 2021-07-02 00:00:00 | S_001483 | HRB 1337
 | 2021-07-03 00:00:00 | S_001483 | HRB 1337
 | 2021-07-04 00:00:00 | S_001483 | HRB 1337
 | 2021-06-17 00:00:00 | S_002011 | HRB 1337
 | 2021-06-18 00:00:00 | S_002011 | HRB 1337
 | 2021-06-19 00:00:00 | S_002011 | HRB 1337
 | 2021-06-21 00:00:00 | S_002011 | HRB 1337
 | 2021-06-21 00:00:00 | S_002011 | HRB 1337
 | 2021-06-22 00:00:00 | S_002011 | HRB 1337
 | 2021-06-23 00:00:00 | S_002011 | HRB 1337
 | 2021-06-24 00:00:00 | S_002011 | HRB 1337
 | 2021-06-25 00:00:00 | S_002011 | HRB 1337
 | 2021-06-30 00:00:00 | S_002011 | EDB 6746
 | 2021-06-30 00:00:00 | S_002011 | HRB 1337
 | 2021-07-01 00:00:00 | S_002011 | BJB 2711
 | 2021-07-01 00:00:00 | S_002011 | HRB 1337
 | 2021-07-02 00:00:00 | S_002011 | HRB 1337
 | 2021-07-04 00:00:00 | S_002011 | HRB 1337
 | 2021-07-04 00:00:00 | S_002011 | HRB 1337
 | 2021-07-04 00:00:00 | S_002011 | HRB 1337
 | 2021-07-05 00:00:00 | S_002011 | HRB 1337
 | 2021-07-05 00:00:00 | S_002011 | BJB 2711
 | 2021-07-06 00:00:00 | S_002011 | HRB 1337
 | 2021-07-06 00:00:00 | S_002011 | BJB 2711
 | 2021-06-18 00:00:00 | L_052689 | VAB 6976
 | 2021-06-21 00:00:00 | L_052689 | ASB 5985
 | 2021-06-25 00:00:00 | L_052689 | ASB 5985
 | 2021-06-25 00:00:00 | L_052689 | HRB 1544
 | 2021-06-25 00:00:00 | L_052689 | ASB 5985
 | 2021-06-27 00:00:00 | L_052689 | ARB 3622
 | 2021-06-30 00:00:00 | L_052689 | NRB 8096
 | 2021-07-01 00:00:00 | L_052689 | HRB 1506
 | 2021-07-02 00:00:00 | L_052689 | HRB 1646
 | 2021-07-09 00:00:00 | L_052689 | HRB 1646
 | 2021-07-09 00:00:00 | L_052689 | ASB 5985
 | 2021-07-09 00:00:00 | L_052689 | HRB 1506
 | 2021-06-29 00:00:00 | S_000898 | HRB 1646
 | 2021-07-02 00:00:00 | S_000898 | HRB 1421
 | 2021-07-03 00:00:00 | S_000898 | ASB 5663
 | 2021-07-04 00:00:00 | S_000898 | DDB 9136
 | 2021-07-05 00:00:00 | S_000898 | DDB 9136
 | 2021-07-06 00:00:00 | S_000898 | DDB 9136
 | 2021-07-07 00:00:00 | S_000898 | DDB 9136
 | 2021-07-08 00:00:00 | S_000898 | ASB 5663
 | 2021-07-09 00:00:00 | S_002039 | HRB 1506
 | 2021-07-09 00:00:00 | S_002039 | HRB 1646
 | 2021-07-09 00:00:00 | S_002039 | ASB 5985
 | 2021-06-28 00:00:00 | S_002015 | HRB 1544
 | 2021-07-02 00:00:00 | S_002015 | ASB 5663
 | 2021-07-09 00:00:00 | S_002015 | HRB 1506
 | 2021-07-12 00:00:00 | S_001023 | HRB 1544
 | 2021-07-12 00:00:00 | S_001979 | HRB 1421
 | 2021-07-12 00:00:00 | S_001762 | ASB 5663
 | 2021-06-27 00:00:00 | S_001641 | ASB 5663
 | 2021-06-27 00:00:00 | S_001641 | NRB 8096
 | 2021-06-27 00:00:00 | S_001641 | NRB 8096
 | 2021-06-27 00:00:00 | S_001641 | ASB 5663
 | 2021-07-09 00:00:00 | S_001641 | HRB 1646
 | 2021-07-12 00:00:00 | S_001641 | HRB 1646
 | 2021-07-12 00:00:00 | S_001641 | HRB 1646
 | 2021-06-27 00:00:00 | S_001702 | ASB 5985
 | 2021-07-12 00:00:00 | S_001702 | ASB 5985
 | 2021-07-10 00:00:00 | S_001900 | ASB 5663
 | 2021-07-11 00:00:00 | S_001900 | ASB 5663
 | 2021-07-12 00:00:00 | S_001900 | ASB 5663
 | 2021-07-04 00:00:00 | S_001532 | ASB 5661
 | 2021-07-05 00:00:00 | S_001532 | HRB 1545
 | 2021-07-06 00:00:00 | S_001532 | ASB 5984
 | 2021-07-09 00:00:00 | S_001532 | ASB 5983
 | 2021-07-10 00:00:00 | S_001532 | ASB 5989
 | 2021-07-11 00:00:00 | S_001532 | ASB 5983