{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Hoja1","Hoja2","Hoja3","RESUMEN","BASE DE DATOS"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"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":"Hoja1","index":0,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
["PSC","LBRO","HOJA","Nº"]
["PSC","LBRO","HOJA","Nº"]
[]
[1,"LUIS","CASA",5]
[1,"LUIS","PISO",6]
[1,"PEDRO","CASA",5]
[1,"JUAN","CASA",8]
[1,"LUIS","CASA",9]
[1,"ANTONIO","CASA",1]
[1,"LUIS","PATIO",3]

{"sheet":"Hoja2","index":1,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
["PSC","LBRO","HOJA","Nº"]
["PSC","LBRO","HOJA","Nº"]
[]
[2,"LUIS","CASA",5]
[2,"LUIS","PISO",6]
[2,"PEDRO","CASA",7]
[2,"LUIS","CASA",9]
[2,"PEDRO","CASA",5]
[2,"LUIS","PATIO",11]

{"sheet":"Hoja3","index":2,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
["PSC","LBRO","HOJA","Nº"]
["PSC","LBRO","HOJA","Nº"]
[]
[3,"LUIS","PISO",6]
[3,"PEDRO","CASA",7]
[3,"JUAN","CASA",8]
[3,"PEDRO","CASA",5]
[3,"LUIS","PATIO",11]

{"sheet":"RESUMEN","index":3,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["HOJA3","HOJA3","HOJA3","HOJA3"]
["PSC","LBRO","HOJA","Nº","COINCIAS"]
[{"$f":"COUNTIF(A4:A12,\">0\")","v":5},{"$f":"COUNTIF(B4:B12,\"*\")","v":5},{"$f":"COUNTIF(C4:C12,\"*\")","v":5},{"$f":"COUNTIF(D4:D12,\">0\")","v":5}]
[{"$f":"INDEX('BASE DE DATOS'!$A$4:$A$98,MATCH(Hoja3!B6&Hoja3!C6&Hoja3!D6,'BASE DE DATOS'!$B$4:$B$98&'BASE DE DATOS'!$C$4:$C$98&'BASE DE DATOS'!$D$4:$D$98,0))","v":1},{"$f":"INDEX('BASE DE DATOS'!$B$4:$B$98,MATCH(Hoja3!B6&Hoja3!C6&Hoja3!D6,'BASE DE DATOS'!$B$4:$B$98&'BASE DE DATOS'!$C$4:$C$98&'BASE DE DATOS'!$D$4:$D$98,0))","v":"LUIS"},{"$f":"INDEX('BASE DE DATOS'!$C$4:$C$98,MATCH(Hoja3!B6&Hoja3!C6&Hoja3!D6,'BASE DE DATOS'!$B$4:$B$98&'BASE DE DATOS'!$C$4:$C$98&'BASE DE DATOS'!$D$4:$D$98,0))","v":"PISO"},{"$f":"INDEX('BASE DE DATOS'!$D$4:$D$98,MATCH(Hoja3!B6&Hoja3!C6&Hoja3!D6,'BASE DE DATOS'!$B$4:$B$98&'BASE DE DATOS'!$C$4:$C$98&'BASE DE DATOS'!$D$4:$D$98,0))","v":6}]
[{"$f":"INDEX('BASE DE DATOS'!$A$4:$A$98,MATCH(Hoja3!B7&Hoja3!C7&Hoja3!D7,'BASE DE DATOS'!$B$4:$B$98&'BASE DE DATOS'!$C$4:$C$98&'BASE DE DATOS'!$D$4:$D$98,0))","v":2},{"$f":"INDEX('BASE DE DATOS'!$B$4:$B$98,MATCH(Hoja3!B7&Hoja3!C7&Hoja3!D7,'BASE DE DATOS'!$B$4:$B$98&'BASE DE DATOS'!$C$4:$C$98&'BASE DE DATOS'!$D$4:$D$98,0))","v":"PEDRO"},{"$f":"INDEX('BASE DE DATOS'!$C$4:$C$98,MATCH(Hoja3!B7&Hoja3!C7&Hoja3!D7,'BASE DE DATOS'!$B$4:$B$98&'BASE DE DATOS'!$C$4:$C$98&'BASE DE DATOS'!$D$4:$D$98,0))","v":"CASA"},{"$f":"INDEX('BASE DE DATOS'!$D$4:$D$98,MATCH(Hoja3!B7&Hoja3!C7&Hoja3!D7,'BASE DE DATOS'!$B$4:$B$98&'BASE DE DATOS'!$C$4:$C$98&'BASE DE DATOS'!$D$4:$D$98,0))","v":7}]
[{"$f":"INDEX('BASE DE DATOS'!$A$4:$A$98,MATCH(Hoja3!B8&Hoja3!C8&Hoja3!D8,'BASE DE DATOS'!$B$4:$B$98&'BASE DE DATOS'!$C$4:$C$98&'BASE DE DATOS'!$D$4:$D$98,0))","v":1},{"$f":"INDEX('BASE DE DATOS'!$B$4:$B$98,MATCH(Hoja3!B8&Hoja3!C8&Hoja3!D8,'BASE DE DATOS'!$B$4:$B$98&'BASE DE DATOS'!$C$4:$C$98&'BASE DE DATOS'!$D$4:$D$98,0))","v":"JUAN"},{"$f":"INDEX('BASE DE DATOS'!$C$4:$C$98,MATCH(Hoja3!B8&Hoja3!C8&Hoja3!D8,'BASE DE DATOS'!$B$4:$B$98&'BASE DE DATOS'!$C$4:$C$98&'BASE DE DATOS'!$D$4:$D$98,0))","v":"CASA"},{"$f":"INDEX('BASE DE DATOS'!$D$4:$D$98,MATCH(Hoja3!B8&Hoja3!C8&Hoja3!D8,'BASE DE DATOS'!$B$4:$B$98&'BASE DE DATOS'!$C$4:$C$98&'BASE DE DATOS'!$D$4:$D$98,0))","v":8}]
[{"$f":"INDEX('BASE DE DATOS'!$A$4:$A$98,MATCH(Hoja3!B9&Hoja3!C9&Hoja3!D9,'BASE DE DATOS'!$B$4:$B$98&'BASE DE DATOS'!$C$4:$C$98&'BASE DE DATOS'!$D$4:$D$98,0))","v":1},{"$f":"INDEX('BASE DE DATOS'!$B$4:$B$98,MATCH(Hoja3!B9&Hoja3!C9&Hoja3!D9,'BASE DE DATOS'!$B$4:$B$98&'BASE DE DATOS'!$C$4:$C$98&'BASE DE DATOS'!$D$4:$D$98,0))","v":"PEDRO"},{"$f":"INDEX('BASE DE DATOS'!$C$4:$C$98,MATCH(Hoja3!B9&Hoja3!C9&Hoja3!D9,'BASE DE DATOS'!$B$4:$B$98&'BASE DE DATOS'!$C$4:$C$98&'BASE DE DATOS'!$D$4:$D$98,0))","v":"CASA"},{"$f":"INDEX('BASE DE DATOS'!$D$4:$D$98,MATCH(Hoja3!B9&Hoja3!C9&Hoja3!D9,'BASE DE DATOS'!$B$4:$B$98&'BASE DE DATOS'!$C$4:$C$98&'BASE DE DATOS'!$D$4:$D$98,0))","v":5}]
[{"$f":"INDEX('BASE DE DATOS'!$A$4:$A$98,MATCH(Hoja3!B10&Hoja3!C10&Hoja3!D10,'BASE DE DATOS'!$B$4:$B$98&'BASE DE DATOS'!$C$4:$C$98&'BASE DE DATOS'!$D$4:$D$98,0))","v":2},{"$f":"INDEX('BASE DE DATOS'!$B$4:$B$98,MATCH(Hoja3!B10&Hoja3!C10&Hoja3!D10,'BASE DE DATOS'!$B$4:$B$98&'BASE DE DATOS'!$C$4:$C$98&'BASE DE DATOS'!$D$4:$D$98,0))","v":"LUIS"},{"$f":"INDEX('BASE DE DATOS'!$C$4:$C$98,MATCH(Hoja3!B10&Hoja3!C10&Hoja3!D10,'BASE DE DATOS'!$B$4:$B$98&'BASE DE DATOS'!$C$4:$C$98&'BASE DE DATOS'!$D$4:$D$98,0))","v":"PATIO"},{"$f":"INDEX('BASE DE DATOS'!$D$4:$D$98,MATCH(Hoja3!B10&Hoja3!C10&Hoja3!D10,'BASE DE DATOS'!$B$4:$B$98&'BASE DE DATOS'!$C$4:$C$98&'BASE DE DATOS'!$D$4:$D$98,0))","v":11}]
[{"$f":"INDEX('BASE DE DATOS'!$A$4:$A$98,MATCH(Hoja3!B11&Hoja3!C11&Hoja3!D11,'BASE DE DATOS'!$B$4:$B$98&'BASE DE DATOS'!$C$4:$C$98&'BASE DE DATOS'!$D$4:$D$98,0))","v":0},{"$f":"INDEX('BASE DE DATOS'!$B$4:$B$98,MATCH(Hoja3!B11&Hoja3!C11&Hoja3!D11,'BASE DE DATOS'!$B$4:$B$98&'BASE DE DATOS'!$C$4:$C$98&'BASE DE DATOS'!$D$4:$D$98,0))","v":0},{"$f":"INDEX('BASE DE DATOS'!$C$4:$C$98,MATCH(Hoja3!B11&Hoja3!C11&Hoja3!D11,'BASE DE DATOS'!$B$4:$B$98&'BASE DE DATOS'!$C$4:$C$98&'BASE DE DATOS'!$D$4:$D$98,0))","v":0},{"$f":"INDEX('BASE DE DATOS'!$D$4:$D$98,MATCH(Hoja3!B11&Hoja3!C11&Hoja3!D11,'BASE DE DATOS'!$B$4:$B$98&'BASE DE DATOS'!$C$4:$C$98&'BASE DE DATOS'!$D$4:$D$98,0))","v":0}]
[{"$f":"INDEX('BASE DE DATOS'!$A$4:$A$98,MATCH(Hoja3!B12&Hoja3!C12&Hoja3!D12,'BASE DE DATOS'!$B$4:$B$98&'BASE DE DATOS'!$C$4:$C$98&'BASE DE DATOS'!$D$4:$D$98,0))","v":0},{"$f":"INDEX('BASE DE DATOS'!$B$4:$B$98,MATCH(Hoja3!B12&Hoja3!C12&Hoja3!D12,'BASE DE DATOS'!$B$4:$B$98&'BASE DE DATOS'!$C$4:$C$98&'BASE DE DATOS'!$D$4:$D$98,0))","v":0},{"$f":"INDEX('BASE DE DATOS'!$C$4:$C$98,MATCH(Hoja3!B12&Hoja3!C12&Hoja3!D12,'BASE DE DATOS'!$B$4:$B$98&'BASE DE DATOS'!$C$4:$C$98&'BASE DE DATOS'!$D$4:$D$98,0))","v":0},{"$f":"INDEX('BASE DE DATOS'!$D$4:$D$98,MATCH(Hoja3!B12&Hoja3!C12&Hoja3!D12,'BASE DE DATOS'!$B$4:$B$98&'BASE DE DATOS'!$C$4:$C$98&'BASE DE DATOS'!$D$4:$D$98,0))","v":0}]
[{"$f":"INDEX('BASE DE DATOS'!$A$4:$A$98,MATCH(Hoja3!B13&Hoja3!C13&Hoja3!D13,'BASE DE DATOS'!$B$4:$B$98&'BASE DE DATOS'!$C$4:$C$98&'BASE DE DATOS'!$D$4:$D$98,0))","v":0},{"$f":"INDEX('BASE DE DATOS'!$B$4:$B$98,MATCH(Hoja3!B13&Hoja3!C13&Hoja3!D13,'BASE DE DATOS'!$B$4:$B$98&'BASE DE DATOS'!$C$4:$C$98&'BASE DE DATOS'!$D$4:$D$98,0))","v":0},{"$f":"INDEX('BASE DE DATOS'!$C$4:$C$98,MATCH(Hoja3!B13&Hoja3!C13&Hoja3!D13,'BASE DE DATOS'!$B$4:$B$98&'BASE DE DATOS'!$C$4:$C$98&'BASE DE DATOS'!$D$4:$D$98,0))","v":0},{"$f":"INDEX('BASE DE DATOS'!$D$4:$D$98,MATCH(Hoja3!B13&Hoja3!C13&Hoja3!D13,'BASE DE DATOS'!$B$4:$B$98&'BASE DE DATOS'!$C$4:$C$98&'BASE DE DATOS'!$D$4:$D$98,0))","v":0}]
[{"$f":"INDEX('BASE DE DATOS'!$A$4:$A$98,MATCH(Hoja3!B14&Hoja3!C14&Hoja3!D14,'BASE DE DATOS'!$B$4:$B$98&'BASE DE DATOS'!$C$4:$C$98&'BASE DE DATOS'!$D$4:$D$98,0))","v":0},{"$f":"INDEX('BASE DE DATOS'!$B$4:$B$98,MATCH(Hoja3!B14&Hoja3!C14&Hoja3!D14,'BASE DE DATOS'!$B$4:$B$98&'BASE DE DATOS'!$C$4:$C$98&'BASE DE DATOS'!$D$4:$D$98,0))","v":0},{"$f":"INDEX('BASE DE DATOS'!$C$4:$C$98,MATCH(Hoja3!B14&Hoja3!C14&Hoja3!D14,'BASE DE DATOS'!$B$4:$B$98&'BASE DE DATOS'!$C$4:$C$98&'BASE DE DATOS'!$D$4:$D$98,0))","v":0},{"$f":"INDEX('BASE DE DATOS'!$D$4:$D$98,MATCH(Hoja3!B14&Hoja3!C14&Hoja3!D14,'BASE DE DATOS'!$B$4:$B$98&'BASE DE DATOS'!$C$4:$C$98&'BASE DE DATOS'!$D$4:$D$98,0))","v":0}]
[]
[]
[]
[null,"EN LA FORMULA"]
[null,"LA HOJA 3 COINCIDENCIAS  ARRIBA CON LA HOJA 1 "]
[null,"Y HOJA2"]
[]
[null,"EN HOJA 1 Y HOJA 2 COINCIDEN"]
[null,"LUIS PISO 6 Y PEDRO CASA 5"]
[null,"ARRIBA SOLO REFLEJA LAS COINCIDENCIAS DE "]
[null,"LA HOJA 1"]

{"sheet":"BASE DE DATOS","index":4,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["ACT","LBRO","HOJA","Nº"]
["ACT","LBRO","HOJA","Nº","CONTAR COINCIDENCIAS"]
[]
[1,"LUIS","CASA",5,{"$f":"COUNTIFS($B$4:$B$54,B4,$C$4:$C$54,C4,$D$4:$D$54,D4)","v":2}]
[1,"LUIS","PISO",6,{"$f":"COUNTIFS($B$4:$B$54,B5,$C$4:$C$54,C5,$D$4:$D$54,D5)","v":3}]
[1,"PEDRO","CASA",5,{"$f":"COUNTIFS($B$4:$B$54,B6,$C$4:$C$54,C6,$D$4:$D$54,D6)","v":3}]
[1,"JUAN","CASA",8,{"$f":"COUNTIFS($B$4:$B$54,B7,$C$4:$C$54,C7,$D$4:$D$54,D7)","v":2}]
[1,"LUIS","CASA",9,{"$f":"COUNTIFS($B$4:$B$54,B8,$C$4:$C$54,C8,$D$4:$D$54,D8)","v":2}]
[1,"ANTONIO","CASA",1,{"$f":"COUNTIFS($B$4:$B$54,B9,$C$4:$C$54,C9,$D$4:$D$54,D9)","v":1}]
[1,"LUIS","PATIO",3,{"$f":"COUNTIFS($B$4:$B$54,B10,$C$4:$C$54,C10,$D$4:$D$54,D10)","v":1}]
[2,"LUIS","CASA",5,{"$f":"COUNTIFS($B$4:$B$54,B11,$C$4:$C$54,C11,$D$4:$D$54,D11)","v":2}]
[2,"LUIS","PISO",6,{"$f":"COUNTIFS($B$4:$B$54,B12,$C$4:$C$54,C12,$D$4:$D$54,D12)","v":3}]
[2,"PEDRO","CASA",7,{"$f":"COUNTIFS($B$4:$B$54,B13,$C$4:$C$54,C13,$D$4:$D$54,D13)","v":2}]
[2,"LUIS","CASA",9,{"$f":"COUNTIFS($B$4:$B$54,B14,$C$4:$C$54,C14,$D$4:$D$54,D14)","v":2}]
[2,"PEDRO","CASA",5,{"$f":"COUNTIFS($B$4:$B$54,B15,$C$4:$C$54,C15,$D$4:$D$54,D15)","v":3}]
[2,"LUIS","PATIO",11,{"$f":"COUNTIFS($B$4:$B$54,B16,$C$4:$C$54,C16,$D$4:$D$54,D16)","v":2}]
[3,"LUIS","PISO",6,{"$f":"COUNTIFS($B$4:$B$54,B17,$C$4:$C$54,C17,$D$4:$D$54,D17)","v":3}]
[3,"PEDRO","CASA",7,{"$f":"COUNTIFS($B$4:$B$54,B18,$C$4:$C$54,C18,$D$4:$D$54,D18)","v":2}]
[3,"JUAN","CASA",8,{"$f":"COUNTIFS($B$4:$B$54,B19,$C$4:$C$54,C19,$D$4:$D$54,D19)","v":2}]
[3,"PEDRO","CASA",5,{"$f":"COUNTIFS($B$4:$B$54,B20,$C$4:$C$54,C20,$D$4:$D$54,D20)","v":3}]
[3,"LUIS","PATIO",11,{"$f":"COUNTIFS($B$4:$B$54,B21,$C$4:$C$54,C21,$D$4:$D$54,D21)","v":2}]