{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Úvod","TEORIE","ZÁKLADY","ZÁKLADY-víc sloupců","ZÁKLADY unikáty","ZÁKLADY radek","Další informace"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":3,"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":"Úvod","index":0,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,2,1,9],[13,2,14,6],[16,3,17,6],[17,7,17,9],[28,1,28,11]]}
[]
[null,null,"Jak na Excel "]
[]
[]
[null,null,null,"Obsah cvičení"]
[null,null,null,null,"Teorie"]
[]
[null,null,null,null,"Základy"]
[null,null,null,null,"Pokročilé řady"]
[null,null,null,null,"Výpočty"]
[]
[]
[]
[null,null,"Pavel Lasák"]
[]
[]
[null,null,null,"Lektor, expert na Microsoft Excel, držitel prestižního ocenění Microsoftu MVP v České republice"]
[null,null,null,null,null,null,null,5002722]
[]
[]
[]
[]
[null,null,null,"Další informace ke cvičení:"]
[null,null,null,null,"https://office.lasakovi.com/excel/funkce-nove/Nove-funkce-EXCEL-seznam/"]
[null,null,null,null,"https://office.lasakovi.com/excel/funkce-nove/SEQUENCE-rada-cisel-Excel/"]
[]
[]
[]
[null,"Copyright, Pavel Lasák 2020    05/2020, 09/2023"]

{"sheet":"TEORIE","index":1,"n_rows":20,"n_cols":1,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,0,19,6],[0,0,0,6],[1,0,1,6],[3,0,3,6],[4,0,4,6],[6,0,6,6],[8,0,8,6],[10,0,10,6],[15,0,15,6]]}
["UNIQUE (UNIQUE)"]
["http://office.lasakovi.com"]
[]
["Popis"]
["Jedinečné hodnoty."]
[]
["Syntaxe CZ"]
["=UNIQUE(pole;podle_sloupce;jeden_výskyt)"]
["Syntaxe EN"]
["=UNIQUE(array,[by_col],[occurs_once])"]
["Popis argumentů"]
["array - povinný argument - Oblast z které potřebujete získat unikátní hodnoty"]
["by_col - nepovinný argument - Je logická hodnota jak porovnávat. Pokud je vynechán nebo NEPRAVDA (FALSE) jde se podle řádků. Podle sloupce je pak PRAVDA (TRUE)."]
["occurs_once - nepovinný argument - NEPRAVDA (FALSE) nebo vynechané - zahrnout všechny jedinečné hodnoty; vrací jedinečné hodnoty se vyskytnou jednou (PRAVDA) TRUE"]
[]
["Příklady"]
[]
[]
[]
["Pavel Lasák - 2019"]

{"sheet":"ZÁKLADY","index":2,"n_rows":44,"n_cols":9,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[3,1,3,4],[43,0,43,4]]}
["UNIQUE (UNIQUE)"]
["http://office.lasakovi.com"]
[]
[null,"Zdrojová data"]
[]
[null,"ID","Jméno","Sex","Jméno"]
[null,1,"Pavel","M",null,null,null,null,"=UNIQUE(pole;podle_sloupce;jeden_výskyt)"]
[null,2,"Ema","F","jméno bez mezery"]
[null,3,"Pavel","M"]
[null,4,"Ema ","F","jméno s mezerou navíc"]
[null,3,"Iva","F"]
[null,6,"Jan","M"]
[]
[null,"Úkol","Potřebuji unikátní hodnoty ze sloupce jméno"]
[null,null,"Jméno",null,"Sex"]
[null,null,{"$f":"_xlfn.UNIQUE(C7:C12)","v":"Pavel"},null,{"$f":"_xlfn.UNIQUE(D7:D12)","v":"M"}]
[null,null,"Ema",null,"F"]
[null,null,"Ema ",null,{"$f":"_xlfn.FORMULATEXT(E16)","v":"=UNIQUE(D7:D12)"}]
[null,null,"Iva"]
[null,null,"Jan"]
[null,null,{"$f":"_xlfn.FORMULATEXT(C16)","v":"=UNIQUE(C7:C12)"}]
[null,null,"Ema a Ema s mezerou jsou jiné"]
[]
[null,"Úkol","Potřebuji unikátní hodnoty ze sloupce jméno"]
[null,null,"Jméno",null,"Sex",null,"Sex"]
[null,null,{"$f":"_xlfn.UNIQUE(C7:C12,FALSE)","v":"Pavel"},null,{"$f":"_xlfn.UNIQUE(D7:D12,FALSE)","v":"M"},null,{"$f":"_xlfn.UNIQUE(D7:D12,TRUE)","v":"M"}]
[null,null,"Ema",null,"F",null,"F"]
[null,null,"Ema ",null,{"$f":"_xlfn.FORMULATEXT(E26)","v":"=UNIQUE(D7:D12;NEPRAVDA)"},null,"M"]
[null,null,"Iva",null,null,null,"F"]
[null,null,"Jan",null,null,null,"F"]
[null,null,{"$f":"_xlfn.FORMULATEXT(C26)","v":"=UNIQUE(C7:C12;NEPRAVDA)"},null,null,null,"M"]
[null,null,null,null,null,null,{"$f":"_xlfn.FORMULATEXT(G26)","v":"=UNIQUE(D7:D12;PRAVDA)"}]
[null,null,"Jméno"]
[null,null,{"$f":"_xlfn.UNIQUE(C7:C12,FALSE,FALSE)","v":"Pavel"},null,null,null,"Jméno"]
[null,null,"Ema",null,null,null,{"$f":"_xlfn.UNIQUE(C7:C12,FALSE,TRUE)","v":"Ema"}]
[null,null,"Ema ",null,null,null,"Ema "]
[null,null,"Iva",null,null,null,"Iva"]
[null,null,"Jan",null,null,null,"Jan"]
[null,null,{"$f":"_xlfn.FORMULATEXT(C34)","v":"=UNIQUE(C7:C12;NEPRAVDA;NEPRAVDA)"}]
[null,null,null,null,null,null,{"$f":"_xlfn.FORMULATEXT(G35)","v":"=UNIQUE(C7:C12;NEPRAVDA;PRAVDA)"}]
[null,null,{"$f":"_xlfn.FORMULATEXT(C26)","v":"=UNIQUE(C7:C12;NEPRAVDA)"}]
[null,null,"Ema a Ema s mezerou jsou jiné"]
[]
["Pavel Lasák - 2019"]

