Spreadsheet: 752450d1634758131-check-if-multiple-criteria-are-met-in-lines-above-list-check-if-criteria-are-fulfilled-in-lines-above
Sheet: PBH&PBE Angebote

Gesellschaft | Angebotspartner | Kundensegment | Pool | Marktgebiet | Beschaffungsart | IAM Status | Angebotsstatus | Status Datum | [NAME] | Lieferende | Angebotslaufzeit ab | Angebotslaufzeit bis | IAM-Vertrag | Angebots ID | Bepreisungs ID | Kalkulations ID | Summenprofil | Summe kWh | Summe GWh | Angebots-kalkulation
 | Client A | BM |  | DE | B2B | 02 | Menge beschafft | 26.01.2021 |  |  | 01.02.2021 | 31.12.2021 | 004211 | [PHONE] | 01022324 | [PHONE] | 110918130 | 369546
 | Client A | BM |  | DE | B2B | 03 | abgelehnt | 16.10.2020 |  |  | 01.01.2021 | 31.12.2021 | 004211 | [PHONE] | 01018087 | [PHONE] | 110913758 | 522942
 | Client A | BM |  | DE | B2B | 03 | abgelehnt | 28.10.2020 |  |  | 01.01.2021 | 31.12.2021 | 004211 | [PHONE] | 01018122 | [PHONE] | 110913785 | 444500
 | Client A | BM |  | DE | B2B | 03 | abgelehnt | 02.11.2020 |  |  | 01.01.2021 | 31.12.2021 | 004211 | [PHONE] | 01018688 | [PHONE] | 110914357 | 392206
 | Client A | BM |  | DE | B2B | 03 | abgelehnt | 02.11.2020 |  |  | 01.01.2021 | 31.12.2021 | 004211 | [PHONE] | 01018885 | [PHONE] | 110914569 | 418353
 | Client A | BM |  | DE | B2B | 03 | abgelehnt | 02.11.2020 |  |  | 01.01.2022 | 31.12.2022 | 004211 | [PHONE] | 01018886 | [PHONE] | 110914570 | 418826
 | Client A | BM |  | DE | B2B | 03 | abgelehnt | 11.01.2021 |  |  | 01.01.2021 | 31.12.2021 | 004211 | [PHONE] | 01018885 | [PHONE] | 110914569 | 418353
 | Client A | BM |  | DE | B2B | 03 | abgelehnt | 11.01.2021 |  |  | 01.01.2021 | 31.12.2021 | 004211 | [PHONE] | 01021846 | [PHONE] | 110917584 | 418353
 | Client A | BM |  | DE | B2B | 03 | abgelehnt | 11.01.2021 |  |  | 01.01.2022 | 31.12.2022 | 004211 | [PHONE] | 01018886 | [PHONE] | 110914570 | 418826
 | Client A | BM |  | DE | B2B | 03 | abgelehnt | 18.01.2021 |  |  | 01.02.2021 | 31.12.2021 | 004211 | [PHONE] | 01021925 | [PHONE] | 110917722 | 369081
 | Client A | BM |  | DE | B2B | 03 | abgelehnt | 25.01.2021 |  |  | 01.02.2021 | 31.12.2021 | 004211 | [PHONE] | 01022207 | [PHONE] | 110918010 | 335951
 | Client A | BM |  | DE | B2B | 03 | abgelehnt | 25.01.2021 |  |  | 01.03.2021 | 31.12.2021 | 004211 | [PHONE] | 01022294 | [PHONE] | 110918106 | 287387
 | Client A | BM |  | DE | B2B | 03 | abgelehnt | 26.01.2021 |  |  | 01.02.2021 | 31.12.2021 | 004211 | [PHONE] | 01022322 | [PHONE] | 110918123 | 369546
 | Client A | BM |  | DE | B2B | 03 | abgelehnt | 26.01.2021 |  |  | 01.02.2021 | 31.12.2021 | 004211 | [PHONE] | 01022322 | [PHONE] | 110918123 | 369546
 | Client A | BM |  | DE | B2B | 03 | abgelehnt | 14.09.2021 |  |  | 01.01.2022 | 31.12.2022 | 005949 | [PHONE] | 01030205 | [PHONE] | 110925177 | 322068
 | Client A | BM |  | DE | B2B | 03 | abgelehnt | 14.09.2021 |  |  | 01.01.2022 | 31.12.2024 | 005948 | [PHONE] | 01030201 | [PHONE] | 110925172 | 984943
 | Client B | BM |  | AT | B2B | 03 | abgelehnt | 27.09.2021 |  |  | 01.01.2022 | 31.12.2022 | 006101 | [PHONE] | 01031277 | [PHONE] | 110926113 | 762137
 | Client B | BM |  | AT | B2B | 03 | abgelehnt | 27.09.2021 |  |  | 01.01.2022 | 31.12.2022 | 006101 | [PHONE] | 01031277 | [PHONE] | 110926113 | 762137
 | Client B | BM |  | AT | B2B | 03 | abgelehnt | 27.09.2021 |  |  | 01.01.2022 | 31.12.2024 | 006101 | [PHONE] | 01031290 | [PHONE] | 110926119 | 2303408
 | Client B | BM |  | AT | B2B | 03 | abgelehnt | 27.09.2021 |  |  | 01.01.2023 | 31.12.2023 | 006101 | [PHONE] | 01031278 | [PHONE] | 110926115 | 762715
 | Client B | BM |  | AT | B2B | 03 | abgelehnt | 27.09.2021 |  |  | 01.01.2023 | 31.12.2023 | 006101 | [PHONE] | 01031278 | [PHONE] | 110926115 | 762715
 | Client B | BM |  | AT | B2B | 03 | abgelehnt | 27.09.2021 |  |  | 01.01.2024 | 31.12.2024 | 006101 | [PHONE] | 01031279 | [PHONE] | 110926117 | 778556
 | Client B | BM |  | AT | B2B | 03 | abgelehnt | 27.09.2021 |  |  | 01.01.2024 | 31.12.2024 | 006101 | [PHONE] | 01031279 | [PHONE] | 110926117 | 778556
 | Client B | BM |  | DE | B2B | 03 | abgelehnt | 26.07.2021 |  |  | 15.07.2021 | 31.12.2021 | 005503 | [PHONE] | 01026892 | [PHONE] | 110922292 | 355560
 | Client B | BM |  | DE | B2B | 03 | abgelehnt | 27.09.2021 |  |  | 01.01.2022 | 31.12.2022 | 006101 | [PHONE] | 01031358 | [PHONE] | 110926188 | 762137
 | Client B | BM |  | DE | B2B | 03 | abgelehnt | 27.09.2021 |  |  | 01.01.2022 | 31.12.2024 | 006101 | [PHONE] | 01031371 | [PHONE] | 110926191 | 2303408
 | Client B | BM |  | DE | B2B | 03 | abgelehnt | 27.09.2021 |  |  | 01.01.2023 | 31.12.2023 | 006101 | [PHONE] | 01031359 | [PHONE] | 110926189 | 762715
 | Client B | BM |  | DE | B2B | 03 | abgelehnt | 27.09.2021 |  |  | 01.01.2024 | 31.12.2024 | 006101 | [PHONE] | 01031370 | [PHONE] | 110926190 | 778556
 | Client C | BX |  | AT | B2B | 02 | Menge beschafft | 02.12.2020 |  |  | 01.01.2021 | 31.12.2021 | 004038 | [PHONE] | 01020837 | [PHONE] | 110916554 | 1354500
 | Client C | BX |  | AT | B2B | 03 | abgelehnt | 02.12.2020 |  |  | 01.01.2021 | 31.12.2021 | 004038 | [PHONE] | 01016647 | [PHONE] | 110912297 | 1354500
 | Client C | BX |  | AT | B2B | 03 | abgelehnt | 02.12.2020 |  |  | 01.01.2021 | 31.12.2021 | 004038 | [PHONE] | 01019571 | [PHONE] | 110915263 | 1354500
 | Client C | BX |  | AT | B2B | 03 | abgelehnt | 02.12.2020 |  |  | 01.01.2021 | 31.12.2021 | 004038 | [PHONE] | 01020502 | [PHONE] | 110916199 | 1354500
 | Client C | BX |  | AT | B2B | 03 | abgelehnt | 02.12.2020 |  |  | 01.01.2022 | 31.12.2022 | 004038 | [PHONE] | 01020503 | [PHONE] | 110916200 | 1347560
 | Client D | BM |  | AT | B2B | 02 | Menge beschafft | 18.03.2021 |  |  | 01.04.2021 | 31.12.2021 | 004888 | [PHONE] | 01023492 | [PHONE] | 110919335 | 152158
 | Client D | BM |  | AT | B2B | 02 | Menge beschafft | 20.09.2021 |  |  | 01.01.2022 | 31.12.2022 | 005978 | [PHONE] | 01030522 | [PHONE] | 110925454 | 209214 |  |  | => Should show "NO" because Criteria are already fulfilled by line above i.e. in line 35 it says already "Client D" in column Angebotspartner and "Menge beschafft" or "angenommen / Menge OFFEN" in column Angebotsstatus
 | Client D | BM |  | AT | B2B | 02 | Menge beschafft | 20.09.2021 |  |  | 01.01.2023 | 31.12.2023 | 005978 | [PHONE] | 01030523 | [PHONE] | 110925455 | 208483
 | Client D | BM |  | AT | B2B | 02 | Menge beschafft | 20.09.2021 |  |  | 01.01.2024 | 31.12.2024 | 005978 | [PHONE] | 01030524 | [PHONE] | 110925456 | 212742