| | A | B | C | D | E | | 1 | aaaaa,bbbbbbb,cc,dddddddddd,e,fffffff,g,hhhhhh | aaaaa | bbbbbbb | cc | dddddddddd | | 2 | x,y,z | x | y | z | | | Formeln der Tabelle | B1 : =WENN(WECHSELN(","&$A1&",";",";"";SPALTE())=","&$A1&",";"";TEIL(","&$A1&",";FINDEN("~A~";WECHSELN(","&$A1&",";",";"~A~";SPALTE()-1))+1;FINDEN("~B~";WECHSELN(","&$A1&",";",";"~B~";SPALTE()))-FINDEN("~A~";WECHSELN(","&$A1&",";",";"~A~";SPALTE()-1))-1))
C1 : =WENN(WECHSELN(","&$A1&",";",";"";SPALTE())=","&$A1&",";"";TEIL(","&$A1&",";FINDEN("~A~";WECHSELN(","&$A1&",";",";"~A~";SPALTE()-1))+1;FINDEN("~B~";WECHSELN(","&$A1&",";",";"~B~";SPALTE()))-FINDEN("~A~";WECHSELN(","&$A1&",";",";"~A~";SPALTE()-1))-1))
D1 : =WENN(WECHSELN(","&$A1&",";",";"";SPALTE())=","&$A1&",";"";TEIL(","&$A1&",";FINDEN("~A~";WECHSELN(","&$A1&",";",";"~A~";SPALTE()-1))+1;FINDEN("~B~";WECHSELN(","&$A1&",";",";"~B~";SPALTE()))-FINDEN("~A~";WECHSELN(","&$A1&",";",";"~A~";SPALTE()-1))-1))
E1 : =WENN(WECHSELN(","&$A1&",";",";"";SPALTE())=","&$A1&",";"";TEIL(","&$A1&",";FINDEN("~A~";WECHSELN(","&$A1&",";",";"~A~";SPALTE()-1))+1;FINDEN("~B~";WECHSELN(","&$A1&",";",";"~B~";SPALTE()))-FINDEN("~A~";WECHSELN(","&$A1&",";",";"~A~";SPALTE()-1))-1))
B2 : =WENN(WECHSELN(","&$A2&",";",";"";SPALTE())=","&$A2&",";"";TEIL(","&$A2&",";FINDEN("~A~";WECHSELN(","&$A2&",";",";"~A~";SPALTE()-1))+1;FINDEN("~B~";WECHSELN(","&$A2&",";",";"~B~";SPALTE()))-FINDEN("~A~";WECHSELN(","&$A2&",";",";"~A~";SPALTE()-1))-1))
C2 : =WENN(WECHSELN(","&$A2&",";",";"";SPALTE())=","&$A2&",";"";TEIL(","&$A2&",";FINDEN("~A~";WECHSELN(","&$A2&",";",";"~A~";SPALTE()-1))+1;FINDEN("~B~";WECHSELN(","&$A2&",";",";"~B~";SPALTE()))-FINDEN("~A~";WECHSELN(","&$A2&",";",";"~A~";SPALTE()-1))-1))
D2 : =WENN(WECHSELN(","&$A2&",";",";"";SPALTE())=","&$A2&",";"";TEIL(","&$A2&",";FINDEN("~A~";WECHSELN(","&$A2&",";",";"~A~";SPALTE()-1))+1;FINDEN("~B~";WECHSELN(","&$A2&",";",";"~B~";SPALTE()))-FINDEN("~A~";WECHSELN(","&$A2&",";",";"~A~";SPALTE()-1))-1))
E2 : =WENN(WECHSELN(","&$A2&",";",";"";SPALTE())=","&$A2&",";"";TEIL(","&$A2&",";FINDEN("~A~";WECHSELN(","&$A2&",";",";"~A~";SPALTE()-1))+1;FINDEN("~B~";WECHSELN(","&$A2&",";",";"~B~";SPALTE()))-FINDEN("~A~";WECHSELN(","&$A2&",";",";"~A~";SPALTE()-1))-1))
|
|