{"sheet":"ZÁKLADY-víc sloupců","index":3,"n_rows":25,"n_cols":11,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[3,1,3,4],[24,0,24,4]]}
["UNIQUE (UNIQUE) - více sloupců"]
["http://office.lasakovi.com"]
[]
[null,"Zdrojová data"]
[]
[null,"ID","Jméno","Sex","Jméno"]
[null,1,"Pavel","M","M bez mezery",null,null,null,"=UNIQUE(pole;podle_sloupce;jeden_výskyt)"]
[null,2,"Ema","F","jméno bez mezery"]
[null,3,"Pavel","M ","M s mezerou"]
[null,4,"Ema ","F","jméno s mezerou navíc"]
[null,3,"Iva","F"]
[null,6,"Jan","M"]
[]
[null,"Úkol","Potřebuji unikátní hodnoty ze sloupce jméno a pohlaví (sex)"]
[null,null,"Jméno","Sex",null,null,null,null,null,null,"Sex"]
[null,null,{"$f":"_xlfn.UNIQUE(C7:D12)","v":"Pavel"},"M",null,null,null,null,null,null,{"$f":"_xlfn.UNIQUE(D7:D12)","v":{"$error":"#VALUE!"}}]
[null,null,"Ema","F"]
[null,null,"Pavel","M ",null,null,null,null,null,null,{"$f":"_xlfn.FORMULATEXT(K16)","v":"=UNIQUE(D7:D12)"}]
[null,null,"Ema ","F"]
[null,null,"Iva","F"]
[null,null,"Jan","M"]
[null,null,{"$f":"_xlfn.FORMULATEXT(C16)","v":"=UNIQUE(C7:D12)"}]
[null,null,"Ema a Ema s mezerou jsou jiné stejně tak M u pohlaví Pavel"]
[]
["Pavel Lasák - 2019"]

