{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["(1043)","(1043an)","Time","(1044)","(1044an)","(1045)","(1045an)","(1046)","(1046an)"],"not_rendered":{"charts":0,"images":2,"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":"(1043)","index":0,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Numbers",null,"Unique Number Count Formula",null,"Same Time"," =SUM(IF(FREQUENCY(A2:A15,A2:A15),1))"]
[3,null,null,null,"Same Time"," =SUM(SIGN(FREQUENCY(A2:A15,A2:A15)))",null,null,null,"Leonid Koyfman from YouTube"]
[4,null,null,null,"Same Time"," =SUMPRODUCT(--(FREQUENCY(A2:A15,A2:A15)>0))"]
[4,null,{"$f":"SUMPRODUCT(--(FREQUENCY(A2:A15,A2:A15)>0))","v":5},null,"Same Time"," =SUMPRODUCT(--(FREQUENCY(A2:A15,A2:A15)>0))"]
[5,null,null,null,"Same Time"," =SUM(--(FREQUENCY(A2:A15,A2:A15)>0))"]
[3,null,{"$f":"SUMPRODUCT(1/COUNTIF(A2:A15,A2:A15),--ISNUMBER(A2:A15))","v":4.9999999999999991},null,"Much Longer"," =SUMPRODUCT(1/COUNTIF(A2:A15,A2:A15),--ISNUMBER(A2:A15))"]
[4,null,null,null,"Excel Magic Trick 1042 Array Functions Housed In Other Functions Usually Don't Need Ctrl Shift Enter "]
[5,null,"Unique List:"]
[null,null,{"$f":"IF(ROWS(C$9:C9)>C$2,\"\",LARGE(IF(FREQUENCY(IF(ISNUMBER($A$2:$A$15),MATCH($A$2:$A$15,$A$2:$A$15,0)),ROW($A$2:$A$15)-ROW($A$2)+1),$A$2:$A$15),ROWS(C$9:C9)))","v":""},null,"Videos on Extract Unique List:"]
[0,null,{"$f":"IF(ROWS(C$9:C10)>C$2,\"\",LARGE(IF(FREQUENCY(IF(ISNUMBER($A$2:$A$15),MATCH($A$2:$A$15,$A$2:$A$15,0)),ROW($A$2:$A$15)-ROW($A$2)+1),$A$2:$A$15),ROWS(C$9:C10)))","v":""},null,"Excel Magic Trick 1044 (Next Video)"]
["DNQ",null,{"$f":"IF(ROWS(C$9:C11)>C$2,\"\",LARGE(IF(FREQUENCY(IF(ISNUMBER($A$2:$A$15),MATCH($A$2:$A$15,$A$2:$A$15,0)),ROW($A$2:$A$15)-ROW($A$2)+1),$A$2:$A$15),ROWS(C$9:C11)))","v":""},null,"Excel Magic Trick 1040: Formula To Extract & Sort A Unique List Of Numbers, No Empty Cells Or Text "]
[-1,null,{"$f":"IF(ROWS(C$9:C12)>C$2,\"\",LARGE(IF(FREQUENCY(IF(ISNUMBER($A$2:$A$15),MATCH($A$2:$A$15,$A$2:$A$15,0)),ROW($A$2:$A$15)-ROW($A$2)+1),$A$2:$A$15),ROWS(C$9:C12)))","v":""},null,"Excel Magic Trick 473: Extract Unique Records with Formula (Complex Array Formula) "]
[-1,null,{"$f":"IF(ROWS(C$9:C13)>C$2,\"\",LARGE(IF(FREQUENCY(IF(ISNUMBER($A$2:$A$15),MATCH($A$2:$A$15,$A$2:$A$15,0)),ROW($A$2:$A$15)-ROW($A$2)+1),$A$2:$A$15),ROWS(C$9:C13)))","v":""},null,"Excel 2010 Magic Trick 817: Extract Unique List of Values For Dynamic Data Validation Drop Down List "]
[0,null,{"$f":"IF(ROWS(C$9:C14)>C$2,\"\",LARGE(IF(FREQUENCY(IF(ISNUMBER($A$2:$A$15),MATCH($A$2:$A$15,$A$2:$A$15,0)),ROW($A$2:$A$15)-ROW($A$2)+1),$A$2:$A$15),ROWS(C$9:C14)))","v":""},null,"Excel Magic Trick 759: Array Formula To Sort List & Remove Duplicates - Dynamic Named Range "]
[5,null,{"$f":"IF(ROWS(C$9:C15)>C$2,\"\",LARGE(IF(FREQUENCY(IF(ISNUMBER($A$2:$A$15),MATCH($A$2:$A$15,$A$2:$A$15,0)),ROW($A$2:$A$15)-ROW($A$2)+1),$A$2:$A$15),ROWS(C$9:C15)))","v":""},null,"Video all about FREQUENCY:"]
[null,null,null,null,"Excel Magic Trick 627: FREQUENCY Array Function (10 Examples) "]
[]
[]
[]
[null,null,{"$f":"SUM(--(FREQUENCY(A2:A15,A2:A15)>0))","v":5}]

{"sheet":"(1043an)","index":1,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Numbers",null,"Unique Number Count Formula",null,"Same Time"," =SUM(IF(FREQUENCY(A2:A15,A2:A15),1))"]
[3,null,{"$f":"SUM(IF(FREQUENCY(A2:A15,A2:A15),1))","v":5},null,"Same Time"," =SUM(SIGN(FREQUENCY(A2:A15,A2:A15)))",null,null,null,"Leonid Koyfman from YouTube"]
[4,null,{"$f":"SUM(SIGN(FREQUENCY(A2:A15,A2:A15)))","v":5},null,"Same Time"," =SUMPRODUCT(--(FREQUENCY(A2:A15,A2:A15)>0))"]
[4,null,{"$f":"SUMPRODUCT(--(FREQUENCY(A2:A15,A2:A15)>0))","v":5},null,"Same Time"," =SUMPRODUCT(--(FREQUENCY(A2:A15,A2:A15)>0))"]
[5,null,{"$f":"SUM(--(FREQUENCY(A2:A15,A2:A15)>0))","v":5},null,"Same Time"," =SUM(--(FREQUENCY(A2:A15,A2:A15)>0))"]
[3,null,{"$f":"SUMPRODUCT(1/COUNTIF(A2:A15,A2:A15),--ISNUMBER(A2:A15))","v":4.9999999999999991},null,"Much Longer"," =SUMPRODUCT(1/COUNTIF(A2:A15,A2:A15),--ISNUMBER(A2:A15))"]
[4,null,null,null,"Excel Magic Trick 1042 Array Functions Housed In Other Functions Usually Don't Need Ctrl Shift Enter "]
[5,null,"Unique List:"]
[null,null,{"$f":"IF(ROWS(C$9:C9)>C$2,\"\",LARGE(IF(FREQUENCY(IF(ISNUMBER($A$2:$A$15),MATCH($A$2:$A$15,$A$2:$A$15,0)),ROW($A$2:$A$15)-ROW($A$2)+1),$A$2:$A$15),ROWS(C$9:C9)))","v":5},null,"Videos on Extract Unique List:"]
[0,null,{"$f":"IF(ROWS(C$9:C10)>C$2,\"\",LARGE(IF(FREQUENCY(IF(ISNUMBER($A$2:$A$15),MATCH($A$2:$A$15,$A$2:$A$15,0)),ROW($A$2:$A$15)-ROW($A$2)+1),$A$2:$A$15),ROWS(C$9:C10)))","v":4},null,"Excel Magic Trick 1044 (Next Video)"]
["DNQ",null,{"$f":"IF(ROWS(C$9:C11)>C$2,\"\",LARGE(IF(FREQUENCY(IF(ISNUMBER($A$2:$A$15),MATCH($A$2:$A$15,$A$2:$A$15,0)),ROW($A$2:$A$15)-ROW($A$2)+1),$A$2:$A$15),ROWS(C$9:C11)))","v":3},null,"Excel Magic Trick 1040: Formula To Extract & Sort A Unique List Of Numbers, No Empty Cells Or Text "]
[-1,null,{"$f":"IF(ROWS(C$9:C12)>C$2,\"\",LARGE(IF(FREQUENCY(IF(ISNUMBER($A$2:$A$15),MATCH($A$2:$A$15,$A$2:$A$15,0)),ROW($A$2:$A$15)-ROW($A$2)+1),$A$2:$A$15),ROWS(C$9:C12)))","v":0},null,"Excel Magic Trick 473: Extract Unique Records with Formula (Complex Array Formula) "]
[-1,null,{"$f":"IF(ROWS(C$9:C13)>C$2,\"\",LARGE(IF(FREQUENCY(IF(ISNUMBER($A$2:$A$15),MATCH($A$2:$A$15,$A$2:$A$15,0)),ROW($A$2:$A$15)-ROW($A$2)+1),$A$2:$A$15),ROWS(C$9:C13)))","v":-1},null,"Excel 2010 Magic Trick 817: Extract Unique List of Values For Dynamic Data Validation Drop Down List "]
[0,null,{"$f":"IF(ROWS(C$9:C14)>C$2,\"\",LARGE(IF(FREQUENCY(IF(ISNUMBER($A$2:$A$15),MATCH($A$2:$A$15,$A$2:$A$15,0)),ROW($A$2:$A$15)-ROW($A$2)+1),$A$2:$A$15),ROWS(C$9:C14)))","v":""},null,"Excel Magic Trick 759: Array Formula To Sort List & Remove Duplicates - Dynamic Named Range "]
[5,null,{"$f":"IF(ROWS(C$9:C15)>C$2,\"\",LARGE(IF(FREQUENCY(IF(ISNUMBER($A$2:$A$15),MATCH($A$2:$A$15,$A$2:$A$15,0)),ROW($A$2:$A$15)-ROW($A$2)+1),$A$2:$A$15),ROWS(C$9:C15)))","v":""},null,"Video all about FREQUENCY:"]
[null,null,null,null,"Excel Magic Trick 627: FREQUENCY Array Function (10 Examples) "]
[]
[]
[]
[null,null,{"$f":"SUM(--(FREQUENCY(A2:A15,A2:A15)>0))","v":5}]
[null,null,{"$f":"SUM(--(FREQUENCY(A2:A15,A2:A15)>0))","v":5}]

{"sheet":"Time","index":2,"n_rows":100001,"n_cols":8,"rows_kept":4500,"cut":true,"hidden":false,"merged":[],"bounds":{"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0}}
["Numbers",null,"Unique Number Count Formula",null,"Time 1","Time 2","Time 3","Ave"]
[224718,null,{"$f":"SUM(IF(FREQUENCY(A2:A100001,A2:A100001),1))","v":85111}," =SUM(IF(FREQUENCY(A2:A100001,A2:A100001),1))",7.1769999999999996,6.9370000000000003,6.95,{"$f":"AVERAGE(E2:G2)","v":7.0213333333333336}]
[34285,null,{"$f":"SUM(SIGN(FREQUENCY(A2:A100001,A2:A100001)))","v":85111}," =SUM(SIGN(FREQUENCY(A2:A100001,A2:A100001)))",7.18,6.9470000000000001,6.94,7.0223333333333331]
[231942,null,{"$f":"SUMPRODUCT(--(FREQUENCY(A2:A100001,A2:A100001)>0))","v":85111}," =SUMPRODUCT(--(FREQUENCY(A2:A100001,A2:A100001)>0))",7.1840000000000002,6.9379999999999997,6.9489999999999998,7.0236666666666663]
[237653,null,{"$f":"SUM(--(FREQUENCY(A2:A100001,A2:A100001)>0))","v":85111}," =SUM(--(FREQUENCY(A2:A100001,A2:A100001)>0))",7.19,6.95,6.94,7.0266666666666673]
[161432]
[115155]
[116424]
[130315]
[217418]
[249388]
[230979]
[269852]
[81382]
[5446]
[131147]
[154469,null," =SUMPRODUCT(1/COUNTIF(A2:A100001,A2:A100001),--ISNUMBER(A2:A100001))"]
[165257,null,"Takes more time to calculate than I am willing to wait."]
[229373]
[157563]
[276546]
[33100]
[31540]
[72910]
[246858]
[160621]
[170125]
[56564]
[31932]
[148771]
[12043]
[145432]
[48241]
[107824]
[156820]
[156158]
[136780]
[126197]
[217054]
[140322]
[255654]
[97662]
[18645]
[106837]
[46416]
[259413]
[71804]
[131248]
[163562]
[261060]
[250785]
[291918]
[229754]
[182800]
[163518]
[198816]
[177403]
[236403]
[81246]
[175351]
[271932]
[128104]
[261915]
[74581]
[163756]
[149792]
[99053]
[297260]
[46680]
[221281]
[210756]
[111269]
[278657]
[37285]
[164310]
[30995]
[75874]
[174065]
[26132]
[281396]
[292072]
[91615]
[8629]
[243515]
[90359]
[261045]
[90746]
[85496]
[50288]
[291703]
[105159]
[34321]
[157622]
[61489]
[99153]
[131857]
[133038]
[218783]
[14464]
[3558]
[102082]
[147813]
[106953]
[253855]
[35789]
[187070]
[80074]
[102262]
[181217]
[293019]
[48240]
[86284]
[50026]
[193441]
[195456]
[132309]
[173504]
[174555]
[248596]
[174675]
[254007]
[55459]
[106297]
[190732]
[223778]
[90233]
[189576]
[227642]
[215270]
[146162]
[218810]
[1110]
[71199]
[4491]
[189929]
[3267]
[103018]
[284481]
[166870]
[22292]
[9369]
[93346]
[151895]
[56988]
[219199]
[40000]
[196125]
[210494]
[133539]
[205843]
[183338]
[137716]
[10994]
[292142]
[253390]
[169694]
[266547]
[125151]
[117384]
[225191]
[134082]
[231054]
[202318]
[152172]
[171946]
[246498]
[223599]
[288350]
[264039]
[251350]
[92134]
[292301]
[69916]
[289013]
[270990]
[280932]
[4693]
[264043]
[223409]
[206961]
[276863]
[107699]
[5402]
[116251]
[99542]
[36201]
[21662]
[251000]
[154387]
[142048]
[222279]
[75707]
[33675]
[177475]
[35419]
[267728]
[291115]
[45982]
[95462]
[141229]
[235128]
[57884]
[250966]
[216445]
[171342]
[236363]
[114557]
[295270]
[94991]
[155271]
[144713]
[112121]
[295634]
[238089]
[21755]
[242091]
[76009]
[150437]
[236705]
[285862]
[212269]
[103730]
[1213]
[202072]
[266444]
[123499]
[298608]
[264905]
[91481]
[12432]
[81873]
[67502]
[28470]
[273655]
[200639]
[111482]
[136776]
[268189]
[223754]
[56746]
[49800]
[108839]
[24465]
[205670]
[120003]
[13645]
[104254]
[198781]
[163405]
[144929]
[274919]
[195323]
[284683]
[51146]
[39644]
[84574]
[169890]
[88068]
[11521]
[126605]
[119241]
[212711]
[119477]
[234126]
[79030]
[229495]
[20544]
[43321]
[135699]
[39180]
[117280]
[239062]
[213006]
[160349]
[161228]
[103715]
[266514]
[268204]
[51543]
[299832]
[36343]
[243069]
[177747]
[227283]
[197450]
[232096]
[159032]
[152469]
[26600]
[180776]
[54082]
[39178]
[113335]
[175735]
[163717]
[78337]
[48658]
[158699]
[118655]
[133590]
[110358]
[185564]
[91609]
[48385]
[179806]
[227413]
[283381]
[216511]
[119845]
[94658]
[35135]
[100065]
[189333]
[44255]
[990]
[182925]
[211645]
[136403]
[85041]
[220252]
[285486]
[119111]
[182663]
[11383]
[293346]
[225809]
[125435]
[262895]
[125723]
[127319]
[145749]
[83065]
[143715]
[30254]
[36179]
[163923]
[220557]
[2080]
[278555]
[130845]
[140362]
[120450]
[101481]
[196671]
[168731]
[41415]
[205898]
[146291]
[296606]
[153424]
[213360]
[189423]
[118849]
[250990]
[106574]
[109486]
[188086]
[129304]
[10599]
[38605]
[200411]
[158096]
[4164]
[28049]
[29640]
[67241]
[76606]
[56357]
[84206]
[18380]
[104636]
[48334]
[30195]
[87638]
[99359]
[125217]
[208273]
[89543]
[117027]
[163048]
[193124]
[96275]
[258822]
[134328]
[196184]
[261240]
[206158]
[260104]
[15987]
[183670]
[102087]
[256486]
[113496]
[254649]
[109287]
[155966]
[140553]
[38177]
[42369]
[230973]
[53678]
[33169]
[83666]
[216187]
[186103]
[152622]
[143459]
[244609]
[202659]
[168051]
[46042]
[123075]
[282999]
[9892]
[90247]
[90312]
[77404]
[256137]
[188834]
[211390]
[30574]
[12373]
[48944]
[106162]
[182767]
[132636]
[129477]
[259014]
[299701]
[49401]
[103614]
[104261]
[63540]
[271099]
[117030]
[242866]
[298262]
[57330]
[11238]
[79539]
[72373]
[233362]
[207019]
[299060]
[250370]
[56669]
[101502]
[3332]
[107584]
[216544]
[202081]
[105957]
[258958]
[244987]
[93582]
[187034]
[37449]
[180426]
[292631]
[202862]
[61666]
[2497]
[287731]
[215998]
[201578]
[219114]
[106672]
[152478]
[253929]
[70736]
[242639]
[120572]
[254811]
[189918]
[125886]
[4398]
[56492]
[87398]
[283137]
[51991]
[151772]
[261269]
[223363]
[48164]
[277394]
[97414]
[187879]
[21148]
[157123]
[135287]
[222109]
[51512]
[181439]
[134890]
[71665]
[264698]
[37418]
[268354]
[164075]
[76717]
[281754]
[143036]
[1091]
[237583]
[115998]
[263426]
[187262]
[139635]
[83248]
[228883]
[168049]
[145165]
[298517]
[133983]
[200374]
[189046]
[114515]
[112012]
[170975]
[15822]
[139195]
[26841]
[253833]
[88405]
[124463]
[110511]
[203903]
[4348]
[37931]
[141259]
[127817]
[43928]
[34556]
[224129]
[29562]
[31135]
[53783]
[98724]
[6805]
[94185]
[22128]
[103406]
[296454]
[23379]
[143817]
[287331]
[70742]
[257356]
[12186]
[53237]
[132576]
[283793]
[99943]
[234218]
[274536]
[59491]
[16548]
[201923]
[215829]
[87854]
[252865]
[286602]
[90503]
[81183]
[101636]
[50095]
[89445]
[12736]
[5539]
[278829]
[201693]
[265347]
[226258]
[293154]
[3103]
[68340]
[159093]
[172078]
[232436]
[43264]
[99828]
[169983]
[278031]
[175753]
[202546]
[210450]
[24949]
[238219]
[279191]
[135830]
[150242]
[112634]
[128888]
[265190]
[109027]
[246720]
[216037]
[157355]
[190520]
[204208]
[192492]
[50008]
[232141]
[21047]
[23091]
[50697]
[69652]
[189593]
[67179]
[231478]
[38762]
[13867]
[204460]
[229010]
[272192]
[161690]
[109225]
[122175]
[59027]
[124682]
[53611]
[17277]
[207363]
[22194]
[98631]
[118086]
[33919]
[123187]
[181360]
[41958]
[265563]
[120082]
[59013]
[109019]
[51076]
[124359]
[81573]
[129007]
[287315]
[199748]
[173146]
[85889]
[92237]
[259075]
[228620]
[11199]
[252159]
[133296]
[229442]
[231982]
[46598]
[138389]
[92598]
[36526]
[169348]
[31517]
[98674]
[226491]
[47089]
[151885]
[89789]
[196529]
[208673]
[82871]
[175500]
[89053]
[175703]
[28958]
[119279]
[39837]
[14549]
[273376]
[95475]
[174891]
[17437]
[287533]
[162505]
[112930]
[147453]
[268913]
[82769]
[104183]
[176021]
[231233]
[204066]
[216876]
[45017]
[199444]
[212563]
[298436]
[189752]
[43535]
[280378]
[10505]
[86697]
[4809]
[223790]
[241132]
[187007]
[100350]
[232508]
[93013]
[49931]
[178547]
[4659]
[928]
[171703]
[134276]
[76578]
[184737]
[142227]
[134947]
[167738]
[287197]
[107601]
[80910]
[199692]
[63797]
[155719]
[85095]
[35704]
[169999]
[257288]
[152161]
[19830]
[127191]
[204849]
[278409]
[193720]
[222185]
[12199]
[4358]
[213438]
[125201]
[92191]
[253497]
[142782]
[214994]
[187618]
[9137]
[283801]
[126444]
[224614]
[57380]
[110286]
[226409]
[143016]
[127438]
[74209]
[123449]
[153450]
[178254]
[238837]
[254105]
[20504]
[237149]
[44724]
[262798]
[6926]
[6389]
[120172]
[31528]
[43951]
[172868]
[206246]
[97963]
[92550]
[194849]
[111567]
[237724]
[177752]
[274428]
[74835]
[16413]
[47056]
[121787]
[176772]
[258572]
[80354]
[140146]
[1560]
[297692]
[167978]
[192694]
[25866]
[288453]
[280241]
[135861]
[270633]
[232738]
[124285]
[180724]
[245984]
[220941]
[159531]
[94295]
[96338]
[109860]
[162826]
[5189]
[112664]
[265021]
[22292]
[16836]
[253633]
[146055]
[268956]
[3426]
[297602]
[135835]
[86890]
[172926]
[217034]
[186225]
[294496]
[40300]
[296414]
[285151]
[155888]
[244324]
[225219]
[168983]
[171007]
[290002]
[131862]
[285854]
[246337]
[243604]
[40483]
[206320]
[232098]
[66731]
[190862]
[131864]
[166544]
[285153]
[272168]
[132058]
[43503]
[131446]
[234593]
[245944]
[83560]
[46468]
[224897]
[253734]
[90168]
[265950]
[53483]
[181446]
[36925]
[22710]
[56302]
[181294]
[11385]
[279953]
[230257]
[198548]
[87140]
[259552]
[15491]
[72487]
[263710]
[154909]
[252661]
[279197]
[156607]
[234611]
[150506]
[67236]
[282893]
[297582]
[183134]
[111965]
[197283]
[133413]
[144420]
[151742]
[217034]
[144788]
[111127]
[168085]
[237911]
[176174]
[152458]
[56444]
[157842]
[16649]
[115107]
[265869]
[117902]
[261048]
[205397]
[231279]
[217969]
[75669]
[154920]
[283354]
[257709]
[242689]
[37106]
[31624]
[26884]
[45778]
[210277]
[70471]
[178298]
[94629]
[39290]
[136246]
[17891]
[71972]
[162382]
[35115]
[131782]
[37444]
[247394]
[231250]
[75480]
[299415]
[268706]
[198919]
[245904]
[43230]
[171234]
[24567]
[81168]
[152823]
[54125]
[43159]
[127640]
[235169]
[26420]
[274863]
[242869]
[207446]
[224610]
[17497]
[174464]
[164044]
[198139]
[62769]
[206909]
[96130]
[225318]
[196678]
[155236]
[296466]
[141450]
[14257]
[78744]
[145776]
[171002]
[167663]
[211951]
[111162]
[50862]
[337]
[183782]
[43564]
[74011]
[70234]
[58067]
[226510]
[78374]
[140164]
[243714]
[106546]
[208700]
[39725]
[240567]
[10920]
[47437]
[200931]
[6082]
[22822]
[39809]
[40993]
[47396]
[211122]
[145179]
[255059]
[107349]
[79611]
[206849]
[127512]
[154774]
[71491]
[292668]
[278553]
[45696]
[284649]
[62534]
[26932]
[88719]
[23826]
[178542]
[245351]
[196258]
[285695]
[209218]
[184481]
[113292]
[292523]
[82454]
[287990]
[57381]
[151899]
[290079]
[232128]
[294902]
[155087]
[204010]
[218378]
[245923]
[38690]
[54555]
[192788]
[148226]
[169390]
[265099]
[97703]
[96911]
[140652]
[132649]
[156254]
[265937]
[156549]
[160601]
[71122]
[261615]
[274780]
[268525]
[192017]
[137435]
[276311]
[109221]
[87734]
[125286]
[158081]
[115360]
[280266]
[202505]
[270301]
[23387]
[57448]
[174952]
[14593]
[6849]
[65893]
[270780]
[232823]
[165880]
[87043]
[24204]
[297164]
[163]
[55591]
[161163]
[203493]
[200034]
[102970]
[135632]
[134496]
[36869]
[33127]
[124225]
[277717]
[260197]
[254742]
[115841]
[263532]
[123034]
[148891]
[161010]
[241930]
[263580]
[188574]
[188261]
[18297]
[150088]
[13176]
[165292]
[216266]
[56680]
[112942]
[80586]
[24547]
[229409]
[193300]
[143547]
[66540]
[84930]
[121161]
[145210]
[69425]
[199324]
[89355]
[9111]
[159436]
[24059]
[6070]
[206587]
[49068]
[111819]
[271416]
[58187]
[23755]
[56550]
[98165]
[57952]
[112749]
[102992]
[115035]
[76292]
[269287]
[186111]
[83386]
[7158]
[211966]
[256509]
[292002]
[47346]
[65641]
[268125]
[97269]
[36378]
[23264]
[172608]
[270814]
[37787]
[123211]
[245261]
[164270]
[111877]
[276076]
[149593]
[267661]
[102454]
[216885]
[29424]
[18748]
[242701]
[16747]
[289906]
[168685]
[21056]
[35610]
[222430]
[256458]
[212583]
[76519]
[141442]
[139883]
[173269]
[167712]
[166838]
[39829]
[17240]
[214925]
[152494]
[184434]
[73190]
[104379]
[255221]
[110142]
[198064]
[150702]
[184976]
[223978]
[177726]
[176603]
[20132]
[201694]
[215469]
[133155]
[114976]
[204016]
[78368]
[139119]
[60435]
[227324]
[242555]
[150074]
[272173]
[33473]
[211814]
[248674]
[170776]
[94405]
[117041]
[197829]
[107263]
[234847]
[227890]
[65804]
[269752]
[29273]
[130524]
[16771]
[88695]
[271788]
[51167]
[133958]
[51249]
[967]
[245077]
[115441]
[164043]
[137154]
[141018]
[255683]
[126345]
[290014]
[41419]
[157725]
[69931]
[156009]
[222723]
[78181]
[236608]
[196445]
[220490]
[241139]
[246623]
[72250]
[95352]
[163583]
[287450]
[177446]
[260217]
[154155]
[199343]
[102728]
[59091]
[141090]
[95622]
[18306]
[172506]
[203344]
[292748]
[217786]
[163758]
[264200]
[68893]
[211604]
[160156]
[63188]
[238149]
[266712]
[139139]
[260144]
[244374]
[145934]
[74828]
[198483]
[33684]
[269169]
[296637]
[214337]
[86821]
[113423]
[74857]
[186205]
[206107]
[209453]
[168688]
[288553]
[78685]
[46599]
[95300]
[174314]
[2353]
[68227]
[140727]
[270482]
[57547]
[25774]
[252953]
[157368]
[59995]
[37942]
[112565]
[205962]
[294907]
[67239]
[161679]
[71058]
[198735]
[94751]
[61024]
[30725]
[162793]
[81733]
[52540]
[154083]
[267717]
[248541]
[159588]
[162905]
[158060]
[170731]
[9579]
[32494]
[174078]
[38901]
[171314]
[124654]
[226953]
[148230]
[126388]
[160251]
[264666]
[266422]
[258970]
[230729]
[148392]
[73872]
[8889]
[257760]
[132715]
[232994]
[207259]
[216333]
[158411]
[16320]
[102980]
[57274]
[264827]
[298978]
[213455]
[90478]
[145474]
[72759]
[208888]
[121663]
[114010]
[24949]
[226582]
[287368]
[92679]
[288505]
[171141]
[13426]
[46044]
[74672]
[124299]
[153151]
[272524]
[143743]
[268218]
[140814]
[18289]
[116754]
[10300]
[175271]
[79469]
[182457]
[109904]
[128455]
[82785]
[215058]
[180214]
[261100]
[64865]
[153767]
[4718]
[166749]
[156832]
[280589]
[2781]
[97849]
[168142]
[142559]
[218553]
[156471]
[28325]
[120967]
[7332]
[18751]
[269983]
[172670]
[13720]
[118559]
[20106]
[85294]
[213947]
[115173]
[169326]
[269254]
[272213]
[246405]
[296454]
[155858]
[24548]
[79457]
[184953]
[211205]
[190049]
[281151]
[166722]
[126571]
[39442]
[156884]
[172548]
[753]
[135256]
[69442]
[154584]
[281276]
[145120]
[158436]
[252063]
[249975]
[250405]
[35717]
[139048]
[116600]
[36904]
[179716]
[8826]
[74702]
[86719]
[174484]
[46529]
[112233]
[11562]
[73856]
[120220]
[204626]
[34649]
[104925]
[41146]
[121826]
[173526]
[239598]
[16782]
[260877]
[114183]
[243507]
[133409]
[170934]
[32102]
[77775]
[22214]
[263836]
[13806]
[260515]
[270609]
[40272]
[272363]
[158860]
[242590]
[221718]
[238038]
[252695]
[102725]
[99243]
[213913]
[274328]
[282864]
[74571]
[133314]
[70631]
[250466]
[51693]
[157966]
[95919]
[131304]
[106182]
[77209]
[80728]
[214348]
[285874]
[70258]
[26909]
[170318]
[81603]
[173168]
[22738]
[191097]
[209209]
[5458]
[195741]
[209565]
[289389]
[220338]
[262855]
[245830]
[30236]
[204865]
[50530]
[120884]
[72327]
[203756]
[251776]
[165208]
[67806]
[222415]
[213149]
[109133]
[77341]
[152321]
[289682]
[251836]
[291051]
[236645]
[162075]
[88251]
[253835]
[43227]
[118467]
[235690]
[20738]
[166768]
[241489]
[81034]
[279128]
[181722]
[5059]
[42423]
[239577]
[102386]
[97544]
[122576]
[165052]
[243958]
[189633]
[1561]
[173689]
[298680]
[256330]
[148160]
[37811]
[92039]
[152533]
[279934]
[217216]
[117008]
[279761]
[94657]
[168300]
[126548]
[105148]
[186784]
[46109]
[255607]
[144650]
[3953]
[280759]
[89222]
[292287]
[215844]
[170955]
[23894]
[254585]
[115305]
[280703]
[13392]
[210291]
[179899]
[285131]
[266144]
[210881]
[299298]
[248064]
[66603]
[52721]
[220780]
[199297]
[54579]
[224889]
[248966]
[52443]
[88175]
[144737]
[66774]
[296823]
[113634]
[73937]
[259733]
[262845]
[5294]
[238315]
[198618]
[260015]
[244516]
[33034]
[252331]
[245749]
[177455]
[140174]
[30241]
[77946]
[225990]
[247165]
[255482]
[203510]
[299266]
[213545]
[123406]
[49342]
[275984]
[134945]
[141372]
[249215]
[187285]
[99278]
[257275]
[57116]
[213445]
[27504]
[193304]
[212445]
[48541]
[25696]
[266343]
[204001]
[140236]
[111516]
[98002]
[49972]
[237611]
[194149]
[62288]
[94615]
[159393]
[110188]
[268409]
[36624]
[38084]
[30427]
[296395]
[205441]
[119747]
[78343]
[98404]
[233506]
[207423]
[29996]
[67403]
[191440]
[4724]
[209612]
[153778]
[193820]
[252566]
[206920]
[137319]
[245465]
[180681]
[46294]
[245391]
[54566]
[128263]
[260352]
[169785]
[50453]
[244404]
[218921]
[122663]
[81778]
[49366]
[235265]
[33718]
[84835]
[256291]
[110024]
[147891]
[284954]
[19221]
[262666]
[82370]
[76466]
[3128]
[74129]
[108412]
[71435]
[14814]
[67920]
[226961]
[294432]
[40817]
[261670]
[206201]
[299411]
[119960]
[200305]
[211801]
[44872]
[24428]
[215346]
[139574]
[161704]
[111681]
[148973]
[196576]
[207768]
[250132]
[175991]
[60253]
[242677]
[94114]
[201915]
[24894]
[200500]
[67177]
[189614]
[187189]
[137808]
[212657]
[55422]
[19832]
[16568]
[158517]
[191008]
[142542]
[11342]
[96744]
[289347]
[85303]
[227019]
[123450]
[175158]
[103399]
[209354]
[184330]
[55566]
[84628]
[227985]
[286759]
[90693]
[126167]
[101092]
[119855]
[175561]
[133063]
[170311]
[263998]
[280001]
[55919]
[147584]
[89134]
[122643]
[126149]
[108005]
[133484]
[260725]
[93831]
[253009]
[128748]
[164954]
[133273]
[294789]
[67472]
[256657]
[11794]
[209239]
[55561]
[240285]
[165396]
[253106]
[293216]
[205083]
[147553]
[147526]
[80576]
[109956]
[235220]
[261946]
[225470]
[280329]
[72289]
[7282]
[3201]
[120590]
[185334]
[240618]
[149632]
[18643]
[247161]
[144299]
[281212]
[293]
[88267]
[73588]
[10453]
[276943]
[157174]
[39948]
[9630]
[181301]
[200808]
[81878]
[100179]
[290809]
[199416]
[39713]
[8273]
[64222]
[299513]
[133195]
[203953]
[13964]
[42555]
[154152]
[112834]
[107014]
[223912]
[175255]
[94627]
[164721]
[5115]
[222543]
[253781]
[225416]
[199639]
[65527]
[282469]
[41566]
[197116]
[195460]
[266073]
[145305]
[141250]
[107453]
[126858]
[195486]
[259416]
[289477]
[58797]
[252063]
[246966]
[77826]
[84034]
[187150]
[70670]
[282594]
[248490]
[237543]
[134905]
[63211]
[198436]
[250519]
[263344]
[10100]
[193712]
[213398]
[208994]
[61337]
[209687]
[216022]
[180471]
[59107]
[31561]
[50261]
[82100]
[25506]
[213562]
[77044]
[195098]
[137251]
[98003]
[15472]
[118601]
[189498]
[259657]
[127670]
[119992]
[87458]
[99861]
[214430]
[187570]
[25394]
[2444]
[173478]
[219935]
[84613]
[102543]
[734]
[32455]
[115246]
[55594]
[135463]
[238746]
[268826]
[7216]
[147688]
[158321]
[119379]
[60346]
[231944]
[15284]
[115724]
[162385]
[11272]
[269977]
[203786]
[287892]
[229629]
[89188]
[228713]
[298625]
[258904]
[253358]
[154019]
[76778]
[272105]
[223637]
[210774]
[156838]
[13489]
[78165]
[199524]
[261290]
[121929]
[282690]
[197447]
[81784]
[92236]
[212139]
[224661]
[37359]
[47729]
[11089]
[14321]
[180419]
[253438]
[228514]
[292025]
[19185]
[38186]
[197585]
[12554]
[29112]
[296277]
[277935]
[144459]
[223971]
[176749]
[276023]
[125571]
[49547]
[33871]
[129038]
[164906]
[232582]
[62398]
[99345]
[243858]
[157146]
[278433]
[164452]
[49391]
[198270]
[120172]
[27668]
[72285]
[285289]
[102703]
[272649]
[91814]
[223858]
[202225]
[67160]
[85519]
[233241]
[204229]
[534]
[7569]
[155418]
[237352]
[26172]
[61247]
[113032]
[298401]
[104544]
[14921]
[216758]
[102525]
[197637]
[234224]
[168533]
[287843]
[40901]
[196456]
[65436]
[187405]
[262606]
[191934]
[38808]
[293501]
[40294]
[188034]
[96359]
[204178]
[35135]
[31425]
[193097]
[100714]
[289463]
[131490]
[236276]
[60571]
[65331]
[253772]
[261613]
[256708]
[48411]
[70373]
[150175]
[80929]
[123785]
[255402]
[298548]
[71484]
[193208]
[136029]
[137286]
[239672]
[31683]
[129944]
[67122]
[91835]
[158029]
[203338]
[206206]
[22819]
[288952]
[204791]
[231024]
[51256]
[21457]
[246917]
[149120]
[161933]
[203912]
[63617]
[135196]
[49200]
[199594]
[279601]
[40445]
[89569]
[240787]
[218699]
[170162]
[222043]
[114952]
[278530]
[39280]
[78232]
[223570]
[131433]
[126565]
[276945]
[39681]
[165271]
[35715]
[284421]
[198965]
[202083]
[265589]
[276187]
[298558]
[86824]
[15624]
[282438]
[281606]
[15893]
[203762]
[272600]
[217085]
[217735]
[237031]
[20541]
[291480]
[114446]
[249193]
[214533]
[29392]
[79643]
[184026]
[151998]
[13693]
[222473]
[39536]
[180231]
[94931]
[239295]
[56395]
[294484]
[286872]
[239507]
[164052]
[288766]
[88123]
[153753]
[203392]
[288558]
[297876]
[8608]
[122509]
[287461]
[96494]
[175263]
[56366]
[66745]
[69037]
[150634]
[167447]
[297848]
[281396]
[140776]
[295629]
[196436]
[238445]
[224853]
[185907]
[113787]
[164917]
[144615]
[296908]
[61154]
[152150]
[8562]
[269735]
[165521]
[213794]
[3788]
[240901]
[275151]
[254477]
[236637]
[280735]
[65625]
[42970]
[232728]
[23873]
[167101]
[84938]
[54457]
[139913]
[201255]
[19914]
[78067]
[179371]
[280737]
[135431]
[252758]
[247581]
[71049]
[241648]
[99818]
[55985]
[104924]
[114671]
[202057]
[8405]
[183571]
[209992]
[290453]
[238846]
[247457]
[39508]
[139012]
[256179]
[158980]
[280398]
[87286]
[206838]
[215519]
[93863]
[292132]
[113996]
[130849]
[33400]
[286478]
[197526]
[165678]
[201973]
[109507]
[78025]
[37974]
[255027]
[250717]
[85528]
[209398]
[70811]
[292334]
[162137]
[94949]
[179655]
[291483]
[935]
[150353]
[184530]
[273858]
[192185]
[128812]
[137819]
[77066]
[293907]
[60161]
[57180]
[36105]
[170600]
[285490]
[269398]
[122620]
[202623]
[12777]
[160702]
[184506]
[93058]
[219305]
[255618]
[37007]
[61238]
[42725]
[214663]
[266233]
[206802]
[72037]
[289292]
[214473]
[104192]
[216683]
[168836]
[125332]
[168033]
[75462]
[288314]
[127945]
[35711]
[265022]
[90415]
[171195]
[118454]
[228563]
[90698]
[291542]
[59814]
[206440]
[214077]
[80562]
[120891]
[261273]
[104724]
[35660]
[143350]
[220445]
[250440]
[189263]
[99957]
[110020]
[176937]
[16884]
[169873]
[67515]
[280080]
[77635]
[171343]
[266012]
[139883]
[2093]
[227650]
[5725]
[240795]
[48107]
[231333]
[212744]
[3326]
[274096]
[243373]
[195465]
[154068]
[44568]
[57112]
[122654]
[195915]
[155786]
[42862]
[258199]
[196356]
[66804]
[258881]
[7845]
[286165]
[28736]
[50571]
[98469]
[150454]
[91422]
[15935]
[211820]
[179364]
[236774]
[101790]
[78939]
[93317]
[128001]
[269652]
[292912]
[185723]
[297069]
[114623]
[86737]
[29735]
[182383]
[265969]
[41140]
[86750]
[233750]
[25255]
[93206]
[95298]
[12290]
[232006]
[118556]
[255801]
[224394]
[108634]
[38029]
[236821]
[115647]
[197749]
[238982]
[57727]
[227568]
[161755]
[295465]
[99897]
[228851]
[249455]
[254482]
[206883]
[201036]
[127335]
[117200]
[72379]
[279726]
[8061]
[208982]
[49616]
[268956]
[219903]
[159910]
[186252]
[92142]
[93113]
[285999]
[73854]
[202390]
[44617]
[248457]
[217226]
[294197]
[250166]
[264223]
[161618]
[214313]
[70141]
[114892]
[1301]
[190767]
[211035]
[9735]
[279551]
[3721]
[176175]
[226269]
[203017]
[82258]
[119969]
[187937]
[206128]
[297661]
[208935]
[242872]
[227567]
[193982]
[216329]
[122811]
[110467]
[51606]
[114095]
[166734]
[4003]
[260234]
[16446]
[222800]
[36169]
[272151]
[252597]
[286548]
[154480]
[278124]
[202685]
[28735]
[247224]
[99728]
[258260]
[48620]
[56841]
[205677]
[54197]
[121656]
[244088]
[262388]
[157787]
[78520]
[221032]
[132291]
[257692]
[188601]
[46204]
[31879]
[191901]
[33296]
[201514]
[289090]
[202409]
[100921]
[122579]
[79681]
[241379]
[295908]
[117529]
[1698]
[63405]
[281575]
[143150]
[61189]
[133099]
[230301]
[104152]
[194331]
[109197]
[3266]
[178537]
[232083]
[142142]
[216336]
[274620]
[240391]
[122055]
[156439]
[82036]
[138227]
[248298]
[27302]
[181398]
[283472]
[202805]
[209348]
[27527]
[254014]
[233546]
[44205]
[65144]
[270018]
[18529]
[32778]
[243513]
[255103]
[146322]
[220410]
[52576]
[191749]
[18510]
[146798]
[223299]
[88461]
[293029]
[1721]
[56807]
[208170]
[270214]
[206080]
[282343]
[272128]
[158309]
[201759]
[188509]
[158872]
[244014]
[110200]
[132942]
[226013]
[258802]
[175397]
[43783]
[168744]
[100675]
[119197]
[210495]
[168521]
[296812]
[50933]
[287634]
[109837]
[52253]
[123461]
[11691]
[207652]
[242304]
[1548]
[192441]
[34449]
[110128]
[184411]
[182515]
[72135]
[172530]
[194696]
[148353]
[9199]
[108573]
[138486]
[174995]
[4651]
[241058]
[238015]
[264579]
[59448]
[34077]
[162904]
[255149]
[87664]
[257125]
[175116]
[23520]
[5612]
[243540]
[231815]
[42733]
[104297]
[199071]
[89319]
[41830]
[287031]
[297500]
[176224]
[119785]
[99894]
[47971]
[14144]
[268181]
[199134]
[124515]
[250130]
[64905]
[80718]
[3924]
[54524]
[202552]
[45357]
[70693]
[223703]
[20694]
[3616]
[294452]
[196115]
[76992]
[224679]
[127351]
[130547]
[241040]
[89587]
[214260]
[155778]
[7187]
[245490]
[20262]
[285317]
[224443]
[18130]
[112208]
[199861]
[111597]
[55474]
[83417]
[145286]
[176722]
[36941]
[60916]
[147951]
[283972]
[119625]
[292847]
[47912]
[22165]
[153682]
[135793]
[69717]
[155045]
[261991]
[41351]
[155450]
[83441]
[232638]
[12771]
[176331]
[22276]
[34887]
[283182]
[278499]
[71551]
[228708]
[104533]
[91676]
[86636]
[298321]
[9420]
[297237]
[88720]
[110376]
[137987]
[48215]
[32628]
[70205]
[102541]
[35981]
[239547]
[244877]
[51035]
[240304]
[110564]
[222054]
[279735]
[58414]
[159276]
[276726]
[48246]
[74253]
[204269]
[17806]
[117063]
[254360]
[248736]
[7151]
[25009]
[136146]
[188872]
[225213]
[170699]
[138130]
[187066]
[296840]
[135386]
[136163]
[218716]
[94551]
[236793]
[138291]
[55955]
[79828]
[247135]
[23494]
[160348]
[172484]
[50399]
[12156]
[7975]
[244186]
[277878]
[275636]
[201291]
[29384]
[168695]
[297620]
[237686]
[296019]
[246406]
[197945]
[223840]
[227849]
[64599]
[135438]
[67331]
[187148]
[135468]
[54787]
[100444]
[184455]
[253253]
[7631]
[83802]
[109622]
[91012]
[141005]
[203320]
[243788]
[101048]
[224971]
[17095]
[176952]
[148140]
[154433]
[97791]
[84620]
[69305]
[188343]
[56601]
[125426]
[267214]
[173177]
[16653]
[188014]
[203481]
[93083]
[120955]
[245501]
[69615]
[299391]
[223503]
[276087]
[289916]
[231546]
[212772]
[154006]
[59313]
[72499]
[146468]
[212738]
[113546]
[108341]
[204490]
[77714]
[135612]
[156006]
[60226]
[6513]
[288417]
[138451]
[52885]
[93444]
[94332]
[99914]
[226678]
[24525]
[167909]
[12835]
[123865]
[33674]
[247842]
[299478]
[250242]
[86318]
[124161]
[87754]
[231281]
[120584]
[11540]
[61352]
[51655]
[230609]
[184770]
[128978]
[233509]
[6869]
[262802]
[224108]
[28083]
[268698]
[77482]
[220177]
[151631]
[221973]
[80994]
[85658]
[102401]
[197515]
[95462]
[256412]
[199513]
[86211]
[21999]
[91383]
[267281]
[286007]
[259429]
[58184]
[80089]
[11408]
[171964]
[251821]
[250748]
[184695]
[299263]
[165980]
[63028]
[135992]
[203147]
[182118]
[224831]
[249715]
[247194]
[137647]
[23901]
[33823]
[138262]
[142845]
[15008]
[3311]
[267985]
[288535]
[174270]
[266149]
[19869]
[245972]
[166977]
[148888]
[287460]
[69534]
[107475]
[237993]
[10293]
[165995]
[12638]
[177772]
[135729]
[40306]
[36663]
[14883]
[68113]
[107996]
[73884]
[124549]
[27402]
[291969]
[257088]
[243669]
[197035]
[63156]
[124781]
[192838]
[192786]
[200755]
[75465]
[227268]
[141009]
[166324]
[209453]
[88559]
[82771]
[108957]
[268183]
[263451]
[200855]
[32305]
[186322]
[239662]
[218724]
[272985]
[21818]
[205582]
[64539]
[225532]
[116606]
[289083]
[188807]
[279062]
[192361]
[77664]
[23448]
[167042]
[189495]
[128122]
[63175]
[46274]
[57840]
[268673]
[126874]
[5775]
[108121]
[140633]
[192254]
[299806]
[224875]
[141201]
[170968]
[251679]
[55448]
[182093]
[35131]
[276508]
[6049]
[82459]
[1808]
[63893]
[212936]
[84553]
[189420]
[107753]
[296783]
[104420]
[101161]
[294422]
[102173]
[270461]
[169830]
[58357]
[150459]
[284045]
[188783]
[173199]
[253500]
[205235]
[10858]
[42780]
[38388]
[120462]
[168759]
[152989]
[80793]
[208625]
[292582]
[46429]
[5767]
[90685]
[7017]
[143546]
[41058]
[156579]
[295546]
[17177]
[48687]
[442]
[199981]
[178240]
[152927]
[146688]
[288851]
[175911]
[128949]
[278751]
[151085]
[35810]
[48950]
[93600]
[278866]
[222322]
[117231]
[92331]
[102311]
[91487]
[270475]
[210614]
[7379]
[184635]
[119376]
[105654]
[32685]
[58451]
[73821]
[214568]
[240546]
[140514]
[171242]
[254689]
[154855]
[56543]
[200643]
[188788]
[215214]
[257380]
[249850]
[161297]
[157140]
[99286]
[79744]
[21480]
[52096]
[35006]
[185453]
[46193]
[109037]
[113735]
[167511]
[255445]
[282774]
[115834]
[232207]
[141904]
[154465]
[112836]
[168938]
[178793]
[187299]
[213448]
[127308]
[271936]
[244122]
[122622]
[280432]
[250296]
[115544]
[135921]
[7777]
[36147]
[140956]
[283033]
[149939]
[90467]
[6303]
[253709]
[124081]
[175456]
[190442]
[290461]
[230925]
[10715]
[66743]
[73070]
[231719]
[71869]
[187682]
[240378]
[63090]
[16341]
[143513]
[6366]
[268625]
[29674]
[165286]
[267951]
[240651]
[283945]
[156815]
[192189]
[225402]
[37234]
[123795]
[173098]
[288101]
[149741]
[93284]
[263753]
[13433]
[26933]
[227601]
[117810]
[124707]
[216021]
[251881]
[14720]
[276154]
[43194]
[242036]
[103769]
[224273]
[127971]
[243130]
[286161]
[6560]
[220558]
[74607]
[9698]
[222277]
[39785]
[167551]
[18324]
[199387]
[125042]
[210387]
[128191]
[36062]
[238482]
[111100]
[158988]
[238887]
[39632]
[142468]
[101206]
[246629]
[170134]
[271387]
[257889]
[167546]
[83452]
[216261]
[175910]
[298387]
[152331]
[58838]
[165826]
[281076]
[243159]
[42224]
[190597]
[253615]
[93275]
[61167]
[190375]
[55330]
[149398]
[117160]
[48399]
[16160]
[129272]
[95105]
[242467]
[48237]
[188665]
[418]
[47882]
[69982]
[60734]
[281473]
[213086]
[261497]
[94266]
[223836]
[138837]
[72188]
[223705]
[138547]
[266546]
[126609]
[42377]
[53369]
[262343]
[281296]
[82711]
[108269]
[65301]
[289423]
[30690]
[202002]
[58049]
[29943]
[197226]
[280553]
[164438]
[207876]
[226624]
[42058]
[26082]
[67592]
[240187]
[175898]
[136522]
[69531]
[115603]
[21716]
[66747]
[234005]
[281505]
[162520]
[255787]
[140835]
[66413]
[12350]
[26512]
[135798]
[292950]
[143739]
[295788]
[68964]
[38165]
[220156]
[118622]
[133567]
[178228]
[119224]
[200937]
[286337]
[123974]
[171991]
[185994]
[14746]
[1726]
[297569]
[176336]
[267009]
[54549]
[33963]
[144874]
[7469]
[296379]
[196768]
[61341]
[274789]
[210084]
[56901]
[95610]
[281916]
[117528]
[47329]
[184706]
[213930]
[277238]
[199667]
[155207]
[31750]
[121956]
[62053]
[121693]
[198082]
[291760]
[85740]
[219110]
[45669]
[65868]
[126182]
[129254]
[203085]
[126173]
[54677]
[33397]
[155747]
[87313]
[172831]
[133953]
[170759]
[142954]
[196886]
[297082]
[52491]
[235619]
[81720]
[136321]
[285087]
[77227]
[3434]
[43940]
[294222]
[148066]
[74863]
[61874]
[184434]
[270621]
[251662]
[93989]
[218487]
[293137]
[9806]
[161272]
[25496]
[226873]
[23296]
[149516]
[254948]
[105119]
[189327]
[195421]
[53898]
[213798]
[269088]
[244362]
[37334]
[172501]
[176530]
[292627]
[242710]
[156555]
[229074]
[125937]
[236058]
[16030]
[179086]
[40150]
[219864]
[2926]
[286588]
[73514]
[219233]
[36412]
[89828]
[109723]
[102808]
[266304]
[31441]
[56624]
[195556]
[244410]
[266578]
[213442]
[264824]
[250175]
[14841]
[152045]
[278948]
[20462]
[207903]
[91101]
[136035]
[217651]
[150122]
[298054]
[154366]
[142308]
[155303]
[255224]
[224339]
[102084]
[179517]
[58145]
[198337]
[239204]
[221975]
[215237]
[200741]
[53181]
[120007]
[28173]
[190460]
[222108]
[63930]
[11489]
[90310]
[761]
[89071]
[296869]
[212063]
[271345]
[173133]
[155485]
[145599]
[156181]
[136285]
[217017]
[342]
[270659]
[297542]
[246004]
[62437]
[59994]
[79039]
[5924]
[225191]
[212132]
[166455]
[280368]
[178440]
[192959]
[174914]
[129463]
[222034]
[202467]
[117772]
[232631]
[144115]
[21160]
[198361]
[146153]
[71630]
[249947]
[8715]
[270006]
[75037]
[47800]
[171083]
[152101]
[140011]
[265580]
[229966]
[9275]
[272665]
[254254]
[174620]
[2100]
[273790]
[256001]
[31783]
[47591]
[44245]
[197121]
[118970]
[260700]
[126457]
[147416]
[192235]
[83535]
[238843]
[234982]
[40832]
[83734]
[42586]
[78340]
[120697]
[96998]
[110924]
[209214]
[209581]
[45705]
[298932]
[141504]
[162662]
[256568]
[230781]
[92688]
[56540]
[50759]
[205287]
[78834]
[116349]
[82706]
[71252]
[269803]
[293194]
[30656]
[131077]
[287871]
[123342]
[97351]
[11095]
[281867]
[140814]
[43824]
[273271]
[180398]
[130623]
[282043]
[204677]
[114424]
[167263]
[201109]
[228187]
[108216]
[54200]
[39490]
[157775]
[155543]
[196046]
[151295]
[293609]
[250491]
[39412]
[51282]
[112299]
[137885]
[251369]
[32630]
[99152]
[56288]
[36720]
[169270]
[15163]
[56017]
[251114]
[236769]
[165854]
[182618]
[139290]
[68610]
[242652]
[211603]
[52930]
[157442]
[144236]
[78152]
[11549]
[161752]
[237086]
[198764]
[27938]
[106052]
[286532]
[264405]
[101541]
[114613]
[227343]
[49103]
[234278]
[251197]
[159511]
[199968]
[187079]
[137677]
[173786]
[294654]
[102599]
[237046]
[181457]
[149733]
[146]
[268159]
[210368]
[297701]
[242881]
[131324]
[190481]
[23213]
[151088]
[71496]
[113367]
[163705]
[182591]
[292276]
[212937]
[47890]
[93240]
[27551]
[124936]
[58122]
[275029]
[36720]
[211689]
[295702]
[270286]
[102327]
[259598]
[52599]
[23802]
[236835]
[251647]
[183113]
[144233]
[2394]
[295010]
[3666]
[116906]
[86553]
[94723]
[236768]
[235601]
[256504]
[52204]
[29762]
[224112]
[27146]
[170248]
[213099]
[232146]
[28855]
[144273]
[198126]
[132096]
[237006]
[269946]
[56375]
[243227]
[103327]
[2887]
[170929]
[258848]
[138425]
[28575]
[50690]
[46018]
[239628]
[233501]
[282608]
[13715]
[150767]
[180463]
[84165]
[280677]
[34687]
[30244]
[253453]
[27764]
[61004]
[142498]
[80397]
[245151]
[170630]
[273624]
[162369]
[171369]
[280420]
[211244]
[69958]
[97903]
[241876]
[262922]
[56694]
[72755]
[232154]
[1011]
[185441]
[110438]
[180575]
[12559]
[181661]
[114156]
[159384]
[72651]
[63120]
[29646]
[114876]
[190649]
[245601]
[97398]
[76152]
[226449]
[266809]
[148593]
[148756]
[269275]
[72724]
[212012]
[239376]
[173664]
[240723]
[97225]
[159532]
[37000]
[23283]
[110480]
[80112]
[56466]
[61207]
[173456]
[132433]
[294835]
[87483]
[174299]
[20824]
[58520]
[208913]
[294439]
[185230]
[47064]
[12730]
[277220]
[4883]
[27763]
[12154]
[225269]
[194209]
[48405]
[265]
[128085]
[172772]
[58490]
[45308]
[4843]
[138717]
[6145]
[211067]
[13493]
[277982]
[190534]
[198929]
[44906]
[19542]
[230711]
[213582]
[198076]
[260004]
[209681]
[46535]
[96502]
[14778]
[207364]
[80205]
[256773]
[1724]
[97339]
[130964]
[126582]
[191057]
[161593]
[129537]
[72233]
[266826]
[255743]
[195542]
[35150]
[52358]
[9005]
[145136]
[35757]
[64468]
[275475]
[117865]
[246026]
[7523]
[292162]
[267731]
[39972]
[172615]
[287950]
[5807]
[161113]
[185341]
[49754]
[240148]
[257827]
[260845]
[110534]
[139907]
[38188]
[6351]
[220622]
[185122]
[49969]
[215680]
[191787]
[90024]
[296835]
[154368]
[193309]
[98088]
[76792]
[244681]
[298615]
[10254]
[74401]
[177022]
[143639]
[17203]
[216274]
[251463]
[290874]
[185228]
[51258]
[89388]
[11620]
[123826]
[237070]
[216636]
[227487]
[136866]
[215388]
[55451]
[212359]
[226331]
[10567]
[165253]
[114562]
[145315]
[86386]
[2635]
[98133]
[150598]
[171458]
[76679]
[265182]
[135681]
[161733]
[266970]
[38229]
[248222]
[83933]
[100153]
[12996]
[32140]
[256602]
[287784]
[26837]
[275246]
[265317]
[264147]
[57373]
[132089]
[76681]
[233448]
[107056]
[147861]
[99441]
[287057]
[134592]
[1991]
[171445]
[290153]
[250050]
[173939]
[252242]
[144410]
[21768]
[208284]
[91577]
[210958]
[168802]
[25692]
[20863]
[139411]
[9997]
[216789]
[95642]
[71958]
[136432]
[109761]
[266946]
[195301]
[2181]
[34151]
[59197]
[223384]
[196187]
[33852]
[94512]
[263350]
[89216]
[222577]
[214558]
[275171]
[267324]
[211658]
[179837]
[3476]
[7101]
[23178]
[157476]
[70493]
[138792]
[236280]
[67755]
[41538]
[59246]
[145441]
[72314]
[176853]
[146569]
[124887]
[293133]
[189467]
[277827]
[239362]
[235273]
[24624]
[229850]
[82303]
[150364]
[214991]
[35909]
[201714]
[263044]
[241036]
[106667]
[7808]
[272638]
[241480]
[152544]
[100494]
[249036]
[106963]
[223834]
[116076]
[190325]
[122070]
[298871]
[121659]
[278973]
[106135]
[142517]
[157028]
[189817]
[223256]
[212758]
[22038]
[53181]
[1085]
[21176]
[84331]
[153363]
[245844]
[4695]
[122241]
[97445]
[227318]
[108779]
[90812]
[56598]
[22451]
[251281]
[81383]
[130537]
[255200]
[212199]
[289099]
[159932]
[117134]
[261823]
[9595]
[162189]
[2528]
[36212]
[169591]
[95261]
[127210]
[200258]
[196363]
[278401]
[10338]
[18613]
[49822]
[140081]
[164517]
[260784]
[1128]
[38278]
[15559]
[61534]
[275575]
[64426]
[150573]
[288965]
[247385]
[19322]
[291616]
[174306]
[153238]
[249689]
[104791]
[54307]
[157969]
[200215]
[139538]
[178773]
[173637]
[153922]
[183906]
[184861]
[88333]
[140437]
[63551]
[148525]
[127703]
[26606]
[25355]
[171164]
[215438]
[148074]
[165977]
[7938]
[89051]
[150008]
[215828]
[41403]
[238276]
[295917]
[126960]
[102025]
[90813]
[63968]
[122556]
[297187]
[118580]
[100341]
[176037]
[12222]
[78028]
[129412]
[171911]
[272698]
[198886]
[72761]
[158358]
[210789]
[259970]
[253454]
[138484]
[94707]
[188362]
[44773]
[194467]
[163929]
[105507]
[239548]
[150668]
[52936]
[143682]
[110753]
[119062]
[105905]
[260998]
[250086]
[208421]
[41669]
[25577]
[101829]
[50625]
[254935]
[2273]
[204704]
[30476]
[47096]
[291849]
[66682]
[170999]
[137485]
[21159]
[162292]
[181604]
[131117]
[251967]
[295512]
[181589]
[127247]
[221121]
[26316]
[56024]
[243130]
[158244]
[161287]
[114483]
[103008]
[226474]
[229193]
[66404]
[71733]
[248547]
[191421]
[92830]
[101957]
[94890]
[262465]
[255998]
[93993]
[185893]
[139321]
[200043]
[158849]
[162923]
[73734]
[140111]
[269784]
[54947]
[229720]
[165886]
[130298]
[33069]
[20454]
[242980]
[104005]
[63407]
[246316]
[262862]
[165853]
[16550]
[137295]
[237931]
[29044]
[168743]
[36690]
[69786]
[288636]
[2281]
[201017]
[211508]
[289105]
[251860]
[148462]
[237913]
[31208]
[55482]
[116531]
[160697]
[32520]
[65694]
[139468]
[119914]
[163932]
[265623]
[191201]
[35109]
[70533]
[285449]
[36206]
[114789]
[110948]
[244523]
[129800]
[83515]
[132524]
[265449]
[20470]
[111654]
[141801]
[250005]
[68428]
[160840]
[87078]
[105684]
[285411]
[196292]
[85980]
[299081]
[143134]
[90397]
[152140]
[98926]
[194168]
[106930]
[251637]
[271575]
[55730]
[86850]
[180114]
[247791]
[246399]
[88218]
[299985]
[43364]
[49692]
[241519]
[165290]
[138274]
[5896]
[138947]
[236617]
[150037]
[268142]
[95220]
[27582]
[200890]
[197212]
[272966]
[20659]
[189759]
[14622]
[215195]
[118985]
[158069]
[202418]
[218298]
[131913]
[197531]
[179738]
[149769]
[189018]
[37428]
[25747]
[234906]
[142340]
[217219]
[276751]
[173863]
[281635]
[199043]
[172094]
[114796]
[40627]
[82978]
[282484]
[95197]
[216395]
[273334]
[289481]
[254394]
[6857]
[67948]
[220199]
[226643]
[135078]
[114311]
[165649]
[16853]
[166571]
[133795]
[243980]
[193990]
[230929]
[106115]
[183204]
[58986]
[283585]
[225028]
[272345]
[48665]
[37342]
[87802]
[228754]
[38657]
[148264]
[164700]
[224737]
[230259]
[222832]
[99466]
[60771]
[275126]
[200514]
[28006]
[288201]
[296095]
[2581]
[94018]
[86060]
[41006]
[85678]
[4278]
[297472]
[99256]
[159118]
[242781]
[160721]
[207660]
[73352]
[89269]
[188105]
[45542]
[293672]
[38793]
[284046]
[57588]
[128684]
[126828]
[188866]
[267822]
[190800]
[207869]
[298035]
[246996]
[252277]
[46772]
[298715]
[149329]
[25808]
[3374]
[57377]
[260256]
[140162]
[52352]
[248453]
[294593]
[268271]
[82076]
[201230]
[84729]
[125835]
[251623]
[216227]
[49149]
[231637]
[222901]
[7918]
[109208]
[6869]
[65001]
[236796]
[195061]
[244387]
[155484]
[195955]
[297448]
[267157]
[66458]
[194784]
[111583]
[236359]
[20480]
[290860]
[131707]
[148583]
[249771]
[6371]
[145810]
[54927]
[72673]
[41855]
[43035]
[119598]
[112665]
[826]
[213941]
[130748]
[251508]
[245224]
[133449]
[202680]
[22606]
[269512]
[174997]
[213010]
[163173]
[182398]
[135688]
[114553]
[215006]
[76111]
[3582]
[35842]
[242850]
[279389]
[76823]
[249946]
[116620]
[94104]
[74427]
[195831]
[112204]
[291867]
[214695]
[166825]
[55070]
[240485]
[246687]
[161516]
[115956]
[4285]
[11748]
[35405]
[257596]
[1186]
[232296]
[73798]
[263840]
[90981]
[151165]
[45708]
[3504]
[238610]
[94410]
[238287]
[42458]
[37303]
[173587]
[215986]
[105525]
[157101]
[272294]
[30882]
[276545]
[33037]
[222867]
[195677]
[45281]
[147109]
[127703]
[96306]
[237542]
[153351]
[202405]
[208266]
[283055]
[270131]
[94841]
[117655]
[242920]
[183833]
[278778]
[24925]
[214337]
[50809]
[138880]
[251660]
[286761]
[34305]
[168559]
[96318]
[142664]
[116211]
[243836]
[237663]
[104976]
[15500]
[298850]
[227414]
[153859]
[221601]
[259815]
[86036]
[186754]
[252453]
[128499]
[193859]
[190465]
[223816]
[206227]
[90283]
[189557]
[205804]
[224834]
[16692]
[25236]
[188370]
[7853]
[208424]
[4067]
[6564]
[285383]
[3327]
[51330]
[284084]
[173974]
[202339]
[286003]
[3424]
[212037]
[2997]
[190559]
[158160]
[49174]
[63373]
[246588]
[102636]
[97535]
[196639]
[128907]
[176170]
[288095]
[118743]
[62026]
[71873]
[64185]
[9520]
[211971]
[187471]
[49217]
[46835]
[193050]
[290856]
[172372]
[156937]
[134063]
[54296]
[150445]
[157870]
[226222]
[204438]
[96498]
[221076]
[110477]
[289028]
[223769]
[195917]
[277924]
[154495]
[77374]
[215490]
[281024]
[88231]
[80663]
[298362]
[81107]
[293839]
[220395]
[103756]
[2996]
[403]
[243266]
[43467]
[233837]
[143964]
[167651]
[286542]
[134398]
[28813]
[98909]
[163758]
[251160]
[258653]
[159048]
[98556]
[208807]
[213769]
[58931]
[290023]
[197538]
[175599]
[204918]
[91400]
[62201]
[216684]
[215378]
[124159]
[59492]
[264426]
[97121]
[136342]
[16424]
[154566]
[190724]
[189275]
[142328]
[34142]
[28434]
[263508]
[115893]
[234182]
[296373]
[261121]
[102759]
[114361]
[274942]
[39364]
[170165]
[25992]
[447]
[190624]
[26628]
[69524]
[43405]
[89919]
[217016]
[291698]
[181089]
[70573]
[190708]
[291022]
[42332]
[163332]
[114311]
[41285]
[57880]
[130440]
[4983]
[13619]
[69452]
[60847]
[153855]
[219553]
[109751]

{"sheet":"(1044)","index":3,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Mixed Data",null,"Unique Number Count Formula"]
[3,null,{"$f":"SUM(SIGN(FREQUENCY(A2:A15,A2:A15)))","v":5},null,null,"Chapter 19: Extract Unique Lists"]
[4]
[4,null,"Sorted Unique List of Numbers:"]
[5,null,{"$f":"IF(ROWS(C$5:C5)>C$2,\"\",LARGE(IF(FREQUENCY(IF(ISNUMBER($A$2:$A$15),MATCH($A$2:$A$15,$A$2:$A$15,0)),ROW($A$2:$A$15)-ROW($A$2)+1),$A$2:$A$15),ROWS(C$5:C5)))","v":5}]
[3,null,{"$f":"IF(ROWS(C$5:C6)>C$2,\"\",LARGE(IF(FREQUENCY(IF(ISNUMBER($A$2:$A$15),MATCH($A$2:$A$15,$A$2:$A$15,0)),ROW($A$2:$A$15)-ROW($A$2)+1),$A$2:$A$15),ROWS(C$5:C6)))","v":4}]
[4,null,{"$f":"IF(ROWS(C$5:C7)>C$2,\"\",LARGE(IF(FREQUENCY(IF(ISNUMBER($A$2:$A$15),MATCH($A$2:$A$15,$A$2:$A$15,0)),ROW($A$2:$A$15)-ROW($A$2)+1),$A$2:$A$15),ROWS(C$5:C7)))","v":3}]
[5,null,{"$f":"IF(ROWS(C$5:C8)>C$2,\"\",LARGE(IF(FREQUENCY(IF(ISNUMBER($A$2:$A$15),MATCH($A$2:$A$15,$A$2:$A$15,0)),ROW($A$2:$A$15)-ROW($A$2)+1),$A$2:$A$15),ROWS(C$5:C8)))","v":0},null,"Other videos on Extract Unique List:"]
[null,null,{"$f":"IF(ROWS(C$5:C9)>C$2,\"\",LARGE(IF(FREQUENCY(IF(ISNUMBER($A$2:$A$15),MATCH($A$2:$A$15,$A$2:$A$15,0)),ROW($A$2:$A$15)-ROW($A$2)+1),$A$2:$A$15),ROWS(C$5:C9)))","v":-1},null,"Excel Magic Trick 1040: Formula To Extract & Sort A Unique List Of Numbers, No Empty Cells Or Text "]
[0,null,{"$f":"IF(ROWS(C$5:C10)>C$2,\"\",LARGE(IF(FREQUENCY(IF(ISNUMBER($A$2:$A$15),MATCH($A$2:$A$15,$A$2:$A$15,0)),ROW($A$2:$A$15)-ROW($A$2)+1),$A$2:$A$15),ROWS(C$5:C10)))","v":""},null,"Excel Magic Trick 473: Extract Unique Records with Formula (Complex Array Formula) "]
["DNQ",null,{"$f":"IF(ROWS(C$5:C11)>C$2,\"\",LARGE(IF(FREQUENCY(IF(ISNUMBER($A$2:$A$15),MATCH($A$2:$A$15,$A$2:$A$15,0)),ROW($A$2:$A$15)-ROW($A$2)+1),$A$2:$A$15),ROWS(C$5:C11)))","v":""},null,"Excel 2010 Magic Trick 817: Extract Unique List of Values For Dynamic Data Validation Drop Down List "]
[-1,null,null,null,"Excel Magic Trick 759: Array Formula To Sort List & Remove Duplicates - Dynamic Named Range "]
[-1]
[0]
[5,null,null,null,"data",null,"categories","FREQUENCY","bins"]
[null,null,null,null,5,null,"<=5",{"$f":"FREQUENCY(E16:E20,I16:I18)","v":1},5]
[null,null,null,null,8,null,">5 <=10",2,10]
[null,null,null,null,10,null,">10 <15",1,15]
[null,null,null,null,15,null,">15",1]
[null,null,null,null,22]

{"sheet":"(1044an)","index":4,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Mixed Data",null,"Unique Number Count Formula"]
[3,null,{"$f":"SUM(SIGN(FREQUENCY(A2:A15,A2:A15)))","v":5},null,null,"Chapter 19: Extract Unique Lists"]
[4]
[4,null,"Sorted Unique List of Numbers:"]
[5,null,{"$f":"IF(ROWS(C$5:C5)>C$2,\"\",LARGE(IF(FREQUENCY(IF(ISNUMBER($A$2:$A$15),MATCH($A$2:$A$15,$A$2:$A$15,0)),ROW($A$2:$A$15)-ROW($A$2)+1),$A$2:$A$15),ROWS(C$5:C5)))","v":5}]
[3,null,{"$f":"IF(ROWS(C$5:C6)>C$2,\"\",LARGE(IF(FREQUENCY(IF(ISNUMBER($A$2:$A$15),MATCH($A$2:$A$15,$A$2:$A$15,0)),ROW($A$2:$A$15)-ROW($A$2)+1),$A$2:$A$15),ROWS(C$5:C6)))","v":4}]
[4,null,{"$f":"IF(ROWS(C$5:C7)>C$2,\"\",LARGE(IF(FREQUENCY(IF(ISNUMBER($A$2:$A$15),MATCH($A$2:$A$15,$A$2:$A$15,0)),ROW($A$2:$A$15)-ROW($A$2)+1),$A$2:$A$15),ROWS(C$5:C7)))","v":3}]
[5,null,{"$f":"IF(ROWS(C$5:C8)>C$2,\"\",LARGE(IF(FREQUENCY(IF(ISNUMBER($A$2:$A$15),MATCH($A$2:$A$15,$A$2:$A$15,0)),ROW($A$2:$A$15)-ROW($A$2)+1),$A$2:$A$15),ROWS(C$5:C8)))","v":0},null,"Other videos on Extract Unique List:"]
[null,null,{"$f":"IF(ROWS(C$5:C9)>C$2,\"\",LARGE(IF(FREQUENCY(IF(ISNUMBER($A$2:$A$15),MATCH($A$2:$A$15,$A$2:$A$15,0)),ROW($A$2:$A$15)-ROW($A$2)+1),$A$2:$A$15),ROWS(C$5:C9)))","v":-1},null,"Excel Magic Trick 1040: Formula To Extract & Sort A Unique List Of Numbers, No Empty Cells Or Text "]
[0,null,{"$f":"IF(ROWS(C$5:C10)>C$2,\"\",LARGE(IF(FREQUENCY(IF(ISNUMBER($A$2:$A$15),MATCH($A$2:$A$15,$A$2:$A$15,0)),ROW($A$2:$A$15)-ROW($A$2)+1),$A$2:$A$15),ROWS(C$5:C10)))","v":""},null,"Excel Magic Trick 473: Extract Unique Records with Formula (Complex Array Formula) "]
["DNQ",null,{"$f":"IF(ROWS(C$5:C11)>C$2,\"\",LARGE(IF(FREQUENCY(IF(ISNUMBER($A$2:$A$15),MATCH($A$2:$A$15,$A$2:$A$15,0)),ROW($A$2:$A$15)-ROW($A$2)+1),$A$2:$A$15),ROWS(C$5:C11)))","v":""},null,"Excel 2010 Magic Trick 817: Extract Unique List of Values For Dynamic Data Validation Drop Down List "]
[-1,null,null,null,"Excel Magic Trick 759: Array Formula To Sort List & Remove Duplicates - Dynamic Named Range "]
[-1]
[0]
[5,null,null,null,"data",null,"categories","FREQUENCY","bins"]
[null,null,null,null,5,null,"<=5",{"$f":"FREQUENCY(E16:E20,I16:I18)","v":1},5]
[null,null,null,null,8,null,">5 <=10",2,10]
[null,null,null,null,10,null,">10 <15",1,15]
[null,null,null,null,15,null,">15",1]
[null,null,null,null,22]

{"sheet":"(1045)","index":5,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Numbers",null,"Excel 2010 or Later"]
[74]
[67]
[73]
[72]
[75]
[66]
[62,null,null,null,"For information about displaying and counting multiple modes, see this video:"]
[61,null,null,null,"Excel Magic Trick 761: Formula Displaying Multiple Modes & Counting Modes Excel 2010 MODE.MULT "]
[67,null,null,null,"https://www.youtube.com/watch?v=OjKBorMk6MA"]
[67]
[55]
[72]
[69]
[72]

{"sheet":"(1045an)","index":6,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Numbers",null,"Excel 2010 or Later"]
[74,null,{"$f":"OR(_xlfn.MODE.MULT($A$2:$A$15)=A2)","v":false}]
[67,null,{"$f":"OR(_xlfn.MODE.MULT($A$2:$A$15)=A3)","v":true}]
[73,null,false]
[72,null,true]
[75,null,false]
[66,null,false]
[62,null,false,null,"For information about displaying and counting multiple modes, see this video:"]
[61,null,false,null,"Excel Magic Trick 761: Formula Displaying Multiple Modes & Counting Modes Excel 2010 MODE.MULT "]
[67,null,true,null,"https://www.youtube.com/watch?v=OjKBorMk6MA"]
[67,null,true]
[55,null,false]
[72,null,true]
[69,null,false]
[72,null,true]

{"sheet":"(1046)","index":7,"n_rows":17,"n_cols":20,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Past Data:",null,null,null,"Linear Regression To Estimate & Add Many Predicted Y-Values, Single Cell Formula "]
[null,"X","Y"]
["Month","Number of ads","Units sold",null,"Single Cell Formula To Estimate Total Units For Six Months "]
["Jan",144,30240]
["Feb",163,47922,null,null,"Estimate 6 months of sales"]
["Mar",175,37450]
["Apr",188,50384,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TREND(C4:C17,B4:B17,F9:F14)","v":36522.049360746678}]
["May",175,42525,null,"Planned Ads over nest 6 months:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,38991.08484960677]
["Jun",178,37736,null,"Jan",150,null,null,null,null,null,null,null,null,null,null,null,null,null,31378.22542562148]
["Jul",199,53332,null,"Feb",162,null,null,null,null,null,null,null,null,null,null,null,null,null,42694.638082896905]
["Aug",190,38190,null,"Mar",125,null,null,null,null,null,null,null,null,null,null,null,null,null,41665.873295871868]
["Sep",117,32526,null,"Apr",180,null,null,null,null,null,null,null,null,null,null,null,null,null,43723.402869921949]
["Oct",118,31034,null,"May",175,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T7:T12)","v":234975.27388466563}]
["Nov",189,38367,null,"Jun",185]
["Dec",195,48555]
["Jan",117,30069]
["Feb",141,31866]

{"sheet":"(1046an)","index":8,"n_rows":17,"n_cols":20,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Past Data:",null,null,null,"Linear Regression To Estimate & Add Many Predicted Y-Values, Single Cell Formula "]
[null,"X","Y"]
["Month","Number of ads","Units sold",null,"Single Cell Formula To Estimate Total Units For Six Months "]
["Jan",144,30240]
["Feb",163,47922,null,null,"Estimate 6 months of sales"]
["Mar",175,37450,null,null,{"$f":"SUM(TREND(C4:C17,B4:B17,F9:F14))","v":234975.27388466563}]
["Apr",188,50384,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TREND(C4:C17,B4:B17,F9:F14)","v":36522.049360746678}]
["May",175,42525,null,"Planned Ads over nest 6 months:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,38991.08484960677]
["Jun",178,37736,null,"Jan",150,null,{"$f":"TREND(C4:C17,B4:B17,F9:F14)","v":36522.049360746678},null,null,null,null,null,null,null,null,null,null,null,31378.22542562148]
["Jul",199,53332,null,"Feb",162,null,38991.08484960677,null,null,null,null,null,null,null,null,null,null,null,42694.638082896905]
["Aug",190,38190,null,"Mar",125,null,31378.22542562148,null,null,null,null,null,null,null,null,null,null,null,41665.873295871868]
["Sep",117,32526,null,"Apr",180,null,42694.638082896905,null,null,null,null,null,null,null,null,null,null,null,43723.402869921949]
["Oct",118,31034,null,"May",175,null,41665.873295871868,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T7:T12)","v":234975.27388466563}]
["Nov",189,38367,null,"Jun",185,null,43723.402869921949]
["Dec",195,48555,null,null,null,null,{"$f":"SUM(H9:H14)","v":234975.27388466563}]
["Jan",117,30069]
["Feb",141,31866]