Spreadsheet: 695255d1600109689-how-to-find-latest-date-using-max-formula-matching-p-n-and-partial-text-find-latest-date-using-index-match-and-partial-word
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 | 10/31/2022 | 0010-4-00 | Apple
Autonomous Mobility and Safety (AMS) | Hydraulic Brake Systems (HBS) | North/Middle America | 09/03/2024 | 0029-4-00 | Apple
Autonomous Mobility and Safety (AMS) | Hydraulic Brake Systems (HBS) | North/Middle America | 09/30/2025 | 0030-4-00 | Apple
Autonomous Mobility and Safety (AMS) | Hydraulic Brake Systems (HBS) | North/Middle America | 09/30/2025 | 0039-4-97 | Apple
Autonomous Mobility and Safety (AMS) | Hydraulic Brake Systems (HBS) | North/Middle America | 12/31/2025 | 0040-4-97 | Orange
Autonomous Mobility and Safety (AMS) | Hydraulic Brake Systems (HBS) | North/Middle America | 12/31/2025 | 0041-4-00 | Orange
Autonomous Mobility and Safety (AMS) | Hydraulic Brake Systems (HBS) | North/Middle America | 12/31/2026 | 0042-4-00 | Apple
Autonomous Mobility and Safety (AMS) | Hydraulic Brake Systems (HBS) | North/Middle America | 12/31/2026 | 0039-4-00 | Apple
Autonomous Mobility and Safety (AMS) | Hydraulic Brake Systems (HBS) | North/Middle America | 12/31/2026 | 0040-4-00 | Orange
Autonomous Mobility and Safety (AMS) | Hydraulic Brake Systems (HBS) | North/Middle America | 12/31/2026 | 5789-3-00 | Orange
Autonomous Mobility and Safety (AMS) | Hydraulic Brake Systems (HBS) | North/Middle America | 12/31/2026 | 5790-3-00 | Apple
Autonomous Mobility and Safety (AMS) | Hydraulic Brake Systems (HBS) | North/Middle America | 04/30/2027 | 4827-3-00 | Orange
Autonomous Mobility and Safety (AMS) | Hydraulic Brake Systems (HBS) | North/Middle America | 08/31/2026 | 4828-3-00 | Apple
Autonomous Mobility and Safety (AMS) | Hydraulic Brake Systems (HBS) | North/Middle America | 01/31/2023 | 5789-3-97 | Orange
Autonomous Mobility and Safety (AMS) | Hydraulic Brake Systems (HBS) | North/Middle America | 01/31/2023 | 5790-3-97 | Apple
Autonomous Mobility and Safety (AMS) | Hydraulic Brake Systems (HBS) | North/Middle America | 12/31/2020 | 5325-4-00 | Apple
Autonomous Mobility and Safety (AMS) | Hydraulic Brake Systems (HBS) | North/Middle America | 12/31/2020 | 5325-5-00 | Orange
Autonomous Mobility and Safety (AMS) | Hydraulic Brake Systems (HBS) | North/Middle America | 12/31/2020 | 5325-5-00 | Orange
Autonomous Mobility and Safety (AMS) | Hydraulic Brake Systems (HBS) | North/Middle America | 06/30/2022 | 5775-3-00 | Orange
Autonomous Mobility and Safety (AMS) | Hydraulic Brake Systems (HBS) | North/Middle America | 12/31/2020 | 5775-3-00 | Apple
Autonomous Mobility and Safety (AMS) | Hydraulic Brake Systems (HBS) | North/Middle America | 12/31/2020 | 5707-3-00 | Orange
Autonomous Mobility and Safety (AMS) | Hydraulic Brake Systems (HBS) | North/Middle America | 12/31/2020 | 5708-3-00 | Apple
 |  |  | 12/31/2022 | 0039-4-00 | Apple
 |  |  | 12/31/2023 | 0029-4-00 | Apple
 |  |  | 12/31/2023 | 5775-3-00 | Apple
 |  |  | 09/30/2024 | 5325-4-00 | Apple
 |  |  | 09/30/2024 | 0039-4-97 | Apple