{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Excel tipp","Adatok","LISTA"],"not_rendered":{"charts":0,"images":5,"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":"Excel tipp","index":0,"n_rows":160,"n_cols":17,"rows_kept":160,"cut":false,"hidden":false,"merged":[[141,9,141,16],[143,9,143,16],[129,9,129,16],[131,12,131,13],[131,15,131,16],[132,12,132,13],[132,15,132,16],[127,12,127,16],[109,12,109,13],[4,5,4,20],[2,6,2,19],[8,6,8,19],[6,6,6,8],[6,10,6,19],[37,6,37,19],[105,6,105,19],[120,12,120,13],[107,9,107,16],[118,9,118,16],[109,15,109,16],[120,15,120,16]]}
[]
[]
[null,null,null,null,null,null,"HOL.VAN függvény kiterjesztése VBA-ban (kezdő és haladó felhasználóknak is)"]
[]
[null,null,null,null,null,"E havi Excel tippünk bemutatja hogyan lehet kiegészíteni a rendelkezésre álló keresési és hivatkozási függvényeket VBA segítségével. A HOL.VAN függvény sokszor nagyon hasznos, de csak egy értéket tud visszaadni. A most bemutatott függvény abban különleges, hogy akár sorok és/vagy oszlopok szerint is megkeresi egy adott érték összes előfordulását. A függvény használatával nagyobb adattömbök átfésülése és képletes értelmezése is könnyebbé válik. A tipp bemutatja a VBA beállítását, a kód logikáját és a függvény használatát. A kódolást megismerni nem szükséges, kezdők és haladók számára is használható."]
[]
[null,null,null,null,null,null,"Az adatforrásról:",null,null,null,"Ezen a munkalapon kitalált adatok szemléltetik a függvény működését. Az Adatok munkalapon két mintapélda valós adatokon is mutat alkalmazási megoldást. Az adatok az ENSZ Élelmezésügyi és Mezőgazdasági Szervezetének adatait tartalmazza a világ búzatermelésére vonatkozóan 2020-ban. Az ezen munkalapon lévő adatok kitaláltak és véletlenszerűek."]
[]
[null,null,null,null,null,null,"Makróbarát munkafüzet és VBA előkészítése"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Függvény írása"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"A függvény használata"]
[]
[null,null,null,null,null,null,null,null,null,"1. HOL.VAN függvény használata röviden"]
[]
[null,null,null,null,null,null,null,null,null,"Austria",30,null,"HOL.VAN",null,null,"HOL.VAN + INDEX"]
[null,null,null,null,null,null,null,null,null,"Bangladesh",50,null,"Bangladesh",{"$f":"MATCH(M111,J110:J117,0)","v":2},null,{"$f":"J117","v":"Hungary"},{"$f":"INDEX(K110:K117,MATCH(P111,J110:J117,0))","v":40}]
[null,null,null,null,null,null,null,null,null,"Cameroon",20]
[null,null,null,null,null,null,null,null,null,"Denmark",60]
[null,null,null,null,null,null,null,null,null,"Ethiopia",70]
[null,null,null,null,null,null,null,null,null,"Finland",80]
[null,null,null,null,null,null,null,null,null,"Germany",50]
[null,null,null,null,null,null,null,null,null,"Hungary",40]
[]
[null,null,null,null,null,null,null,null,null,"2. Amikor a HOL.VAN nem működik"]
[]
[null,null,null,null,null,null,null,null,null,"Austria",30,null,"HOL.VAN",null,null,"HOL.VAN + INDEX"]
[null,null,null,null,null,null,null,null,null,"Austria",20,null,"Hungary",{"$f":"MATCH(M122,J121:J128,0)","v":6},null,{"$f":"J128","v":"Hungary"},{"$f":"INDEX(K121:K128,MATCH(P122,J121:J128,0))","v":10}]
[null,null,null,null,null,null,null,null,null,"Austria",60]
[null,null,null,null,null,null,null,null,null,"Austria",80]
[null,null,null,null,null,null,null,null,null,"Austria",40]
[null,null,null,null,null,null,null,null,null,"Hungary",10]
[null,null,null,null,null,null,null,null,null,"Hungary",100]
[null,null,null,null,null,null,null,null,null,"Hungary",70,null,"Csak egy érték jelenik meg, az első!"]
[]
[null,null,null,null,null,null,null,null,null,"3. Hogyan segít a MULTIHOLVAN?"]
[]
[null,null,null,null,null,null,null,null,null,"Austria",30,null,"MULTIHOLVAN",null,null,"MULTIHOLVAN + INDEX"]
[null,null,null,null,null,null,null,null,null,"Austria",20,null,"Hungary",null,null,"Hungary"]
[null,null,null,null,null,null,null,null,null,"Austria",60,null,{"$f":"MULTIHOLVAN(J132:K139,M133,0)","v":6},1,null,{"$f":"INDEX(J132:J139,MULTIHOLVAN(J132:K139,P133,1),MULTIHOLVAN(J132:K139,P133,-1))","v":"Hungary"},{"$f":"INDEX(K132:K139,MULTIHOLVAN(J132:K139,P133,1),MULTIHOLVAN(J132:K139,P133,-1))","v":10}]
[null,null,null,null,null,null,null,null,null,"Austria",80,null,7,1,null,"Hungary",100]
[null,null,null,null,null,null,null,null,null,"Austria",40,null,8,1,null,"Hungary",70]
[null,null,null,null,null,null,null,null,null,"Hungary",10]
[null,null,null,null,null,null,null,null,null,"Hungary",100]
[null,null,null,null,null,null,null,null,null,"Hungary",70]
[]
[]
[null,null,null,null,null,null,null,null,null,"A MULTIHOLVAN tömfüggvény, a bal felső cella szerkesztésekor Ctrl+Shift+Enter kombinációval jelennek meg a tömb elemei."]
[]
[null,null,null,null,null,null,null,null,null,"4. A MULTIHOLVAN paraméterei"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Készítette: Mozol Gábor Tamás (Gabor.Mozol@horvath-partners.com)"]

{"sheet":"Adatok","index":1,"n_rows":255,"n_cols":13,"rows_kept":255,"cut":false,"hidden":false,"merged":[[12,9,13,12],[5,9,6,12]]}
["Domain","Area","Element","Item","Year","Unit","Value"]
["Crops and livestock products","Afghanistan","Area harvested","Wheat",2020,"ha",2668000]
["Crops and livestock products","Afghanistan","Production","Wheat",2020,"tonnes",5185000]
["Crops and livestock products","Albania","Area harvested","Wheat",2020,"ha",53946]
["Crops and livestock products","Albania","Production","Wheat",2020,"tonnes",233430]
["Crops and livestock products","Algeria","Area harvested","Wheat",2020,"ha",1848083,null,null,"Mintapélda 1."]
["Crops and livestock products","Algeria","Production","Wheat",2020,"tonnes",3106754]
["Crops and livestock products","Angola","Area harvested","Wheat",2020,"ha",3289]
["Crops and livestock products","Angola","Production","Wheat",2020,"tonnes",2955,null,null,"Hungary"]
["Crops and livestock products","Argentina","Area harvested","Wheat",2020,"ha",6729838,null,null,{"$f":"INDEX(A1:G255,MULTIHOLVAN(A1:G255,J9,1),MULTIHOLVAN(A1:G255,J9,-1))","v":"Hungary"},{"$f":"INDEX(A1:G255,MULTIHOLVAN(A1:G255,J9,1),MULTIHOLVAN(A1:G255,J9,-1)+1)","v":"Area harvested"},{"$f":"INDEX(A1:G255,MULTIHOLVAN(A1:G255,J9,1),MULTIHOLVAN(A1:G255,J9,-1)+5)","v":936620},{"$f":"INDEX(A1:G255,MULTIHOLVAN(A1:G255,J9,1),MULTIHOLVAN(A1:G255,J9,-1)+4)","v":"ha"}]
["Crops and livestock products","Argentina","Production","Wheat",2020,"tonnes",19776942,null,null,"Hungary","Production",5121480,"tonnes"]
["Crops and livestock products","Armenia","Area harvested","Wheat",2020,"ha",58572]
["Crops and livestock products","Armenia","Production","Wheat",2020,"tonnes",131951,null,null,"Mintapélda 2."]
["Crops and livestock products","Australia","Area harvested","Wheat",2020,"ha",9863184]
["Crops and livestock products","Australia","Production","Wheat",2020,"tonnes",14480217]
["Crops and livestock products","Austria","Area harvested","Wheat",2020,"ha",279020,null,null,null,{"$f":"TRANSPOSE(INDEX(A1:G255,MULTIHOLVAN(A1:G255,J17,1),MULTIHOLVAN(A1:G255,J9,-1)+1))","v":"Area harvested"},"Production"]
["Crops and livestock products","Austria","Production","Wheat",2020,"tonnes",1652740,null,null,"Austria",{"$f":"TRANSPOSE(INDEX(A1:G255,MULTIHOLVAN(A1:G255,J17,1),MULTIHOLVAN(A1:G255,J9,-1)+5))","v":279020},1652740]
["Crops and livestock products","Azerbaijan","Area harvested","Wheat",2020,"ha",588415]
["Crops and livestock products","Azerbaijan","Production","Wheat",2020,"tonnes",1818665]
["Crops and livestock products","Bangladesh","Area harvested","Wheat",2020,"ha",332254]
["Crops and livestock products","Bangladesh","Production","Wheat",2020,"tonnes",1029000]
["Crops and livestock products","Belarus","Area harvested","Wheat",2020,"ha",722711]
["Crops and livestock products","Belarus","Production","Wheat",2020,"tonnes",2848391]
["Crops and livestock products","Belgium","Area harvested","Wheat",2020,"ha",194660]
["Crops and livestock products","Belgium","Production","Wheat",2020,"tonnes",1741480]
["Crops and livestock products","Bhutan","Area harvested","Wheat",2020,"ha",995]
["Crops and livestock products","Bhutan","Production","Wheat",2020,"tonnes",1623]
["Crops and livestock products","Bolivia (Plurinational State of)","Area harvested","Wheat",2020,"ha",204546]
["Crops and livestock products","Bolivia (Plurinational State of)","Production","Wheat",2020,"tonnes",311310]
["Crops and livestock products","Bosnia and Herzegovina","Area harvested","Wheat",2020,"ha",69914]
["Crops and livestock products","Bosnia and Herzegovina","Production","Wheat",2020,"tonnes",321804]
["Crops and livestock products","Botswana","Area harvested","Wheat",2020,"ha",755]
["Crops and livestock products","Botswana","Production","Wheat",2020,"tonnes",1028]
["Crops and livestock products","Brazil","Area harvested","Wheat",2020,"ha",2434703]
["Crops and livestock products","Brazil","Production","Wheat",2020,"tonnes",6347987]
["Crops and livestock products","Bulgaria","Area harvested","Wheat",2020,"ha",1200180]
["Crops and livestock products","Bulgaria","Production","Wheat",2020,"tonnes",4847940]
["Crops and livestock products","Burundi","Area harvested","Wheat",2020,"ha",12037]
["Crops and livestock products","Burundi","Production","Wheat",2020,"tonnes",8610]
["Crops and livestock products","Cameroon","Area harvested","Wheat",2020,"ha",328]
["Crops and livestock products","Cameroon","Production","Wheat",2020,"tonnes",437]
["Crops and livestock products","Canada","Area harvested","Wheat",2020,"ha",10017800]
["Crops and livestock products","Canada","Production","Wheat",2020,"tonnes",35183000]
["Crops and livestock products","Chad","Area harvested","Wheat",2020,"ha",1003]
["Crops and livestock products","Chad","Production","Wheat",2020,"tonnes",1815]
["Crops and livestock products","Chile","Area harvested","Wheat",2020,"ha",205036]
["Crops and livestock products","Chile","Production","Wheat",2020,"tonnes",1230988]
["Crops and livestock products","China","Area harvested","Wheat",2020,"ha",23382215]
["Crops and livestock products","China","Production","Wheat",2020,"tonnes",134254710]
["Crops and livestock products","China, mainland","Area harvested","Wheat",2020,"ha",23380000]
["Crops and livestock products","China, mainland","Production","Wheat",2020,"tonnes",134250000]
["Crops and livestock products","China, Taiwan Province of","Area harvested","Wheat",2020,"ha",2215]
["Crops and livestock products","China, Taiwan Province of","Production","Wheat",2020,"tonnes",4710]
["Crops and livestock products","Colombia","Area harvested","Wheat",2020,"ha",2535]
["Crops and livestock products","Colombia","Production","Wheat",2020,"tonnes",6295]
["Crops and livestock products","Croatia","Area harvested","Wheat",2020,"ha",147840]
["Crops and livestock products","Croatia","Production","Wheat",2020,"tonnes",867530]
["Crops and livestock products","Cyprus","Area harvested","Wheat",2020,"ha",12500]
["Crops and livestock products","Cyprus","Production","Wheat",2020,"tonnes",32270]
["Crops and livestock products","Czechia","Area harvested","Wheat",2020,"ha",798580]
["Crops and livestock products","Czechia","Production","Wheat",2020,"tonnes",4902410]
["Crops and livestock products","Democratic People's Republic of Korea","Area harvested","Wheat",2020,"ha",72395]
["Crops and livestock products","Democratic People's Republic of Korea","Production","Wheat",2020,"tonnes",89000]
["Crops and livestock products","Democratic Republic of the Congo","Area harvested","Wheat",2020,"ha",8000]
["Crops and livestock products","Democratic Republic of the Congo","Production","Wheat",2020,"tonnes",9000]
["Crops and livestock products","Denmark","Area harvested","Wheat",2020,"ha",502600]
["Crops and livestock products","Denmark","Production","Wheat",2020,"tonnes",4070410]
["Crops and livestock products","Ecuador","Area harvested","Wheat",2020,"ha",6698]
["Crops and livestock products","Ecuador","Production","Wheat",2020,"tonnes",14647]
["Crops and livestock products","Egypt","Area harvested","Wheat",2020,"ha",1370235]
["Crops and livestock products","Egypt","Production","Wheat",2020,"tonnes",9000000]
["Crops and livestock products","Eritrea","Area harvested","Wheat",2020,"ha",25000]
["Crops and livestock products","Eritrea","Production","Wheat",2020,"tonnes",25000]
["Crops and livestock products","Estonia","Area harvested","Wheat",2020,"ha",168040]
["Crops and livestock products","Estonia","Production","Wheat",2020,"tonnes",840520]
["Crops and livestock products","Eswatini","Area harvested","Wheat",2020,"ha",378]
["Crops and livestock products","Eswatini","Production","Wheat",2020,"tonnes",715]
["Crops and livestock products","Ethiopia","Area harvested","Wheat",2020,"ha",1829051]
["Crops and livestock products","Ethiopia","Production","Wheat",2020,"tonnes",5478709]
["Crops and livestock products","Finland","Area harvested","Wheat",2020,"ha",198800]
["Crops and livestock products","Finland","Production","Wheat",2020,"tonnes",686620]
["Crops and livestock products","France","Area harvested","Wheat",2020,"ha",4512420]
["Crops and livestock products","France","Production","Wheat",2020,"tonnes",30144110]
["Crops and livestock products","Georgia","Area harvested","Wheat",2020,"ha",46500]
["Crops and livestock products","Georgia","Production","Wheat",2020,"tonnes",102400]
["Crops and livestock products","Germany","Area harvested","Wheat",2020,"ha",2835500]
["Crops and livestock products","Germany","Production","Wheat",2020,"tonnes",22172100]
["Crops and livestock products","Greece","Area harvested","Wheat",2020,"ha",355880]
["Crops and livestock products","Greece","Production","Wheat",2020,"tonnes",1095150]
["Crops and livestock products","Guatemala","Area harvested","Wheat",2020,"ha",390]
["Crops and livestock products","Guatemala","Production","Wheat",2020,"tonnes",835]
["Crops and livestock products","Honduras","Area harvested","Wheat",2020,"ha",2297]
["Crops and livestock products","Honduras","Production","Wheat",2020,"tonnes",1244]
["Crops and livestock products","Hungary","Area harvested","Wheat",2020,"ha",936620]
["Crops and livestock products","Hungary","Production","Wheat",2020,"tonnes",5121480]
["Crops and livestock products","India","Area harvested","Wheat",2020,"ha",31357000]
["Crops and livestock products","India","Production","Wheat",2020,"tonnes",107590000]
["Crops and livestock products","Iran (Islamic Republic of)","Area harvested","Wheat",2020,"ha",7584358]
["Crops and livestock products","Iran (Islamic Republic of)","Production","Wheat",2020,"tonnes",15000000]
["Crops and livestock products","Iraq","Area harvested","Wheat",2020,"ha",2143421]
["Crops and livestock products","Iraq","Production","Wheat",2020,"tonnes",6238392]
["Crops and livestock products","Ireland","Area harvested","Wheat",2020,"ha",46990]
["Crops and livestock products","Ireland","Production","Wheat",2020,"tonnes",364920]
["Crops and livestock products","Israel","Area harvested","Wheat",2020,"ha",50710]
["Crops and livestock products","Israel","Production","Wheat",2020,"tonnes",116691]
["Crops and livestock products","Italy","Area harvested","Wheat",2020,"ha",1711220]
["Crops and livestock products","Italy","Production","Wheat",2020,"tonnes",6716180]
["Crops and livestock products","Japan","Area harvested","Wheat",2020,"ha",212600]
["Crops and livestock products","Japan","Production","Wheat",2020,"tonnes",949300]
["Crops and livestock products","Jordan","Area harvested","Wheat",2020,"ha",10926]
["Crops and livestock products","Jordan","Production","Wheat",2020,"tonnes",21746]
["Crops and livestock products","Kazakhstan","Area harvested","Wheat",2020,"ha",12057071]
["Crops and livestock products","Kazakhstan","Production","Wheat",2020,"tonnes",14257950]
["Crops and livestock products","Kenya","Area harvested","Wheat",2020,"ha",132231]
["Crops and livestock products","Kenya","Production","Wheat",2020,"tonnes",404700]
["Crops and livestock products","Kuwait","Area harvested","Wheat",2020,"ha",10]
["Crops and livestock products","Kuwait","Production","Wheat",2020,"tonnes",68]
["Crops and livestock products","Kyrgyzstan","Area harvested","Wheat",2020,"ha",247028]
["Crops and livestock products","Kyrgyzstan","Production","Wheat",2020,"tonnes",629052]
["Crops and livestock products","Latvia","Area harvested","Wheat",2020,"ha",498200]
["Crops and livestock products","Latvia","Production","Wheat",2020,"tonnes",2659600]
["Crops and livestock products","Lebanon","Area harvested","Wheat",2020,"ha",41000]
["Crops and livestock products","Lebanon","Production","Wheat",2020,"tonnes",140000]
["Crops and livestock products","Lesotho","Area harvested","Wheat",2020,"ha",8000]
["Crops and livestock products","Lesotho","Production","Wheat",2020,"tonnes",8000]
["Crops and livestock products","Libya","Area harvested","Wheat",2020,"ha",168497]
["Crops and livestock products","Libya","Production","Wheat",2020,"tonnes",130000]
["Crops and livestock products","Lithuania","Area harvested","Wheat",2020,"ha",893510]
["Crops and livestock products","Lithuania","Production","Wheat",2020,"tonnes",4818750]
["Crops and livestock products","Luxembourg","Area harvested","Wheat",2020,"ha",11930]
["Crops and livestock products","Luxembourg","Production","Wheat",2020,"tonnes",72400]
["Crops and livestock products","Madagascar","Area harvested","Wheat",2020,"ha",417]
["Crops and livestock products","Madagascar","Production","Wheat",2020,"tonnes",1000]
["Crops and livestock products","Malawi","Area harvested","Wheat",2020,"ha",551]
["Crops and livestock products","Malawi","Production","Wheat",2020,"tonnes",697]
["Crops and livestock products","Mali","Area harvested","Wheat",2020,"ha",7000]
["Crops and livestock products","Mali","Production","Wheat",2020,"tonnes",37124]
["Crops and livestock products","Malta","Area harvested","Wheat",2020,"ha",0]
["Crops and livestock products","Malta","Production","Wheat",2020,"tonnes",0]
["Crops and livestock products","Mauritania","Area harvested","Wheat",2020,"ha",4224]
["Crops and livestock products","Mauritania","Production","Wheat",2020,"tonnes",8942]
["Crops and livestock products","Mexico","Area harvested","Wheat",2020,"ha",561282]
["Crops and livestock products","Mexico","Production","Wheat",2020,"tonnes",2986689]
["Crops and livestock products","Mongolia","Area harvested","Wheat",2020,"ha",328831]
["Crops and livestock products","Mongolia","Production","Wheat",2020,"tonnes",406129]
["Crops and livestock products","Montenegro","Area harvested","Wheat",2020,"ha",763]
["Crops and livestock products","Montenegro","Production","Wheat",2020,"tonnes",2339]
["Crops and livestock products","Morocco","Area harvested","Wheat",2020,"ha",2845290]
["Crops and livestock products","Morocco","Production","Wheat",2020,"tonnes",2561898]
["Crops and livestock products","Mozambique","Area harvested","Wheat",2020,"ha",13034]
["Crops and livestock products","Mozambique","Production","Wheat",2020,"tonnes",15000]
["Crops and livestock products","Myanmar","Area harvested","Wheat",2020,"ha",59246]
["Crops and livestock products","Myanmar","Production","Wheat",2020,"tonnes",111215]
["Crops and livestock products","Namibia","Area harvested","Wheat",2020,"ha",2000]
["Crops and livestock products","Namibia","Production","Wheat",2020,"tonnes",12000]
["Crops and livestock products","Nepal","Area harvested","Wheat",2020,"ha",707505]
["Crops and livestock products","Nepal","Production","Wheat",2020,"tonnes",2185289]
["Crops and livestock products","Netherlands","Area harvested","Wheat",2020,"ha",108910]
["Crops and livestock products","Netherlands","Production","Wheat",2020,"tonnes",931830]
["Crops and livestock products","New Caledonia","Area harvested","Wheat",2020,"ha",72]
["Crops and livestock products","New Caledonia","Production","Wheat",2020,"tonnes",54]
["Crops and livestock products","New Zealand","Area harvested","Wheat",2020,"ha",45680]
["Crops and livestock products","New Zealand","Production","Wheat",2020,"tonnes",453749]
["Crops and livestock products","Niger","Area harvested","Wheat",2020,"ha",1650]
["Crops and livestock products","Niger","Production","Wheat",2020,"tonnes",4276]
["Crops and livestock products","Nigeria","Area harvested","Wheat",2020,"ha",50000]
["Crops and livestock products","Nigeria","Production","Wheat",2020,"tonnes",55000]
["Crops and livestock products","North Macedonia","Area harvested","Wheat",2020,"ha",69765]
["Crops and livestock products","North Macedonia","Production","Wheat",2020,"tonnes",246031]
["Crops and livestock products","Norway","Area harvested","Wheat",2020,"ha",80000]
["Crops and livestock products","Norway","Production","Wheat",2020,"tonnes",303000]
["Crops and livestock products","Oman","Area harvested","Wheat",2020,"ha",1131]
["Crops and livestock products","Oman","Production","Wheat",2020,"tonnes",2865]
["Crops and livestock products","Pakistan","Area harvested","Wheat",2020,"ha",8804677]
["Crops and livestock products","Pakistan","Production","Wheat",2020,"tonnes",25247511]
["Crops and livestock products","Palestine","Area harvested","Wheat",2020,"ha",15147]
["Crops and livestock products","Palestine","Production","Wheat",2020,"tonnes",34374]
["Crops and livestock products","Paraguay","Area harvested","Wheat",2020,"ha",480800]
["Crops and livestock products","Paraguay","Production","Wheat",2020,"tonnes",1302870]
["Crops and livestock products","Peru","Area harvested","Wheat",2020,"ha",114224]
["Crops and livestock products","Peru","Production","Wheat",2020,"tonnes",187851]
["Crops and livestock products","Poland","Area harvested","Wheat",2020,"ha",2373310]
["Crops and livestock products","Poland","Production","Wheat",2020,"tonnes",12433210]
["Crops and livestock products","Portugal","Area harvested","Wheat",2020,"ha",30140]
["Crops and livestock products","Portugal","Production","Wheat",2020,"tonnes",83500]
["Crops and livestock products","Qatar","Area harvested","Wheat",2020,"ha",1]
["Crops and livestock products","Qatar","Production","Wheat",2020,"tonnes",2]
["Crops and livestock products","Republic of Korea","Area harvested","Wheat",2020,"ha",5224]
["Crops and livestock products","Republic of Korea","Production","Wheat",2020,"tonnes",16985]
["Crops and livestock products","Republic of Moldova","Area harvested","Wheat",2020,"ha",300341]
["Crops and livestock products","Republic of Moldova","Production","Wheat",2020,"tonnes",569735]
["Crops and livestock products","Romania","Area harvested","Wheat",2020,"ha",2281690]
["Crops and livestock products","Romania","Production","Wheat",2020,"tonnes",6754530]
["Crops and livestock products","Russian Federation","Area harvested","Wheat",2020,"ha",28864312]
["Crops and livestock products","Russian Federation","Production","Wheat",2020,"tonnes",85896326]
["Crops and livestock products","Rwanda","Area harvested","Wheat",2020,"ha",12309]
["Crops and livestock products","Rwanda","Production","Wheat",2020,"tonnes",12811]
["Crops and livestock products","Saudi Arabia","Area harvested","Wheat",2020,"ha",86983]
["Crops and livestock products","Saudi Arabia","Production","Wheat",2020,"tonnes",554562]
["Crops and livestock products","Serbia","Area harvested","Wheat",2020,"ha",581128]
["Crops and livestock products","Serbia","Production","Wheat",2020,"tonnes",2873503]
["Crops and livestock products","Slovakia","Area harvested","Wheat",2020,"ha",387080]
["Crops and livestock products","Slovakia","Production","Wheat",2020,"tonnes",2133330]
["Crops and livestock products","Slovenia","Area harvested","Wheat",2020,"ha",27280]
["Crops and livestock products","Slovenia","Production","Wheat",2020,"tonnes",158130]
["Crops and livestock products","Somalia","Area harvested","Wheat",2020,"ha",2615]
["Crops and livestock products","Somalia","Production","Wheat",2020,"tonnes",1043]
["Crops and livestock products","South Africa","Area harvested","Wheat",2020,"ha",509800]
["Crops and livestock products","South Africa","Production","Wheat",2020,"tonnes",2109100]
["Crops and livestock products","South Sudan","Area harvested","Wheat",2020,"ha"]
["Crops and livestock products","South Sudan","Production","Wheat",2020,"tonnes"]
["Crops and livestock products","Spain","Area harvested","Wheat",2020,"ha",1914660]
["Crops and livestock products","Spain","Production","Wheat",2020,"tonnes",8143510]
["Crops and livestock products","Sudan","Area harvested","Wheat",2020,"ha",321444]
["Crops and livestock products","Sudan","Production","Wheat",2020,"tonnes",750821]
["Crops and livestock products","Sweden","Area harvested","Wheat",2020,"ha",449170]
["Crops and livestock products","Sweden","Production","Wheat",2020,"tonnes",3214300]
["Crops and livestock products","Switzerland","Area harvested","Wheat",2020,"ha",84787]
["Crops and livestock products","Switzerland","Production","Wheat",2020,"tonnes",527496]
["Crops and livestock products","Syrian Arab Republic","Area harvested","Wheat",2020,"ha",1350538]
["Crops and livestock products","Syrian Arab Republic","Production","Wheat",2020,"tonnes",2848472]
["Crops and livestock products","Tajikistan","Area harvested","Wheat",2020,"ha",268400]
["Crops and livestock products","Tajikistan","Production","Wheat",2020,"tonnes",846000]
["Crops and livestock products","Thailand","Area harvested","Wheat",2020,"ha",1223]
["Crops and livestock products","Thailand","Production","Wheat",2020,"tonnes",1423]
["Crops and livestock products","Tunisia","Area harvested","Wheat",2020,"ha",606000]
["Crops and livestock products","Tunisia","Production","Wheat",2020,"tonnes",1042000]
["Crops and livestock products","Turkey","Area harvested","Wheat",2020,"ha",6914632]
["Crops and livestock products","Turkey","Production","Wheat",2020,"tonnes",20500000]
["Crops and livestock products","Turkmenistan","Area harvested","Wheat",2020,"ha",800000]
["Crops and livestock products","Turkmenistan","Production","Wheat",2020,"tonnes",1320000]
["Crops and livestock products","Uganda","Area harvested","Wheat",2020,"ha",16209]
["Crops and livestock products","Uganda","Production","Wheat",2020,"tonnes",25000]
["Crops and livestock products","Ukraine","Area harvested","Wheat",2020,"ha",6564500]
["Crops and livestock products","Ukraine","Production","Wheat",2020,"tonnes",24912350]
["Crops and livestock products","United Arab Emirates","Area harvested","Wheat",2020,"ha"]
["Crops and livestock products","United Arab Emirates","Production","Wheat",2020,"tonnes"]
["Crops and livestock products","United Kingdom of Great Britain and Northern Ireland","Area harvested","Wheat",2020,"ha",1387000]
["Crops and livestock products","United Kingdom of Great Britain and Northern Ireland","Production","Wheat",2020,"tonnes",9658000]
["Crops and livestock products","United Republic of Tanzania","Area harvested","Wheat",2020,"ha",60000]
["Crops and livestock products","United Republic of Tanzania","Production","Wheat",2020,"tonnes",77000]
["Crops and livestock products","United States of America","Area harvested","Wheat",2020,"ha",14870740]
["Crops and livestock products","United States of America","Production","Wheat",2020,"tonnes",49690680]
["Crops and livestock products","Uruguay","Area harvested","Wheat",2020,"ha",237500]
["Crops and livestock products","Uruguay","Production","Wheat",2020,"tonnes",776300]
["Crops and livestock products","Uzbekistan","Area harvested","Wheat",2020,"ha",1351717]
["Crops and livestock products","Uzbekistan","Production","Wheat",2020,"tonnes",6157844]
["Crops and livestock products","Venezuela (Bolivarian Republic of)","Area harvested","Wheat",2020,"ha",223]
["Crops and livestock products","Venezuela (Bolivarian Republic of)","Production","Wheat",2020,"tonnes",684]
["Crops and livestock products","Yemen","Area harvested","Wheat",2020,"ha",57218]
["Crops and livestock products","Yemen","Production","Wheat",2020,"tonnes",100860]
["Crops and livestock products","Zambia","Area harvested","Wheat",2020,"ha",26007]
["Crops and livestock products","Zambia","Production","Wheat",2020,"tonnes",191620]
["Crops and livestock products","Zimbabwe","Area harvested","Wheat",2020,"ha",82068]
["Crops and livestock products","Zimbabwe","Production","Wheat",2020,"tonnes",150000]

{"sheet":"LISTA","index":2,"n_rows":128,"n_cols":6,"rows_kept":128,"cut":false,"hidden":true,"merged":[]}
[]
[null,{"$f":"'Excel tipp'!J110","v":"Austria"},null,{"$f":"_xlfn.UNIQUE('Excel tipp'!J121:J128)","v":"Austria"},null,{"$f":"_xlfn.UNIQUE(Adatok!B2:B255)","v":"Afghanistan"}]
[null,{"$f":"'Excel tipp'!J111","v":"Bangladesh"},null,"Hungary",null,"Albania"]
[null,{"$f":"'Excel tipp'!J112","v":"Cameroon"},null,null,null,"Algeria"]
[null,{"$f":"'Excel tipp'!J113","v":"Denmark"},null,null,null,"Angola"]
[null,{"$f":"'Excel tipp'!J114","v":"Ethiopia"},null,null,null,"Argentina"]
[null,{"$f":"'Excel tipp'!J115","v":"Finland"},null,null,null,"Armenia"]
[null,{"$f":"'Excel tipp'!J116","v":"Germany"},null,null,null,"Australia"]
[null,{"$f":"'Excel tipp'!J117","v":"Hungary"},null,null,null,"Austria"]
[null,null,null,null,null,"Azerbaijan"]
[null,null,null,null,null,"Bangladesh"]
[null,null,null,null,null,"Belarus"]
[null,null,null,null,null,"Belgium"]
[null,null,null,null,null,"Bhutan"]
[null,null,null,null,null,"Bolivia (Plurinational State of)"]
[null,null,null,null,null,"Bosnia and Herzegovina"]
[null,null,null,null,null,"Botswana"]
[null,null,null,null,null,"Brazil"]
[null,null,null,null,null,"Bulgaria"]
[null,null,null,null,null,"Burundi"]
[null,null,null,null,null,"Cameroon"]
[null,null,null,null,null,"Canada"]
[null,null,null,null,null,"Chad"]
[null,null,null,null,null,"Chile"]
[null,null,null,null,null,"China"]
[null,null,null,null,null,"China, mainland"]
[null,null,null,null,null,"China, Taiwan Province of"]
[null,null,null,null,null,"Colombia"]
[null,null,null,null,null,"Croatia"]
[null,null,null,null,null,"Cyprus"]
[null,null,null,null,null,"Czechia"]
[null,null,null,null,null,"Democratic People's Republic of Korea"]
[null,null,null,null,null,"Democratic Republic of the Congo"]
[null,null,null,null,null,"Denmark"]
[null,null,null,null,null,"Ecuador"]
[null,null,null,null,null,"Egypt"]
[null,null,null,null,null,"Eritrea"]
[null,null,null,null,null,"Estonia"]
[null,null,null,null,null,"Eswatini"]
[null,null,null,null,null,"Ethiopia"]
[null,null,null,null,null,"Finland"]
[null,null,null,null,null,"France"]
[null,null,null,null,null,"Georgia"]
[null,null,null,null,null,"Germany"]
[null,null,null,null,null,"Greece"]
[null,null,null,null,null,"Guatemala"]
[null,null,null,null,null,"Honduras"]
[null,null,null,null,null,"Hungary"]
[null,null,null,null,null,"India"]
[null,null,null,null,null,"Iran (Islamic Republic of)"]
[null,null,null,null,null,"Iraq"]
[null,null,null,null,null,"Ireland"]
[null,null,null,null,null,"Israel"]
[null,null,null,null,null,"Italy"]
[null,null,null,null,null,"Japan"]
[null,null,null,null,null,"Jordan"]
[null,null,null,null,null,"Kazakhstan"]
[null,null,null,null,null,"Kenya"]
[null,null,null,null,null,"Kuwait"]
[null,null,null,null,null,"Kyrgyzstan"]
[null,null,null,null,null,"Latvia"]
[null,null,null,null,null,"Lebanon"]
[null,null,null,null,null,"Lesotho"]
[null,null,null,null,null,"Libya"]
[null,null,null,null,null,"Lithuania"]
[null,null,null,null,null,"Luxembourg"]
[null,null,null,null,null,"Madagascar"]
[null,null,null,null,null,"Malawi"]
[null,null,null,null,null,"Mali"]
[null,null,null,null,null,"Malta"]
[null,null,null,null,null,"Mauritania"]
[null,null,null,null,null,"Mexico"]
[null,null,null,null,null,"Mongolia"]
[null,null,null,null,null,"Montenegro"]
[null,null,null,null,null,"Morocco"]
[null,null,null,null,null,"Mozambique"]
[null,null,null,null,null,"Myanmar"]
[null,null,null,null,null,"Namibia"]
[null,null,null,null,null,"Nepal"]
[null,null,null,null,null,"Netherlands"]
[null,null,null,null,null,"New Caledonia"]
[null,null,null,null,null,"New Zealand"]
[null,null,null,null,null,"Niger"]
[null,null,null,null,null,"Nigeria"]
[null,null,null,null,null,"North Macedonia"]
[null,null,null,null,null,"Norway"]
[null,null,null,null,null,"Oman"]
[null,null,null,null,null,"Pakistan"]
[null,null,null,null,null,"Palestine"]
[null,null,null,null,null,"Paraguay"]
[null,null,null,null,null,"Peru"]
[null,null,null,null,null,"Poland"]
[null,null,null,null,null,"Portugal"]
[null,null,null,null,null,"Qatar"]
[null,null,null,null,null,"Republic of Korea"]
[null,null,null,null,null,"Republic of Moldova"]
[null,null,null,null,null,"Romania"]
[null,null,null,null,null,"Russian Federation"]
[null,null,null,null,null,"Rwanda"]
[null,null,null,null,null,"Saudi Arabia"]
[null,null,null,null,null,"Serbia"]
[null,null,null,null,null,"Slovakia"]
[null,null,null,null,null,"Slovenia"]
[null,null,null,null,null,"Somalia"]
[null,null,null,null,null,"South Africa"]
[null,null,null,null,null,"South Sudan"]
[null,null,null,null,null,"Spain"]
[null,null,null,null,null,"Sudan"]
[null,null,null,null,null,"Sweden"]
[null,null,null,null,null,"Switzerland"]
[null,null,null,null,null,"Syrian Arab Republic"]
[null,null,null,null,null,"Tajikistan"]
[null,null,null,null,null,"Thailand"]
[null,null,null,null,null,"Tunisia"]
[null,null,null,null,null,"Turkey"]
[null,null,null,null,null,"Turkmenistan"]
[null,null,null,null,null,"Uganda"]
[null,null,null,null,null,"Ukraine"]
[null,null,null,null,null,"United Arab Emirates"]
[null,null,null,null,null,"United Kingdom of Great Britain and Northern Ireland"]
[null,null,null,null,null,"United Republic of Tanzania"]
[null,null,null,null,null,"United States of America"]
[null,null,null,null,null,"Uruguay"]
[null,null,null,null,null,"Uzbekistan"]
[null,null,null,null,null,"Venezuela (Bolivarian Republic of)"]
[null,null,null,null,null,"Yemen"]
[null,null,null,null,null,"Zambia"]
[null,null,null,null,null,"Zimbabwe"]