Spreadsheet: 877758d1724658514-filter-by-first-8-digits-and-oldest-date-excelnewbie92-test2-14-365-aligw
Sheet: Sheet1

 | BR746241 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wanted Result
 |  | BR746241501402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2020-12-08 00:00:00 | 1 | 1 |  | BR745706401402 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2016-02-02 00:00:00 | 1 | 1
 |  | BR746241501402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2020-08-18 00:00:00 | 1 | 1 |  | BR745333401402 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2022-04-05 00:00:00 | 1 | 1
 |  | BR746241501402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2020-03-17 00:00:00 | 1 | 1 |  | [NAME] |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2021-04-06 00:00:00 | 1 | 1
 |  | BR745706401402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2019-12-17 00:00:00 | 1 | 1
 |  | BR746241501402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2019-12-17 00:00:00 | 1 | 1 |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2016-02-02 00:00:00 | 1 | 1
 |  | BR745706401402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2019-09-09 00:00:00 | 1 | 1 |  | [NAME] | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2021-04-06 00:00:00 | 1 | 1
 |  | BR746241501402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2019-09-09 00:00:00 | 1 | 1 |  | BR745333401402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2022-04-05 00:00:00 | 1 | 1
 |  | BR745706401402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2019-05-21 00:00:00 | 1 | 1
 |  | BR746241501402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2019-05-21 00:00:00 | 1 | 1
 |  | BR745706401402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2019-02-25 00:00:00 | 1 | 1 |  | 1. Get the minimum date for each serial number in column C:
 |  | BR745706401402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2018-10-29 00:00:00 | 1 | 1
 |  | BR745706401402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2018-07-18 00:00:00 | 1 | 1 |  | 2019-05-21 00:00:00
 |  | BR745706401402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2018-04-18 00:00:00 | 1 | 1 |  | 2019-05-21 00:00:00
 |  | BR745706401402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2018-01-09 00:00:00 | 1 | 1 |  | 2016-02-02 00:00:00
 |  | BR745706401402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2017-09-26 00:00:00 | 1 | 1 |  | 2019-05-21 00:00:00
 |  | BR745706401402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2017-04-04 00:00:00 | 1 | 1 |  | 2016-02-02 00:00:00
 |  | BR745706401402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2016-12-06 00:00:00 | 1 | 1 |  | 2019-05-21 00:00:00
 |  | BR745706401402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2016-08-09 00:00:00 | 1 | 1 |  | 2016-02-02 00:00:00
 |  | BR745706401402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2016-04-25 00:00:00 | 1 | 1 |  | 2019-05-21 00:00:00
 |  | BR745706401402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2016-02-02 00:00:00 | 1 | 1 |  | 2016-02-02 00:00:00
 |  | BR745333401402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2022-09-26 00:00:00 | 1 | 1 |  | 2016-02-02 00:00:00
 |  | BR745333401402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2022-04-05 00:00:00 | 1 | 1 |  | 2016-02-02 00:00:00
 |  | [NAME] | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2021-10-19 00:00:00 | 1 | 1 |  | 2016-02-02 00:00:00
 |  | [NAME] | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2021-04-06 00:00:00 | 1 | 1 |  | 2016-02-02 00:00:00
 |  | [NAME] | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2021-07-27 00:00:00 | 1 | 1 |  | 2016-02-02 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-02-02 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-02-02 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-02-02 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-02-02 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-02-02 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-04-05 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-04-05 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-04-06 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-04-06 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-04-06 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2. Create a range that includes the new minimum date column:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BR746241501402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2020-12-08 00:00:00 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019-05-21 00:00:00 | BR746241501402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2020-08-18 00:00:00 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019-05-21 00:00:00 | BR746241501402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2020-03-17 00:00:00 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-02-02 00:00:00 | BR745706401402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2019-12-17 00:00:00 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019-05-21 00:00:00 | BR746241501402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2019-12-17 00:00:00 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-02-02 00:00:00 | BR745706401402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2019-09-09 00:00:00 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019-05-21 00:00:00 | BR746241501402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2019-09-09 00:00:00 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-02-02 00:00:00 | BR745706401402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2019-05-21 00:00:00 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019-05-21 00:00:00 | BR746241501402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2019-05-21 00:00:00 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-02-02 00:00:00 | BR745706401402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2019-02-25 00:00:00 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-02-02 00:00:00 | BR745706401402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2018-10-29 00:00:00 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-02-02 00:00:00 | BR745706401402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2018-07-18 00:00:00 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-02-02 00:00:00 | BR745706401402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2018-04-18 00:00:00 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-02-02 00:00:00 | BR745706401402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2018-01-09 00:00:00 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-02-02 00:00:00 | BR745706401402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2017-09-26 00:00:00 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-02-02 00:00:00 | BR745706401402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2017-04-04 00:00:00 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-02-02 00:00:00 | BR745706401402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2016-12-06 00:00:00 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-02-02 00:00:00 | BR745706401402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2016-08-09 00:00:00 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-02-02 00:00:00 | BR745706401402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2016-04-25 00:00:00 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-02-02 00:00:00 | BR745706401402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2016-02-02 00:00:00 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-04-05 00:00:00 | BR745333401402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2022-09-26 00:00:00 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-04-05 00:00:00 | BR745333401402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2022-04-05 00:00:00 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-04-06 00:00:00 | [NAME] | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2021-10-19 00:00:00 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-04-06 00:00:00 | [NAME] | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2021-04-06 00:00:00 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-04-06 00:00:00 | [NAME] | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2021-07-27 00:00:00 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3. Filter the range to rows that don't contain the string in B1 on the left and are equal to the minimum date (LEN is used to determine how many characters are in this string, and then uses this to get that number of charcters from the left of the cells in column C):
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BR745706401402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2016-02-02 00:00:00 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-04-05 00:00:00 | BR745333401402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2022-04-05 00:00:00 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-04-06 00:00:00 | [NAME] | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2021-04-06 00:00:00 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4. Drop the minimum date column (no longer needed):
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2016-02-02 00:00:00 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BR745333401402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2022-04-05 00:00:00 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2021-04-06 00:00:00 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5. Finally, sort on the date column (column 11 of the array):
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 42402 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 44292 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BR745333401402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 44656 | 1 | 1