{"sheet":"ZÁKLADY unikáty","index":4,"n_rows":45,"n_cols":9,"rows_kept":45,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[3,1,3,4],[44,0,44,4]]}
["UNIQUE (UNIQUE) - jedinečné"]
["http://office.lasakovi.com"]
[]
[null,"Zdrojová data"]
[]
[null,"ID","Jméno","Sex","Jméno"]
[null,1,"Pavel","M",null,null,null,null,"=UNIQUE(pole;podle_sloupce;jeden_výskyt)"]
[null,2,"Ema","F","jméno bez mezery"]
[null,3,"Pavel","M"]
[null,4,"Ema ","M","jméno s mezerou navíc"]
[null,3,"Iva","F"]
[null,6,"Jan","M"]
[]
[null,"Úkol","Potřebuji jedinečné hodnoty ze sloupce jméno potažmo sex"]
[null,null,"Jméno",null,"Sex"]
[null,null,{"$f":"_xlfn.UNIQUE(C7:C12,,TRUE)","v":"Ema"},null,{"$f":"_xlfn.UNIQUE(D7:D12,,TRUE)","v":{"$error":"#VALUE!"}}]
[null,null,"Ema ",null,{"$f":"_xlfn.FORMULATEXT(E16)","v":"=UNIQUE(D7:D12;;PRAVDA)"}]
[null,null,"Iva"]
[null,null,"Jan"]
[null,null,{"$f":"_xlfn.FORMULATEXT(C16)","v":"=UNIQUE(C7:C12;;PRAVDA)"}]
[null,null,"Ema a Ema s mezerou jsou jiné"]
[]
[]
[null,"Úkol","Potřebuji unikátní hodnoty ze sloupce jméno"]
[null,null,"Jméno",null,"Sex",null,"Sex"]
[null,null,{"$f":"_xlfn.UNIQUE(C7:C12,FALSE)","v":"Pavel"},null,{"$f":"_xlfn.UNIQUE(D7:D12,FALSE)","v":"M"},null,{"$f":"_xlfn.UNIQUE(D7:D12,TRUE)","v":"M"}]
[null,null,"Ema",null,"F",null,"F"]
[null,null,"Ema ",null,{"$f":"_xlfn.FORMULATEXT(E26)","v":"=UNIQUE(D7:D12;NEPRAVDA)"},null,"M"]
[null,null,"Iva",null,null,null,"M"]
[null,null,"Jan",null,null,null,"F"]
[null,null,{"$f":"_xlfn.FORMULATEXT(C26)","v":"=UNIQUE(C7:C12;NEPRAVDA)"},null,null,null,"M"]
[]
[null,null,null,null,null,null,{"$f":"_xlfn.FORMULATEXT(G26)","v":"=UNIQUE(D7:D12;PRAVDA)"}]
[null,null,"Jméno"]
[null,null,{"$f":"_xlfn.UNIQUE(C7:C12,FALSE,FALSE)","v":"Pavel"},null,null,null,"Jméno"]
[null,null,"Ema",null,null,null,{"$f":"_xlfn.UNIQUE(C7:C12,FALSE,TRUE)","v":"Ema"}]
[null,null,"Ema ",null,null,null,"Ema "]
[null,null,"Iva",null,null,null,"Iva"]
[null,null,"Jan",null,null,null,"Jan"]
[null,null,{"$f":"_xlfn.FORMULATEXT(C35)","v":"=UNIQUE(C7:C12;NEPRAVDA;NEPRAVDA)"}]
[null,null,null,null,null,null,{"$f":"_xlfn.FORMULATEXT(G36)","v":"=UNIQUE(C7:C12;NEPRAVDA;PRAVDA)"}]
[null,null,{"$f":"_xlfn.FORMULATEXT(C26)","v":"=UNIQUE(C7:C12;NEPRAVDA)"}]
[null,null,"Ema a Ema s mezerou jsou jiné"]
[]
["Pavel Lasák - 2019"]

