Spreadsheet: 771211d1646514279-sort-filter-data-based-on-id-number-and-date-entered-closest-to-end-of-month-test_data_01
Sheet: Sheet1

Date | ID Number | Amount | Timestamp | last Date
2021-12-05 00:00:00 | 1222 | 900 | 2021-12-13 00:00:00
2021-12-12 00:00:00 | 122 | 42 | 2021-12-13 00:00:00
2021-12-12 00:00:00 | 5678 | 99 | 2022-01-16 00:00:00
2021-12-12 00:00:00 | 5678 | 108 | 2022-01-30 00:00:00
2021-12-12 00:00:00 | 5678 | 50 | 2022-02-02 00:00:00
2021-12-13 00:00:00 | 1234 | 63 | 2022-02-15 00:00:00
2021-12-14 00:00:00 | 67 | 525 | 2022-02-14 00:00:00
2021-12-14 00:00:00 | 67 | 584 | 2022-02-28 00:00:00
2021-12-21 00:00:00 | 67 | 777 | 2022-01-12 00:00:00
2021-12-28 00:00:00 | 1234 | 50 | 2022-12-28 00:00:00
2021-12-28 00:00:00 | 1234 | 25 | 2021-12-28 13:07:53
2022-01-22 00:00:00 | 1988 | 22 | 2022-01-22 00:00:00
2022-01-13 00:00:00 | 8749 | 13 | 2022-01-13 00:00:00
2022-01-28 00:00:00 | 8479 | 218 | 2022-01-28 00:00:00
2022-02-05 00:00:00 | 1988 | 5 | 2022-02-04 00:00:00
2022-02-18 00:00:00 | 1988 | 18 | 2022-02-18 00:00:00
2021-08-22 00:00:00 | 1 | 54321 | 2021-08-22 00:00:00
2022-02-02 00:00:00 | 101 | 12340 | 2022-02-02 00:00:00
2021-12-25 00:00:00 | 101 | 12340 | 2021-12-25 00:00:00
2021-11-26 00:00:00 | 101 | 12340 | 2021-11-26 00:00:00
2021-10-25 00:00:00 | 101 | 12340 | 2021-10-25 00:00:00
2021-09-26 00:00:00 | 101 | 12340 | 2021-09-26 00:00:00
2021-08-28 00:00:00 | 101 | 12340 | 2021-08-28 00:00:00
2021-07-26 00:00:00 | 101 | 12340 | 2021-07-26 00:00:00
2021-06-26 00:00:00 | 101 | 12340 | 2021-06-26 00:00:00
2021-05-27 00:00:00 | 101 | 12340 | 2021-05-27 00:00:00
2021-04-26 00:00:00 | 101 | 12340 | 2021-04-26 00:00:00
2021-03-26 00:00:00 | 101 | 12340 | 2021-03-26 00:00:00
2021-02-26 00:00:00 | 101 | 12340 | 2021-02-26 00:00:00
2021-01-25 00:00:00 | 101 | 12340 | 2021-01-25 00:00:00
2022-01-25 00:00:00 | 1135 | 59540 | 2022-01-25 00:00:00
2021-12-26 00:00:00 | 1135 | 58768 | 2021-12-26 00:00:00
2021-11-26 00:00:00 | 1135 | 58132 | 2021-11-26 00:00:00
2021-10-25 00:00:00 | 1135 | 57485 | 2021-10-25 00:00:00
2021-09-26 00:00:00 | 1135 | 56889 | 2021-09-26 00:00:00
2021-08-29 00:00:00 | 1135 | 56338 | 2021-08-29 00:00:00
2021-07-26 00:00:00 | 1135 | 557430 | 2021-07-26 00:00:00
2021-06-26 00:00:00 | 1135 | 55214 | 2021-06-26 00:00:00
2021-05-25 00:00:00 | 1135 | 54626 | 2021-05-25 00:00:00
2021-04-25 00:00:00 | 1135 | 541210 | 2021-04-25 00:00:00
2021-03-26 00:00:00 | 1135 | 53639 | 2021-03-26 00:00:00
2021-02-25 00:00:00 | 1135 | 53160 | 2021-02-25 00:00:00
2021-01-26 00:00:00 | 1135 | 52624 | 2021-01-26 00:00:00
2022-01-29 00:00:00 | 115 | 227520 | 2022-01-29 00:00:00
2022-01-01 00:00:00 | 115 | 226400 | 2022-01-01 00:00:00
2021-11-28 00:00:00 | 115 | 224010 | 2021-11-28 00:00:00
2021-10-28 00:00:00 | 115 | 221520 | 2021-10-28 00:00:00
2021-10-02 00:00:00 | 115 | 220240 | 2021-10-02 00:00:00
2021-08-31 00:00:00 | 115 | 219850 | 2021-08-31 00:00:00
2021-07-26 00:00:00 | 115 | 21746 | 2021-07-26 00:00:00
2021-07-02 00:00:00 | 115 | 215960 | 2021-07-02 00:00:00
2021-06-02 00:00:00 | 115 | 213710 | 2021-06-02 00:00:00
2021-04-26 00:00:00 | 115 | 211400 | 2021-04-26 00:00:00
2021-03-27 00:00:00 | 115 | 209420 | 2021-03-27 00:00:00
2021-02-26 00:00:00 | 115 | 208560 | 2021-02-26 00:00:00
2021-01-25 00:00:00 | 115 | 206770 | 2021-01-25 00:00:00
2022-02-06 00:00:00 | 115 | 55130 | 2022-02-06 00:00:00
2021-12-29 00:00:00 | 115 | 51870 | 2021-12-29 00:00:00
2021-09-05 00:00:00 | 115 | 40360 | 2021-09-05 00:00:00
2021-08-01 00:00:00 | 115 | 36610 | 2021-08-01 00:00:00
2021-06-06 00:00:00 | 115 | 31140 | 2021-06-06 00:00:00
2021-04-26 00:00:00 | 115 | 30480 | 2021-04-26 00:00:00
2021-03-02 00:00:00 | 115 | 29860 | 2021-03-02 00:00:00
2021-02-02 00:00:00 | 115 | 29790 | 2021-02-02 00:00:00
2022-01-28 00:00:00 | 115 | 30210 | 2022-01-28 00:00:00
2021-12-31 00:00:00 | 115 | 29917 | 2021-12-31 00:00:00
2021-12-03 00:00:00 | 115 | 29751 | 2021-12-03 00:00:00
2021-11-02 00:00:00 | 115 | 29422 | 2021-11-02 00:00:00
2021-10-05 00:00:00 | 115 | 29020 | 2021-10-05 00:00:00
2021-08-25 00:00:00 | 115 | 28582 | 2021-08-25 00:00:00
 | 1503 | 28369 | 2021-07-27 00:00:00
2021-07-05 00:00:00 | 1503 | 28115 | 2021-07-05 00:00:00
2021-06-02 00:00:00 | 1503 | 27825 | 2021-06-02 00:00:00
2021-05-01 00:00:00 | 1503 | 27440 | 2021-05-01 00:00:00
2021-04-06 00:00:00 | 1636 | 27166 | 2021-04-06 00:00:00
2021-03-01 00:00:00 | 1636 | 26815 | 2021-03-01 00:00:00
2021-01-28 00:00:00 | 9866 | 26440 | 2021-01-28 00:00:00
2021-09-27 00:00:00 | 9821 | 487 | 2021-09-27 00:00:00