{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Формулой","Одно условие","Приблизительный поиск","Много условий","PowerQuery"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Формулой","index":0,"n_rows":23,"n_cols":12,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Компания","Адрес"]
["Водолей","petya@gmail.com",{"$f":"IF(A2=A1,C1&\", \"&B2,B2)","v":"petya@gmail.com"},{"$f":"IF(LEN(C2)<LEN(C3),0,1)","v":0}]
["Водолей","nik@yandex.ru",{"$f":"IF(A3=A2,C2&\", \"&B3,B3)","v":"petya@gmail.com, nik@yandex.ru"},{"$f":"IF(LEN(C3)<LEN(C4),0,1)","v":1}]
["Орион","vasya@mail.ru","vasya@mail.ru",0]
["Орион","olga@mail.ru","vasya@mail.ru, olga@mail.ru",0]
["Орион","ivan@mail.ru","vasya@mail.ru, olga@mail.ru, ivan@mail.ru",1]
["Персей","masha@ya.ru","masha@ya.ru",0]
["Персей","alena@rambler.ru","masha@ya.ru, alena@rambler.ru",0]
["Персей","alex@outlook.com","masha@ya.ru, alena@rambler.ru, alex@outlook.com",0]
["Персей","samson@yandex.ru","masha@ya.ru, alena@rambler.ru, alex@outlook.com, samson@yandex.ru",1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"Одно условие","index":1,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Компания","Адрес"]
["Орион","vasya@mail.ru"]
["Персей","masha@ya.ru"]
["Водолей","petya@gmail.com",null,null,"Орион",{"$f":"MergeIf(B2:B9,A2:A9,E4)","v":"vasya@mail.ru, olga@mail.ru, ivan@mail.ru"}]
["Водолей","nik@yandex.ru"]
["Орион","olga@mail.ru"]
["Персей","alena@rambler.ru"]
["Орион","ivan@mail.ru"]
["Персей","alex@outlook.com"]

{"sheet":"Приблизительный поиск","index":2,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Компания","Адрес"]
["Орион ООО","vasya@mail.ru"]
["Компания персей","masha@ya.ru"]
["Водолей","petya@gmail.com",null,null,"*Орион*",{"$f":"MergeIf(B2:B9,A2:A9,E4)","v":"vasya@mail.ru, olga@mail.ru, ivan@mail.ru"}]
["Водолей","nik@yandex.ru",null,null,"*Персей*",{"$f":"MergeIf(B2:B9,A2:A9,E5)","v":"masha@ya.ru, alena@rambler.ru, alex@outlook.com"}]
["ООО \"орион\"","olga@mail.ru"]
["Персей LLC","alena@rambler.ru"]
["Орион и Ко","ivan@mail.ru"]
["Фирма \"Персей\"","alex@outlook.com"]

{"sheet":"Много условий","index":3,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Город","Компания","Адрес"]
["Москва","Орион","vasya@mail.ru"]
["Москва","Персей","masha@ya.ru"]
["Москва","Водолей","petya@gmail.com",null,"Питер","Орион",{"$f":"MergeIfs(C2:C9,A2:A9,E4,B2:B9,F4)","v":"olga@mail.ru, ivan@mail.ru"}]
["Москва","Водолей","nik@yandex.ru"]
["Питер","Орион","olga@mail.ru"]
["Питер","Персей","alena@rambler.ru"]
["Питер","Орион","ivan@mail.ru"]
["Питер","Персей","alex@outlook.com"]

{"sheet":"PowerQuery","index":4,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Компания","Адрес"]
["Орион","vasya@mail.ru"]
["Персей","masha@ya.ru",null,null,null,"Компания","Адреса"]
["Водолей","petya@gmail.com",null,null,null,"Орион","vasya@mail.ru, olga@mail.ru, ivan@mail.ru"]
["Водолей","nik@yandex.ru",null,null,null,"Персей","masha@ya.ru, alena@rambler.ru, alex@outlook.com"]
["Орион","olga@mail.ru",null,null,null,"Водолей","petya@gmail.com, nik@yandex.ru"]
["Персей","alena@rambler.ru"]
["Орион","ivan@mail.ru"]
["Персей","alex@outlook.com"]