{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["01_TEO","02_Zak","03_záhlaví","03_součty","04_řazeni","07_jazyky","10_www","04_řazeni (2)"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":4,"defined_names":53,"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":"01_TEO","index":0,"n_rows":55,"n_cols":14,"rows_kept":55,"cut":false,"hidden":false,"merged":[[54,0,54,4],[54,8,54,14],[0,0,2,7],[7,0,7,14],[8,1,8,13],[26,2,26,13],[13,2,14,13],[27,2,27,13],[18,2,19,13]]}
["Funkce v Excel"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Vyhledávací"]
[]
[]
[]
[]
[]
["SESKUPITPODLE (GROUPBY)"]
[null,"Agregovat hodnoty podle řádkového pole"]
[]
[]
[null,"Syntaxe v češtině"]
[]
[null,null,"SESKUPITPODLE(row_fields;values;function;field_headers;total_depth;sort_order;filter_array)"]
[]
[]
[null,"Syntaxe v angličtině"]
[]
[null,null,"GROUPBY(row_fields;values;function;field_headers;total_depth;sort_order;filter_array)"]
[]
[]
[null,"Popis argumentů"]
[]
[null,"row_fields",null,"povinný","Oblast nebo pole obsahující řádkový pole"]
[null,"values",null,"povinný","Oblast obsahující hodnoty, které se mají agregovat"]
[null,"function",null,"povinný","Funkce pro agregaci"]
[null,null,"SUMA, PROCENTO, PRŮMĚR, MEDIAN, POČET, POČET2, MAX, MIN, SOUČIN"]
[null,null,"ARRAYTOTEXT, CONCAT, SMODCH.VÝBĚR.S, SMODCH.P, VAR.S, VAR.P, MODE.SNG"]
[null,"field_headers",null,"volitelný","Zda data obsahují záhlaví a zda se má zahlaví vracet"]
[null,null,0,"Ne"]
[null,null,1,"Ano, ale nezobrazvat"]
[null,null,2,"Ne, ale generovat"]
[null,null,3,"Ano a zobrazit"]
[null,"total_depth",null,"volitelný","Součty pro řádková pole"]
[null,null,0,"Žádné součty"]
[null,null,1,"Celkové součty"]
[null,null,2,"Celkové součty a mezisoučty"]
[null,null,-1,"Celkové součty nahoře"]
[null,null,-2,"Celkové součty a mezisoučty nahoře"]
[null,"sort_order",null,"volitelný","Index pole, podle kterého se mají seřadit řádková pole"]
[null,"filter_array",null,"volitelný","Pole logických hodnot, kde "]
[null,null,null,"PRAVDA (TRUE) představuje řádek, který se má zachovat"]
[]
[null,"Poznámky"]
[]
[]
[]
[null,"Omezení"]
[]
[null,"Pro Office 365 lze používat dynamické oblasti"]
[]
[]
[]
[]
["Pavel Lasák, MVP - 2023",null,null,null,null,null,null,null,"https://office.lasakovi.com"]

{"sheet":"02_Zak","index":1,"n_rows":51,"n_cols":14,"rows_kept":51,"cut":false,"hidden":false,"merged":[[0,0,0,10],[1,0,1,10],[28,5,28,9],[21,5,21,9],[22,5,22,9],[42,5,42,9],[43,5,43,9],[49,0,49,10],[50,0,50,10],[29,5,29,9],[35,5,35,9],[36,5,36,9]]}
["SESKUPITPODLE (GROUPBY) - seskupit základ"]
["http://office.lasakovi.com"]
[]
[null,"Úkol"]
[]
[null,"Požadavek seskupení podle požadovaného sloupce a statistiku "]
[]
[null,"Zdrojová tabulka"]
[]
[null,"B","C","D","E","F","G",null,null,null,null,null,"Město","Jméno"]
[{"$f":"ROW()","v":11},"ID","Město","Sex","Plat","Jméno","Čas",null,null,null,null,null,"Opava","Pavel Lasák"]
[{"$f":"ROW()","v":12},1,"Opava","M",15000,"Pavel Lasák","15:10:00",null,null,null,null,null,"Ostrava","Karel Nový"]
[{"$f":"ROW()","v":13},2,"Ostrava","M",17000,"Karel Nový","16:20:00",null,null,null,null,null,"Opava","Iva Iva"]
[{"$f":"ROW()","v":14},3,"Opava","F",20000,"Iva Iva","11:10:00",null,null,null,null,null,"Ostrava","Pavel Lasák"]
[{"$f":"ROW()","v":15},4,"Ostrava","M",10000,"Pavel Lasák","17:47:00",null,null,null,null,null,"Opava","Karel Voršálek"]
[{"$f":"ROW()","v":16},5,"Opava","M",15000,"Karel Voršálek","05:01:00",null,null,null,null,null,"Ostrava","Jana Malá"]
[{"$f":"ROW()","v":17},6,"Ostrava","F",15000,"Jana Malá","05:01:00"]
[]
[]
[null,"Sumy platů podle pohlaví"]
[]
[null,"B","C",null,null,"Funkce v buňce B23"]
[{"$f":"ROW()","v":23},{"$f":"_xlfn.GROUPBY(D12:D17,E12:E17,_xleta.SUM)","v":"F"},35000,null,null,{"$f":"_xlfn.FORMULATEXT(B23)","v":"=SESKUPITPODLE(D12:D17;E12:E17;SUMA)"}]
[{"$f":"ROW()","v":24},"M",57000]
[{"$f":"ROW()","v":25},"Celkem",92000]
[]
[null,"Počty osob podle pohlaví"]
[]
[null,"B","C",null,null,"Funkce v buňce B30"]
[{"$f":"ROW()","v":30},{"$f":"_xlfn.GROUPBY(D12:D17,E12:E17,_xleta.COUNT)","v":"F"},2,null,null,{"$f":"_xlfn.FORMULATEXT(B30)","v":"=SESKUPITPODLE(D12:D17;E12:E17;POČET)"}]
[{"$f":"ROW()","v":31},"M",4]
[{"$f":"ROW()","v":32},"Celkem",6]
[]
[null,"druhý způsob výpočtu počtu osob s využitím jiného sloupce"]
[]
[null,"B","C",null,null,"Funkce v buňce B37"]
[{"$f":"ROW()","v":37},{"$f":"_xlfn.GROUPBY(D12:D17,D12:D17,_xleta.COUNTA)","v":"F"},2,null,null,{"$f":"_xlfn.FORMULATEXT(B37)","v":"=SESKUPITPODLE(D12:D17;D12:D17;POČET2)"}]
[{"$f":"ROW()","v":38},"M",4]
[{"$f":"ROW()","v":39},"Celkem",6]
[]
[null,"Průměrný plat dle pohlaví"]
[]
[null,"B","C",null,null,"Funkce v buňce B30"]
[{"$f":"ROW()","v":44},{"$f":"_xlfn.GROUPBY(D12:D17,E12:E17,_xleta.AVERAGE)","v":"F"},17500,null,null,{"$f":"_xlfn.FORMULATEXT(B44)","v":"=SESKUPITPODLE(D12:D17;E12:E17;PRŮMĚR)"}]
[{"$f":"ROW()","v":45},"M",14250]
[{"$f":"ROW()","v":46},"Celkem",15333.333333333334]
[]
[]
[]
["https://office.lasakovi.com"]
["Pavel Lasák - 2024"]

{"sheet":"03_záhlaví","index":2,"n_rows":57,"n_cols":16,"rows_kept":57,"cut":false,"hidden":false,"merged":[[56,0,56,10],[0,0,0,10],[1,0,1,10],[28,5,28,9],[29,5,29,9],[21,5,21,9],[22,5,22,9],[45,5,45,9],[36,5,36,9],[37,5,37,9],[44,5,44,9],[55,0,55,10]]}
["SESKUPITPODLE (GROUPBY) - záhlaví"]
["http://office.lasakovi.com"]
[]
[null,"Úkol"]
[]
[null,"Práce se záhlavím"]
[]
[null,"Zdrojová tabulka"]
[]
[null,"B","C","D","E","F","G"]
[{"$f":"ROW()","v":11},"ID","Město","Sex","Plat","Jméno","Čas"]
[{"$f":"ROW()","v":12},1,"Opava","M",15000,"Pavel Lasák","15:10:00"]
[{"$f":"ROW()","v":13},2,"Ostrava","M",17000,"Karel Nový","16:20:00"]
[{"$f":"ROW()","v":14},3,"Opava","F",20000,"Iva Iva","11:10:00",null,null,null,null,null,"total_depth",null,"volitelný","Součty pro řádková pole"]
[{"$f":"ROW()","v":15},4,"Ostrava","M",10000,"Pavel Lasák","17:47:00",null,null,null,null,null,null,0,"Žádené součty"]
[{"$f":"ROW()","v":16},5,"Opava","M",15000,"Karel Voršálek","05:01:00",null,null,null,null,null,null,1,"Celkové součty"]
[{"$f":"ROW()","v":17},6,"Ostrava","F",15000,"Jana Malá","05:01:00",null,null,null,null,null,null,2,"Celkové součty a mezisoučty"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,-1,"Celkové součty nahoře"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,-2,"Celkové součty a mezisoučty nahoře"]
[null,"Zahlaví ano, ale nezobrazit"]
[]
[null,"B","C",null,null,"Funkce v buňce B23"]
[{"$f":"ROW()","v":23},{"$f":"_xlfn.GROUPBY(D11:D17,E11:E17,_xleta.SUM,1)","v":"F"},35000,null,null,{"$f":"_xlfn.FORMULATEXT(B23)","v":"=SESKUPITPODLE(D11:D17;E11:E17;SUMA;1)"}]
[{"$f":"ROW()","v":24},"M",57000]
[{"$f":"ROW()","v":25},"Celkem",92000]
[]
[null,"Zahlaví ne, ale generovat"]
[]
[null,"B","C",null,null,"Funkce v buňce B30"]
[{"$f":"ROW()","v":30},{"$f":"_xlfn.GROUPBY(D12:D17,E12:E17,_xleta.SUM,2)","v":"Řádkové pole 1"},"",null,null,{"$f":"_xlfn.FORMULATEXT(B30)","v":"=SESKUPITPODLE(D12:D17;E12:E17;SUMA;2)"}]
[{"$f":"ROW()","v":31},"F",35000]
[{"$f":"ROW()","v":32},"M",57000]
[{"$f":"ROW()","v":33},"Celkem",92000]
[]
[null,"Zahlaví ano, ale zobrazit"]
[]
[null,"B","C",null,null,"Funkce v buňce B38"]
[{"$f":"ROW()","v":38},{"$f":"_xlfn.GROUPBY(D11:D17,E11:E17,_xleta.SUM,3)","v":"Sex"},"",null,null,{"$f":"_xlfn.FORMULATEXT(B38)","v":"=SESKUPITPODLE(D11:D17;E11:E17;SUMA;3)"}]
[{"$f":"ROW()","v":39},"F",35000]
[{"$f":"ROW()","v":40},"M",57000]
[{"$f":"ROW()","v":41},"Celkem",92000]
[]
[null,"Zahlaví ano, ale zobrazit"]
[]
[null,"B","C","D",null,"Funkce v buňce B46"]
[{"$f":"ROW()","v":46},{"$f":"_xlfn.GROUPBY(C11:D17,E11:E17,_xleta.SUM,3)","v":"Město"},"Sex","",null,{"$f":"_xlfn.FORMULATEXT(B46)","v":"=SESKUPITPODLE(C11:D17;E11:E17;SUMA;3)"}]
[{"$f":"ROW()","v":47},"Opava","F",20000]
[{"$f":"ROW()","v":48},"Opava","M",30000]
[{"$f":"ROW()","v":49},"Ostrava","F",15000]
[{"$f":"ROW()","v":50},"Ostrava","M",27000]
[{"$f":"ROW()","v":51},"Celkem","",92000]
[]
[]
[]
[]
["https://office.lasakovi.com"]
["Pavel Lasák - 2024"]

{"sheet":"03_součty","index":3,"n_rows":57,"n_cols":16,"rows_kept":57,"cut":false,"hidden":false,"merged":[[34,5,34,9],[35,5,35,9],[55,0,55,10],[56,0,56,10],[43,5,43,9],[44,5,44,9],[0,0,0,10],[1,0,1,10],[21,5,21,9],[22,5,22,9],[27,5,27,9],[28,5,28,9]]}
["SESKUPITPODLE (GROUPBY) - součty, mezisoučty"]
["http://office.lasakovi.com"]
[]
[null,"Úkol"]
[]
[null,"Požadavek seskupení podle požadovaného sloupce a statistiku "]
[]
[null,"Zdrojová tabulka"]
[]
[null,"B","C","D","E","F","G"]
[{"$f":"ROW()","v":11},"ID","Město","Sex","Plat","Jméno","Čas"]
[{"$f":"ROW()","v":12},1,"Opava","M",15000,"Pavel Lasák","15:10:00"]
[{"$f":"ROW()","v":13},2,"Ostrava","M",17000,"Karel Nový","16:20:00"]
[{"$f":"ROW()","v":14},3,"Opava","F",20000,"Iva Iva","11:10:00",null,null,null,null,null,"total_depth",null,"volitelný","Součty pro řádková pole"]
[{"$f":"ROW()","v":15},4,"Ostrava","M",10000,"Pavel Lasák","17:47:00",null,null,null,null,null,null,0,"Žádené součty"]
[{"$f":"ROW()","v":16},5,"Opava","M",15000,"Karel Voršálek","05:01:00",null,null,null,null,null,null,1,"Celkové součty"]
[{"$f":"ROW()","v":17},6,"Ostrava","F",15000,"Jana Malá","05:01:00",null,null,null,null,null,null,2,"Celkové součty a mezisoučty"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,-1,"Celkové součty nahoře"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,-2,"Celkové součty a mezisoučty nahoře"]
[null,"Součty, žádné"]
[]
[null,"B","C",null,null,"Funkce v buňce B22 "]
[{"$f":"ROW()","v":23},{"$f":"_xlfn.GROUPBY(D11:D17,E11:E17,_xleta.SUM,,0)","v":"F"},35000,null,null,{"$f":"_xlfn.FORMULATEXT(B23)","v":"=SESKUPITPODLE(D11:D17;E11:E17;SUMA;;0)"}]
[{"$f":"ROW()","v":24},"M",57000]
[]
[null,"Součty, celkové"]
[]
[null,"B","C",null,null,"Funkce v buňce B30"]
[{"$f":"ROW()","v":29},{"$f":"_xlfn.GROUPBY(D12:D17,E12:E17,_xleta.SUM,,1)","v":"F"},35000,null,null,{"$f":"_xlfn.FORMULATEXT(B29)","v":"=SESKUPITPODLE(D12:D17;E12:E17;SUMA;;1)"}]
[{"$f":"ROW()","v":30},"M",57000]
[{"$f":"ROW()","v":31},"Celkem",92000]
[]
[null,"Součty, celkové, více kriterií"]
[]
[null,"B","C","D",null,"Funkce v buňce B38"]
[{"$f":"ROW()","v":36},{"$f":"_xlfn.GROUPBY(C12:D17,E12:E17,_xleta.SUM,,1)","v":"Opava"},"F",20000,null,{"$f":"_xlfn.FORMULATEXT(B36)","v":"=SESKUPITPODLE(C12:D17;E12:E17;SUMA;;1)"}]
[{"$f":"ROW()","v":37},"Opava","M",30000]
[{"$f":"ROW()","v":38},"Ostrava","F",15000]
[{"$f":"ROW()","v":39},"Ostrava","M",27000]
[{"$f":"ROW()","v":40},"Celkem","",92000]
[]
[null,"Součty, celkové a mezisoučty více kriterií"]
[]
[null,"B","C","D",null,"Funkce v buňce B38"]
[{"$f":"ROW()","v":45},{"$f":"_xlfn.GROUPBY(C12:D17,E12:E17,_xleta.SUM,,2)","v":"Opava"},"F",20000,null,{"$f":"_xlfn.FORMULATEXT(B45)","v":"=SESKUPITPODLE(C12:D17;E12:E17;SUMA;;2)"}]
[{"$f":"ROW()","v":46},"Opava","M",30000]
[{"$f":"ROW()","v":47},"Opava","",50000]
[{"$f":"ROW()","v":48},"Ostrava","F",15000]
[{"$f":"ROW()","v":49},"Ostrava","M",27000]
[{"$f":"ROW()","v":50},"Ostrava","",42000]
[{"$f":"ROW()","v":51},"Celkový součet","",92000]
[]
[]
[]
[]
["https://office.lasakovi.com"]
["Pavel Lasák - 2024"]

{"sheet":"04_řazeni","index":4,"n_rows":53,"n_cols":16,"rows_kept":53,"cut":false,"hidden":false,"merged":[[44,5,44,9],[51,0,51,10],[52,0,52,10],[36,5,36,9],[37,5,37,9],[45,5,45,9],[0,0,0,10],[1,0,1,10],[20,5,20,9],[21,5,21,9],[28,5,28,9],[29,5,29,9]]}
["SESKUPITPODLE (GROUPBY) - součty, mezisoučty"]
["http://office.lasakovi.com"]
[]
[null,"Úkol"]
[]
[null,"Požadavek seskupení podle požadovaného sloupce a statistiku "]
[]
[null,"Zdrojová tabulka"]
[]
[null,"B","C","D","E","F","G","H"]
[{"$f":"ROW()","v":11},"ID","Město","Kat","Plat","Odměna","Jméno","Čas"]
[{"$f":"ROW()","v":12},1,"Opava","A",15000,10,"Pavel Lasák","15:10:00"]
[{"$f":"ROW()","v":13},2,"Ostrava","M",17000,20,"Karel Nový","16:20:00"]
[{"$f":"ROW()","v":14},3,"Opava","F",20000,30,"Iva Iva","11:10:00",null,null,null,null,"total_depth",null,"volitelný","Součty pro řádková pole"]
[{"$f":"ROW()","v":15},4,"Ostrava","M",10000,40,"Pavel Lasák","17:47:00",null,null,null,null,null,0,"Žádené součty"]
[{"$f":"ROW()","v":16},5,"Opava","Z",15000,50,"Karel Voršálek","05:01:00",null,null,null,null,null,1,"Celkové součty"]
[{"$f":"ROW()","v":17},6,"Ostrava","F",15000,60,"Jana Malá","05:01:00",null,null,null,null,null,2,"Celkové součty a mezisoučty"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,-1,"Celkové součty nahoře"]
[null,"Seřazení podle prvního sloupce"]
[]
[null,"B","C","D",null,"Funkce v buňce B22 "]
[{"$f":"ROW()","v":22},{"$f":"_xlfn.GROUPBY(D11:D17,E11:F17,_xleta.SUM,,0,1)","v":"A"},15000,10,null,{"$f":"_xlfn.FORMULATEXT(B22)","v":"=SESKUPITPODLE(D11:D17;E11:F17;SUMA;;0;1)"}]
[{"$f":"ROW()","v":23},"F",35000,90]
[{"$f":"ROW()","v":24},"M",27000,60]
[{"$f":"ROW()","v":25},"Z",15000,50]
[]
[null,"Seřazení podle druhého sloupce"]
[]
[null,"B","C","D",null,"Funkce v buňce B22 "]
[{"$f":"ROW()","v":30},{"$f":"_xlfn.GROUPBY(D11:D17,E11:F17,_xleta.SUM,,0,2)","v":"A"},15000,10,null,{"$f":"_xlfn.FORMULATEXT(B30)","v":"=SESKUPITPODLE(D11:D17;E11:F17;SUMA;;0;2)"}]
[{"$f":"ROW()","v":31},"Z",15000,50]
[{"$f":"ROW()","v":32},"M",27000,60]
[{"$f":"ROW()","v":33},"F",35000,90]
[]
[null,"Seřazení podle třetího sloupce"]
[]
[null,"B","C","D",null,"Funkce v buňce B22 "]
[{"$f":"ROW()","v":38},{"$f":"_xlfn.GROUPBY(D11:D17,E11:F17,_xleta.SUM,,0,3)","v":"A"},15000,10,null,{"$f":"_xlfn.FORMULATEXT(B38)","v":"=SESKUPITPODLE(D11:D17;E11:F17;SUMA;;0;3)"}]
[{"$f":"ROW()","v":39},"Z",15000,50]
[{"$f":"ROW()","v":40},"M",27000,60]
[{"$f":"ROW()","v":41},"F",35000,90]
[]
[null,"Seřazení podle třetího sloupce sestupně"]
[]
[null,"B","C","D",null,"Funkce v buňce B22 "]
[{"$f":"ROW()","v":46},{"$f":"_xlfn.GROUPBY(D11:D17,E11:F17,_xleta.SUM,,0,-3)","v":"F"},35000,90,null,{"$f":"_xlfn.FORMULATEXT(B46)","v":"=SESKUPITPODLE(D11:D17;E11:F17;SUMA;;0;-3)"}]
[{"$f":"ROW()","v":47},"M",27000,60]
[{"$f":"ROW()","v":48},"Z",15000,50]
[{"$f":"ROW()","v":49},"A",15000,10]
[]
[]
["https://office.lasakovi.com"]
["Pavel Lasák - 2024"]

{"sheet":"07_jazyky","index":5,"n_rows":52,"n_cols":15,"rows_kept":52,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,0,1,6],[50,0,50,6],[51,0,51,6]]}
["SESKUPITPODLE (GROUPBY)  - v jiných jazykových mutacích"]
["http://office.lasakovi.com"]
[]
[null,null,null,null,null,null,null,null,"DO.ŘÁDKU (TOCOL) - základy"]
[null,"Jak se funkce jmenuje v jiných jazycích"]
[]
[null,"Jazky","Název funkce","Poznámka"]
[null,"Angličtina","GROUPBY"]
[null,"Čeština","SESKUPITPODLE"]
[null,"Danština",null,null,null,null,null,null,"da-dk"]
[null,"Němčina",null,null,null,null,null,null,"de-de","hr-hr","chorvatština",null,"SEQUENCE"]
[null,"Španělština",null,null,null,null,null,null,"es-es",null,null,null,null,null,"norsko"]
[null,"Finština",null,null,null,null,null,null,"fi-fi",null,null,null,null,null,{"$error":"#VALUE!"}]
[null,"Francouzština",null,null,null,null,null,null,"fr-fr",null,null,null,null,null,{"$error":"#VALUE!"}]
[null,"Maďarština",null,null,null,null,null,null,"hu-hu",null,null,null,null,null,"švédsko"]
[null,"Italština",null,null,null,null,null,null,"it-it",null,null,null,null,null,"Portugalsko"]
[null,"Norština",null,null,null,null,null,null,"nb-no",null,null,null,null,null,{"$error":"#VALUE!"}]
[null,"Holandština",null,null,null,null,null,null,"nl-nl"]
[null,"Polština",null,null,null,null,null,null,"pl-pl"]
[null,"Portugalština",null,null,null,null,null,null,"pt-pt"]
[null,"Ruština",null,null,null,null,null,null,"ru-ru"]
[null,"Švedština",null,null,null,null,null,null,"sv-se"]
[null,"Turečtina",null,null,null,null,null,null,"tr-tr"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["https://office.lasakovi.com"]
["Pavel Lasák, revize 2023"]

{"sheet":"10_www","index":6,"n_rows":54,"n_cols":2,"rows_kept":54,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,0,1,6],[52,0,52,6],[53,0,53,6]]}
["SESKUPITPODLE (GROUPBY)  - web"]
["http://office.lasakovi.com"]
[]
[null,"Informace o funkci na webu"]
[]
[]
[null,"Funkce vyhledávací"]
[null,"https://office.lasakovi.com/excel/funkce-vyhledavaci/funkce-vyhledavaci-Excel/"]
[]
[]
[null,"Funkce SESKUPITPODLE (GROUPBY)  prakticky"]
[null,"https://office.lasakovi.com/excel/funkce-vyhledavaci/SESKUPITPODLE-GROUPBY-Excel/"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["https://office.lasakovi.com"]
["Pavel Lasák - revize 2023"]

{"sheet":"04_řazeni (2)","index":7,"n_rows":53,"n_cols":16,"rows_kept":53,"cut":false,"hidden":false,"merged":[[36,5,36,9],[37,5,37,9],[44,5,44,9],[45,5,45,9],[51,0,51,10],[52,0,52,10],[0,0,0,10],[1,0,1,10],[20,5,20,9],[21,5,21,9],[28,5,28,9],[29,5,29,9]]}
["SESKUPITPODLE (GROUPBY) - součty, mezisoučty"]
["http://office.lasakovi.com"]
[]
[null,"Úkol"]
[]
[null,"Požadavek seskupení podle požadovaného sloupce a statistiku "]
[]
[null,"Zdrojová tabulka"]
[]
[null,"B","C","D","E","F","G"]
[{"$f":"ROW()","v":11},"ID","Město","Kat","Plat","Odměna","Čas"]
[{"$f":"ROW()","v":12},1,"Opava","A",15000,10,"15:10:00"]
[{"$f":"ROW()","v":13},2,"Ostrava","M",17000,20,"16:20:00"]
[{"$f":"ROW()","v":14},3,"Opava","F",20000,30,"11:10:00",null,null,null,null,null,"total_depth",null,"volitelný","Součty pro řádková pole"]
[{"$f":"ROW()","v":15},4,"Ostrava","M",10000,40,"17:47:00",null,null,null,null,null,null,0,"Žádené součty"]
[{"$f":"ROW()","v":16},5,"Opava","Z",15000,50,"05:01:00",null,null,null,null,null,null,1,"Celkové součty"]
[{"$f":"ROW()","v":17},6,"Ostrava","F",15000,60,"05:01:00",null,null,null,null,null,null,2,"Celkové součty a mezisoučty"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,-1,"Celkové součty nahoře"]
[null,"Seřazení podle prvního sloupce"]
[]
[null,"B","C","D",null,"Funkce v buňce B22 "]
[{"$f":"ROW()","v":22},{"$f":"_xlfn.GROUPBY(D11:D17,E11:F17,_xleta.SUM,,0,1)","v":"A"},15000,10,null,{"$f":"_xlfn.FORMULATEXT(B22)","v":"=SESKUPITPODLE(D11:D17;E11:F17;SUMA;;0;1)"}]
[{"$f":"ROW()","v":23},"F",35000,90]
[{"$f":"ROW()","v":24},"M",27000,60]
[{"$f":"ROW()","v":25},"Z",15000,50]
[]
[null,"Seřazení podle druhého sloupce"]
[]
[null,"B","C","D",null,"Funkce v buňce B22 "]
[{"$f":"ROW()","v":30},{"$f":"_xlfn.GROUPBY(D11:D17,E11:F17,_xleta.SUM,,0,2)","v":"A"},15000,10,null,{"$f":"_xlfn.FORMULATEXT(B30)","v":"=SESKUPITPODLE(D11:D17;E11:F17;SUMA;;0;2)"}]
[{"$f":"ROW()","v":31},"Z",15000,50]
[{"$f":"ROW()","v":32},"M",27000,60]
[{"$f":"ROW()","v":33},"F",35000,90]
[]
[null,"Seřazení podle třetího sloupce"]
[]
[null,"B","C","D",null,"Funkce v buňce B22 "]
[{"$f":"ROW()","v":38},{"$f":"_xlfn.GROUPBY(D11:D17,E11:F17,_xleta.SUM,,0,3)","v":"A"},15000,10,null,{"$f":"_xlfn.FORMULATEXT(B38)","v":"=SESKUPITPODLE(D11:D17;E11:F17;SUMA;;0;3)"}]
[{"$f":"ROW()","v":39},"Z",15000,50]
[{"$f":"ROW()","v":40},"M",27000,60]
[{"$f":"ROW()","v":41},"F",35000,90]
[]
[null,"Seřazení podle třetího sloupce sestupně"]
[]
[null,"B","C","D",null,"Funkce v buňce B22 "]
[{"$f":"ROW()","v":46},{"$f":"_xlfn.GROUPBY(D11:D17,E11:F17,_xleta.SUM,,0,-3)","v":"F"},35000,90,null,{"$f":"_xlfn.FORMULATEXT(B46)","v":"=SESKUPITPODLE(D11:D17;E11:F17;SUMA;;0;-3)"}]
[{"$f":"ROW()","v":47},"M",27000,60]
[{"$f":"ROW()","v":48},"Z",15000,50]
[{"$f":"ROW()","v":49},"A",15000,10]
[]
[]
["https://office.lasakovi.com"]
["Pavel Lasák - 2024"]