| Arbeitsblatt mit dem Namen 'Bestellhistorie' | |||
| A | B | C | |
| 1 | Medikament | Medikament | |
| 2 | Adenuric 80 mg | Accu Chek Aviva | |
| 3 | Amlodipin 1A Pharma 5 mg | ACCU-CHEK® FastClix Lanzetten | |
| 4 | Atorvastatin 1A Pharma 20 mg | Adenuric 80 mg | |
| 5 | Protaphane FlexPen | Amlodipin 1A Pharma 5 mg | |
| 6 | Ramipril 1A Pharma 5 mg | Atorvastatin 1A Pharma 20 mg | |
| 7 | SIOFOR 1000 mg | Carvedilol 1A Pharma 25 mg | |
| 8 | Voltaren Resinat 75 mg | Loratadin 1A Pharma 10 mg | |
| 9 | Protaphane FlexPen | Optifine 25x6 mm 6 mm | |
| 10 | SIOFOR 1000 mg | Pantoprazol 1A Pharma 20 mg | |
| 11 | Trulicity 1,5 mg | Protaphane FlexPen | |
| 12 | Accu Chek Aviva | Ramipril 1A Pharma 5 mg | |
| 13 | Adenuric 80 mg | SIOFOR 1000 mg | |
| 14 | Atorvastatin 1A Pharma 20 mg | TRESIBA 200 FlexTouch 3 ml | |
| 15 | Carvedilol 1A Pharma 25 mg | Trulicity 1,5 mg | |
| 16 | Optifine 25x6 mm 6 mm | Voltaren Resinat 75 mg | |
| 17 | Protaphane FlexPen | ||
| 18 | Amlodipin 1A Pharma 5 mg | ||
| 19 | Protaphane FlexPen | ||
| 20 | Ramipril 1A Pharma 5 mg | ||
| 21 | SIOFOR 1000 mg | ||
| 22 | Trulicity 1,5 mg | ||
| 23 | Accu Chek Aviva | ||
| 24 | Adenuric 80 mg | ||
| Zelle | Formel |
| C2 | =WENNFEHLER(INDEX(A:A;AGGREGAT(15;6;ZEILE(A$2:A$99)/(ZÄHLENWENN(A$2:A$99;"<="&A$2:A$99)=AGGREGAT(15;6;ZÄHLENWENN(A$2:A$99;"<="&A$2:A$99)/(A$2:A$99>0)/(ZÄHLENWENN(C$1:C1;A$2:A$99)=0);1))/(ZÄHLENWENN(C$1:C1;A$2:A$99)=0);1));"") |
| Verwendete Systemkomponenten: [Windows (32-bit) NT 6.02] MS Excel 2010 |
| Diese Tabelle wurde mit Tab2Html (v2.6.0) erstellt. ©Gerd alias Bamberg |