{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Tabelle1","Tabelle2","Tabelle3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Tabelle1","index":0,"n_rows":27,"n_cols":9,"rows_kept":27,"cut":false,"hidden":false,"merged":[[14,0,14,4],[4,1,4,9]]}
[]
["Anzeige","Trefferanzahl","Nachname","Vorname","Geburtsdatum","Straße","Hausnummer","Postleitzahl","Stadt"]
[1,{"$f":"A27","v":3},{"$f":"VLOOKUP(A3,A19:B24,2,FALSE)","v":"Schulze"},{"$f":"VLOOKUP(A3,A19:C24,3,FALSE)","v":"Anton"},{"$f":"VLOOKUP(A3,A19:D24,4,FALSE)","v":"1950-12-29"},{"$f":"VLOOKUP(A3,A19:E24,5,FALSE)","v":"Zimtsteig"},{"$f":"VLOOKUP(A3,A19:F24,6,FALSE)","v":15},{"$f":"VLOOKUP(A3,A19:G24,7,FALSE)","v":23456},{"$f":"VLOOKUP(A3,A19:H24,8,FALSE)","v":"Köln"}]
[]
[null,"Sie betätigen lediglich die Schalttasten links oder geben in A3 eine Zahl unterhalb oder gleich der Trefferanzahl ein!!!"]
[]
[]
[null,null,null,null,null,null,"Hilfstabelle"]
[null,null,null,null,null,null,"Nachname",{"$f":"IF($A$13=G9,\"B\",0)","v":"B"}]
[null,null,null,null,null,null,"Vorname",{"$f":"IF($A$13=G10,\"C\",0)","v":0}]
[null,null,null,null,null,null,"Geburtsdatum",{"$f":"IF($A$13=G11,\"D\",0)","v":0}]
["Kriterium","Suche",null,null,null,null,"Straße",{"$f":"IF($A$13=G12,\"E\",0)","v":0}]
["Nachname","Schulze",null,null,null,null,"Hausnummer",{"$f":"IF($A$13=G13,\"F\",0)","v":0}]
[null,null,null,null,null,null,"Postleitzahl",{"$f":"IF($A$13=G14,\"G\",0)","v":0}]
["Suchkriterium in A13 und Suchbegriff in B13 müssen Sie eingeben!!!",null,null,null,null,null,"Stadt",{"$f":"IF($A$13=G15,\"H\",0)","v":0}]
[null,null,null,null,null,null,"Matrix",{"$f":"VLOOKUP(A13,G9:H15,2,FALSE)","v":"B"}]
[]
[null,"Nachname","Vorname","Geburtsdatum","Straße","Hausnummer","Postleitzahl","Stadt"]
[{"$f":"IF(INDIRECT($H$16 &I19)=$B$13,COUNTIF(INDIRECT($H$16 & 19): INDIRECT($H$16 & I19),$B$13),0)","v":0},"Mayer","Thomas","1970-06-25","Gartenstr. ",4,13349,"Berlin",19]
[{"$f":"IF(INDIRECT($H$16 &I20)=$B$13,COUNTIF(INDIRECT($H$16 & 19): INDIRECT($H$16 & I20),$B$13),0)","v":1},"Schulze","Anton","1950-12-29","Zimtsteig",15,23456,"Köln",20]
[{"$f":"IF(INDIRECT($H$16 &I21)=$B$13,COUNTIF(INDIRECT($H$16 & 19): INDIRECT($H$16 & I21),$B$13),0)","v":0},"Barsch","Bernd","1980-08-05","Gartenstr. ",23,13349,"Berlin",21]
[{"$f":"IF(INDIRECT($H$16 &I22)=$B$13,COUNTIF(INDIRECT($H$16 & 19): INDIRECT($H$16 & I22),$B$13),0)","v":2},"Schulze","Victor","1975-09-03","Kleine Straße",34,23456,"Köln",22]
[{"$f":"IF(INDIRECT($H$16 &I23)=$B$13,COUNTIF(INDIRECT($H$16 & 19): INDIRECT($H$16 & I23),$B$13),0)","v":0},"Mayer","Bernd","2008-06-04","Opernstr.",65,13349,"Berlin",23]
[{"$f":"IF(INDIRECT($H$16 &I24)=$B$13,COUNTIF(INDIRECT($H$16 & 19): INDIRECT($H$16 & I24),$B$13),0)","v":3},"Schulze","Anton","1930-08-15","Gartenstr. ",3,13349,"Berlin",24]
[]
[]
[{"$f":"MAX(A19:A24)","v":3},"Treffer insgesamt"]

{"sheet":"Tabelle2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Tabelle3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}