Spreadsheet: 695262d1600114139-how-to-find-latest-date-using-max-formula-matching-p-n-and-partial-text-find-latest-date-using-index-match-and-partial-word-aggregate
Sheet: Sample Data

Business Area | Business Unit | Region (Sales Pl.) | EOP Line item | Number | Product
Autonomous Mobility and Safety (AMS) | Hydraulic Brake Systems (HBS) | North/Middle America | 2022-10-31 00:00:00 | 0010-4-00 | Apple
Autonomous Mobility and Safety (AMS) | Hydraulic Brake Systems (HBS) | North/Middle America | 2024-09-03 00:00:00 | 0029-4-00 | Apple
Autonomous Mobility and Safety (AMS) | Hydraulic Brake Systems (HBS) | North/Middle America | 2025-09-30 00:00:00 | 0030-4-00 | Apple
Autonomous Mobility and Safety (AMS) | Hydraulic Brake Systems (HBS) | North/Middle America | 2025-09-30 00:00:00 | 0039-4-97 | Apple
Autonomous Mobility and Safety (AMS) | Hydraulic Brake Systems (HBS) | North/Middle America | 2025-12-31 00:00:00 | 0040-4-97 | Orange
Autonomous Mobility and Safety (AMS) | Hydraulic Brake Systems (HBS) | North/Middle America | 2025-12-31 00:00:00 | 0041-4-00 | Orange
Autonomous Mobility and Safety (AMS) | Hydraulic Brake Systems (HBS) | North/Middle America | 2026-12-31 00:00:00 | 0042-4-00 | Apple
Autonomous Mobility and Safety (AMS) | Hydraulic Brake Systems (HBS) | North/Middle America | 2026-12-31 00:00:00 | 0039-4-00 | Apple
Autonomous Mobility and Safety (AMS) | Hydraulic Brake Systems (HBS) | North/Middle America | 2026-12-31 00:00:00 | 0040-4-00 | Orange
Autonomous Mobility and Safety (AMS) | Hydraulic Brake Systems (HBS) | North/Middle America | 2026-12-31 00:00:00 | 5789-3-00 | Orange
Autonomous Mobility and Safety (AMS) | Hydraulic Brake Systems (HBS) | North/Middle America | 2026-12-31 00:00:00 | 5790-3-00 | Apple
Autonomous Mobility and Safety (AMS) | Hydraulic Brake Systems (HBS) | North/Middle America | 2027-04-30 00:00:00 | 4827-3-00 | Orange
Autonomous Mobility and Safety (AMS) | Hydraulic Brake Systems (HBS) | North/Middle America | 2026-08-31 00:00:00 | 4828-3-00 | Apple
Autonomous Mobility and Safety (AMS) | Hydraulic Brake Systems (HBS) | North/Middle America | 2023-01-31 00:00:00 | 5789-3-97 | Orange
Autonomous Mobility and Safety (AMS) | Hydraulic Brake Systems (HBS) | North/Middle America | 2023-01-31 00:00:00 | 5790-3-97 | Apple
Autonomous Mobility and Safety (AMS) | Hydraulic Brake Systems (HBS) | North/Middle America | 2020-12-31 00:00:00 | 5325-4-00 | Apple
Autonomous Mobility and Safety (AMS) | Hydraulic Brake Systems (HBS) | North/Middle America | 2020-12-31 00:00:00 | 5325-5-00 | Orange
Autonomous Mobility and Safety (AMS) | Hydraulic Brake Systems (HBS) | North/Middle America | 2020-12-31 00:00:00 | 5325-5-00 | Orange
Autonomous Mobility and Safety (AMS) | Hydraulic Brake Systems (HBS) | North/Middle America | 2022-06-30 00:00:00 | 5775-3-00 | Orange
Autonomous Mobility and Safety (AMS) | Hydraulic Brake Systems (HBS) | North/Middle America | 2020-12-31 00:00:00 | 5775-3-00 | Apple
Autonomous Mobility and Safety (AMS) | Hydraulic Brake Systems (HBS) | North/Middle America | 2020-12-31 00:00:00 | 5707-3-00 | Orange
Autonomous Mobility and Safety (AMS) | Hydraulic Brake Systems (HBS) | North/Middle America | 2020-12-31 00:00:00 | 5708-3-00 | Apple
 |  |  | 2022-12-31 00:00:00 | 0039-4-00 | Apple
 |  |  | 2023-12-31 00:00:00 | 0029-4-00 | Apple
 |  |  | 2023-12-31 00:00:00 | 5775-3-00 | Apple
 |  |  | 2024-09-30 00:00:00 | 5325-4-00 | Apple
 |  |  | 2024-09-30 00:00:00 | 0039-4-97 | Apple