{"sheet":"ZÁKLADY radek","index":5,"n_rows":40,"n_cols":26,"rows_kept":40,"cut":false,"hidden":false,"merged":[[39,0,39,4],[3,1,3,7],[0,0,0,8],[17,0,17,8],[21,16,21,20],[22,16,22,20],[23,16,23,20],[1,0,1,5]]}
["UNIQUE (UNIQUE) - řádek"]
["http://office.lasakovi.com"]
[]
[null,"Zdrojová data",null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10]
[null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,"ID",1,2,3,4,5,6,null,null,null,null,3]
[null,"Jméno","Pavel","Ema","Pavel","Ema","Ema","Jan",null,null,null,null,4]
[null,"Sex","M","F","M","F","F","M",null,null,null,null,5,null,null,"Plocha dle stran"]
[null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,"Úkol","Potřebuji unikátní hodnoty ze sloupce jméno",null,null,null,null,null,null,null,null,null,7,null,null,"             Strana a\nStrana b",{"$f":"_xlfn.UNIQUE(M4:V4,FALSE)","v":1},2,3,4,5,6,7,8,9,10]
[null,"Jméno",{"$f":"_xlfn.UNIQUE(C7:H7,TRUE,FALSE)","v":"Pavel"},"Ema","Jan",null,null,null,null,null,null,null,8,null,null,{"$f":"_xlfn.UNIQUE(M4:M13)","v":1},{"$f":"_xlfn.ANCHORARRAY(Q10)*_xlfn.ANCHORARRAY(P11)","v":1},2,3,4,5,6,7,8,9,10]
[null,null,{"$f":"_xlfn.FORMULATEXT(C11)","v":"=UNIQUE(C7:H7;PRAVDA;NEPRAVDA)"},null,null,null,null,null,null,null,null,null,9,null,null,2,2,4,6,8,10,12,14,16,18,20]
[null,null,null,null,null,null,null,null,null,null,null,null,10,null,null,3,3,6,9,12,15,18,21,24,27,30]
[null,"Úkol","Potřebuji jedinečné hodnoty ze sloupce jméno",null,null,null,null,null,null,null,null,null,11,null,null,4,4,8,12,16,20,24,28,32,36,40]
[null,"Jméno",{"$f":"_xlfn.UNIQUE(C7:H7,TRUE,TRUE)","v":"Jan"},null,null,null,null,null,null,null,null,null,12,null,null,5,5,10,15,20,25,30,35,40,45,50]
[null,null,{"$f":"_xlfn.FORMULATEXT(C15)","v":"=UNIQUE(C7:H7;PRAVDA;PRAVDA)"},null,null,null,null,null,null,null,null,null,null,null,null,6,6,12,18,24,30,36,42,48,54,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,7,14,21,28,35,42,49,56,63,70]
["Pavel Lasák - 2019",null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,8,16,24,32,40,48,56,64,72,80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,9,18,27,36,45,54,63,72,81,90]
[null,"Úkol","Potřebuji unikátní hodnoty ze sloupce jméno",null,null,null,null,null,null,null,null,null,null,null,null,10,10,20,30,40,50,60,70,80,90,100]
[null,null,"Jméno",null,"Sex",null,"Sex"]
[null,null,{"$f":"_xlfn.UNIQUE(#REF!,FALSE)","v":{"$error":"#REF!"}},null,{"$f":"_xlfn.UNIQUE(#REF!,FALSE)","v":{"$error":"#REF!"}},null,{"$f":"_xlfn.UNIQUE(#REF!,TRUE)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,"Použíté funkce",{"$f":"_xlfn.FORMULATEXT(Q10)","v":"=UNIQUE(M4:V4;NEPRAVDA)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.FORMULATEXT(P11)","v":"=UNIQUE(M4:M13)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.FORMULATEXT(Q11)","v":"=Q10#*P11#"}]
[]
[]
[null,null,{"$f":"_xlfn.FORMULATEXT(C22)","v":"=UNIQUE(#ODKAZ!;NEPRAVDA)"}]
[null,null,null,null,null,null,{"$f":"_xlfn.FORMULATEXT(G22)","v":"=UNIQUE(#ODKAZ!;PRAVDA)"}]
[null,null,"Jméno"]
[null,null,{"$f":"_xlfn.UNIQUE(#REF!,FALSE,FALSE)","v":{"$error":"#REF!"}},null,null,null,"Jméno",null,null,null,null,null,null,null,null,null,"Sex"]
[null,null,null,null,null,null,{"$f":"_xlfn.UNIQUE(#REF!,FALSE,TRUE)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.UNIQUE(#REF!)","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.FORMULATEXT(Q31)","v":"=UNIQUE(#ODKAZ!)"}]
[]
[null,null,{"$f":"_xlfn.FORMULATEXT(C30)","v":"=UNIQUE(#ODKAZ!;NEPRAVDA;NEPRAVDA)"}]
[null,null,null,null,null,null,{"$f":"_xlfn.FORMULATEXT(G31)","v":"=UNIQUE(#ODKAZ!;NEPRAVDA;PRAVDA)"}]
[null,null,{"$f":"_xlfn.FORMULATEXT(C22)","v":"=UNIQUE(#ODKAZ!;NEPRAVDA)"}]
[null,null,"Ema a Ema s mezerou jsou jiné"]
[]
["Pavel Lasák - 2019"]

{"sheet":"Další informace","index":6,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3]]}
["Další informace o funkcích"]
["http://office.lasakovi.com"]
[]
[]
[null,"FILTER","https://office.lasakovi.com/excel/funkce-nove/FILTER-vyfiltrovat-data-v-Excel/"]
[null,"RANDARRAY","https://office.lasakovi.com/excel/funkce-nove/RANDARRAY-nahodne-cislo-Excel/"]
[null,"SEQUENCE","https://office.lasakovi.com/excel/funkce-nove/SEQUENCE-rada-cisel-Excel/"]
[null,"SINGLE"]
[null,"SORT","https://office.lasakovi.com/excel/funkce-nove/SORT-setridit-data-v-Excel/"]
[null,"SORTBY","https://office.lasakovi.com/excel/funkce-nove/SORTBY-setridit-data-v-Excel/"]
[null,"UNIQUE","https://office.lasakovi.com/excel/funkce-nove/UNIQUE-funkce-unikatni-data-v-Excel/"]