Zelle | Formel |
C2 | =WENN(A2<>"";TEXTVERKETTEN(";";;B2:INDEX(B:B;ZEILE(B2)+VERGLEICH(WAHR;INDEX(A3:A$9998<>A4:A$9999;);)));"") |
D2 | =WENN(A2<>"";TEXTVERKETTEN(";";;B2:INDEX(B:B;ZEILE(B1)+VERGLEICH(WAHR;INDEX(A3:A$9999<>"";);)));"") |
E2 | =B2&WENN((A3="")*(B3>0); ",";"")&WENN(A3>0;"";C3) |
C3 | =WENN(A3<>"";TEXTVERKETTEN(";";;B3:INDEX(B:B;ZEILE(B3)+VERGLEICH(WAHR;INDEX(A4:A$9998<>A5:A$9999;);)));"") |
D3 | =WENN(A3<>"";TEXTVERKETTEN(";";;B3:INDEX(B:B;ZEILE(B2)+VERGLEICH(WAHR;INDEX(A4:A$9999<>"";);)));"") |
E3 | =B3&WENN((A4="")*(B4>0); ",";"")&WENN(A4>0;"";C4) |
C4 | =WENN(A4<>"";TEXTVERKETTEN(";";;B4:INDEX(B:B;ZEILE(B4)+VERGLEICH(WAHR;INDEX(A5:A$9998<>A6:A$9999;);)));"") |
D4 | =WENN(A4<>"";TEXTVERKETTEN(";";;B4:INDEX(B:B;ZEILE(B3)+VERGLEICH(WAHR;INDEX(A5:A$9999<>"";);)));"") |
E4 | =B4&WENN((A5="")*(B5>0); ",";"")&WENN(A5>0;"";C5) |
C5 | =WENN(A5<>"";TEXTVERKETTEN(";";;B5:INDEX(B:B;ZEILE(B5)+VERGLEICH(WAHR;INDEX(A6:A$9998<>A7:A$9999;);)));"") |
D5 | =WENN(A5<>"";TEXTVERKETTEN(";";;B5:INDEX(B:B;ZEILE(B4)+VERGLEICH(WAHR;INDEX(A6:A$9999<>"";);)));"") |
E5 | =B5&WENN((A6="")*(B6>0); ",";"")&WENN(A6>0;"";C6) |
C6 | =WENN(A6<>"";TEXTVERKETTEN(";";;B6:INDEX(B:B;ZEILE(B6)+VERGLEICH(WAHR;INDEX(A7:A$9998<>A8:A$9999;);)));"") |
D6 | =WENN(A6<>"";TEXTVERKETTEN(";";;B6:INDEX(B:B;ZEILE(B5)+VERGLEICH(WAHR;INDEX(A7:A$9999<>"";);)));"") |
E6 | =B6&WENN((A7="")*(B7>0); ",";"")&WENN(A7>0;"";C7) |
C7 | =WENN(A7<>"";TEXTVERKETTEN(";";;B7:INDEX(B:B;ZEILE(B7)+VERGLEICH(WAHR;INDEX(A8:A$9998<>A9:A$9999;);)));"") |
D7 | =WENN(A7<>"";TEXTVERKETTEN(";";;B7:INDEX(B:B;ZEILE(B6)+VERGLEICH(WAHR;INDEX(A8:A$9999<>"";);)));"") |
E7 | =B7&WENN((A8="")*(B8>0); ",";"")&WENN(A8>0;"";C8) |
C8 | =WENN(A8<>"";TEXTVERKETTEN(";";;B8:INDEX(B:B;ZEILE(B8)+VERGLEICH(WAHR;INDEX(A9:A$9998<>A10:A$9999;);)));"") |
D8 | =WENN(A8<>"";TEXTVERKETTEN(";";;B8:INDEX(B:B;ZEILE(B7)+VERGLEICH(WAHR;INDEX(A9:A$9999<>"";);)));"") |
E8 | =B8&WENN((A9="")*(B9>0); ",";"")&WENN(A9>0;"";C9) |
C9 | =WENN(A9<>"";TEXTVERKETTEN(";";;B9:INDEX(B:B;ZEILE(B9)+VERGLEICH(WAHR;INDEX(A10:A$9998<>A11:A$9999;);)));"") |
D9 | =WENN(A9<>"";TEXTVERKETTEN(";";;B9:INDEX(B:B;ZEILE(B8)+VERGLEICH(WAHR;INDEX(A10:A$9999<>"";);)));"") |
E9 | =B9&WENN((A10="")*(B10>0); ",";"")&WENN(A10>0;"";C10) |
C10 | =WENN(A10<>"";TEXTVERKETTEN(";";;B10:INDEX(B:B;ZEILE(B10)+VERGLEICH(WAHR;INDEX(A11:A$9998<>A12:A$9999;);)));"") |
D10 | =WENN(A10<>"";TEXTVERKETTEN(";";;B10:INDEX(B:B;ZEILE(B9)+VERGLEICH(WAHR;INDEX(A11:A$9999<>"";);)));"") |
E10 | =B10&WENN((A11="")*(B11>0); ",";"")&WENN(A11>0;"";C11) |
C11 | =WENN(A11<>"";TEXTVERKETTEN(";";;B11:INDEX(B:B;ZEILE(B11)+VERGLEICH(WAHR;INDEX(A12:A$9998<>A13:A$9999;);)));"") |
D11 | =WENN(A11<>"";TEXTVERKETTEN(";";;B11:INDEX(B:B;ZEILE(B10)+VERGLEICH(WAHR;INDEX(A12:A$9999<>"";);)));"") |
E11 | =B11&WENN((A12="")*(B12>0); ",";"")&WENN(A12>0;"";C12) |
C12 | =WENN(A12<>"";TEXTVERKETTEN(";";;B12:INDEX(B:B;ZEILE(B12)+VERGLEICH(WAHR;INDEX(A13:A$9998<>A14:A$9999;);)));"") |
D12 | =WENN(A12<>"";TEXTVERKETTEN(";";;B12:INDEX(B:B;ZEILE(B11)+VERGLEICH(WAHR;INDEX(A13:A$9999<>"";);)));"") |
E12 | =B12&WENN((A13="")*(B13>0); ",";"")&WENN(A13>0;"";C13) |