{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["(615)","(615an)","(616)","(616an)","(617)","(617an)","(618)","(618an)","(619)","(619an)","(620)","(620an)","(621)","(621an)","(622)","(622an)","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"(615)","index":0,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Products","Amount",null,"I want to sum amount of all those products who have following words in their name"]
["box 2",15000,null,"box"]
["hardboard final",12950,null,"knife"]
["paper 9",22400,null,"hardboard"]
["paper 234",25400]
["knife ws",59200,null,"SUMIF adds with 1 criterion (condition)"]
["box 99",10300,null,"* is a wild card that means at least one character"]
["box small",75100,null,"? is a wild card that means one character"]
["paper",52100,null,"You can use the wildcard characters — the question mark (?) and the asterisk (*) — in criteria. A question mark matches any single character, and an asterisk matches any sequence of characters. If you want to find an actual question mark or asterisk, type a tilde (~) before the character."]
["knife",10500,null,"Ampersand, & (Shift + 7) is the join symbol"]
["pin shart",50400]
["pin sharp",10500]
["5 boxes",20000]
["box big",26200]
["knife",15750]

{"sheet":"(615an)","index":1,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Products","Amount",null,"I want to sum amount of all those products who have following words in their name"]
["box 2",15000,null,"box",{"$f":"SUMIF($A$2:$A$15,\"*\"&D2&\"*\",$B$2:$B$15)","v":146600},{"$f":"SUMPRODUCT(--ISNUMBER(SEARCH(D2,$A$2:$A$15)),$B$2:$B$15)","v":146600}]
["hardboard final",12950,null,"knife",{"$f":"SUMIF($A$2:$A$15,\"*\"&D3&\"*\",$B$2:$B$15)","v":85450},{"$f":"SUMPRODUCT(--ISNUMBER(SEARCH(D3,$A$2:$A$15)),$B$2:$B$15)","v":85450}]
["paper 9",22400,null,"hardboard",{"$f":"SUMIF($A$2:$A$15,\"*\"&D4&\"*\",$B$2:$B$15)","v":12950},12950]
["paper 234",25400]
["knife ws",59200,null,"SUMIF adds with 1 criterion (condition)"]
["box 99",10300,null,"* is a wild card that means at least one character"]
["box small",75100,null,"? is a wild card that means one character"]
["paper",52100,null,"You can use the wildcard characters — the question mark (?) and the asterisk (*) — in criteria. A question mark matches any single character, and an asterisk matches any sequence of characters. If you want to find an actual question mark or asterisk, type a tilde (~) before the character."]
["knife",10500,null,"Ampersand, & (Shift + 7) is the join symbol"]
["pin shart",50400]
["pin sharp",10500]
["5 boxes",20000]
["box big",26200]
["knife",15750]

{"sheet":"(616)","index":2,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Name","Sales",null,"No","LARGE",null,"LARGE w internal counter"]
["Sue",191,null,1]
["Sioux",181,null,2]
["Christina",181,null,3]
["Tina",174]
["Joe",174,null,"No","SMALL",null,"SMALL w internal counter"]
["Tom",167,null,1]
["Martha",155,null,2]
["Luong",154,null,3]
["Chin",113]
["Isaac",113,null,null,"Add 3 largest"]
["Joe",112,null,null,"Add 3 smallest"]
[]
[null,null,null,"No","Unique List #","Count","SMALL to return multiple items"]
[null,null,null,1]
[null,null,null,2]
[null,null,null,3]
[null,null,null,4]
[null,null,null,5]
[]
[null,null,null,null,"To learn the basics of array formulas, see this playlist of videos:"]
[null,null,null,null,"http://www.youtube.com/view_play_list?p=007E7E9CA63304D3"]

{"sheet":"(616an)","index":3,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Name","Sales",null,"No","LARGE",null,"LARGE w internal counter"]
["Sue",191,null,1,{"$f":"LARGE($B$2:$B$12,D2)","v":191},null,{"$f":"LARGE($B$2:$B$12,ROWS(G$2:G2))","v":191}]
["Sioux",181,null,2,{"$f":"LARGE($B$2:$B$12,D3)","v":181},null,{"$f":"LARGE($B$2:$B$12,ROWS(G$2:G3))","v":181}]
["Christina",181,null,3,181,null,{"$f":"LARGE($B$2:$B$12,ROWS(G$2:G4))","v":181}]
["Tina",174]
["Joe",174,null,"No","SMALL",null,"SMALL w internal counter"]
["Tom",167,null,1,{"$f":"SMALL($B$2:$B$12,D7)","v":112},null,{"$f":"SMALL($B$2:$B$12,COLUMNS($G7:G7))","v":112},{"$f":"SMALL($B$2:$B$12,COLUMNS($G7:H7))","v":113},{"$f":"SMALL($B$2:$B$12,COLUMNS($G7:I7))","v":113}]
["Martha",155,null,2,{"$f":"SMALL($B$2:$B$12,D8)","v":113}]
["Luong",154,null,3,113]
["Chin",113]
["Isaac",113,null,null,"Add 3 largest",{"$f":"SUM(LARGE(B2:B12,{1,2,3}))","v":553}]
["Joe",112,null,null,"Add 3 smallest",{"$f":"SUM(SMALL(B2:B12,{1,2,3}))","v":338}]
[]
[null,null,null,"No","Unique List #","Count","SMALL to return multiple items"]
[null,null,null,1,{"$f":"INDEX($B$2:$B$12,SMALL(IF(FREQUENCY($B$2:$B$12,$B$2:$B$12),ROW($B$2:$B$12)-ROW($B$2)+1),D15))","v":191},{"$f":"COUNTIF($B$2:$B$12,E15)","v":1},{"$f":"IF(COLUMNS($G15:G15)>$F15,\"\",INDEX($A$2:$A$12,SMALL(IF($B$2:$B$12=$E15,ROW($B$2:$B$12)-ROW($B$2)+1),COLUMNS($G15:G15))))","v":"Sue"},{"$f":"IF(COLUMNS($G15:H15)>$F15,\"\",INDEX($A$2:$A$12,SMALL(IF($B$2:$B$12=$E15,ROW($B$2:$B$12)-ROW($B$2)+1),COLUMNS($G15:H15))))","v":""},{"$f":"IF(COLUMNS($G15:I15)>$F15,\"\",INDEX($A$2:$A$12,SMALL(IF($B$2:$B$12=$E15,ROW($B$2:$B$12)-ROW($B$2)+1),COLUMNS($G15:I15))))","v":""}]
[null,null,null,2,{"$f":"INDEX($B$2:$B$12,SMALL(IF(FREQUENCY($B$2:$B$12,$B$2:$B$12),ROW($B$2:$B$12)-ROW($B$2)+1),D16))","v":181},{"$f":"COUNTIF($B$2:$B$12,E16)","v":2},{"$f":"IF(COLUMNS($G16:G16)>$F16,\"\",INDEX($A$2:$A$12,SMALL(IF($B$2:$B$12=$E16,ROW($B$2:$B$12)-ROW($B$2)+1),COLUMNS($G16:G16))))","v":"Sioux"},{"$f":"IF(COLUMNS($G16:H16)>$F16,\"\",INDEX($A$2:$A$12,SMALL(IF($B$2:$B$12=$E16,ROW($B$2:$B$12)-ROW($B$2)+1),COLUMNS($G16:H16))))","v":"Christina"},{"$f":"IF(COLUMNS($G16:I16)>$F16,\"\",INDEX($A$2:$A$12,SMALL(IF($B$2:$B$12=$E16,ROW($B$2:$B$12)-ROW($B$2)+1),COLUMNS($G16:I16))))","v":""}]
[null,null,null,3,{"$f":"INDEX($B$2:$B$12,SMALL(IF(FREQUENCY($B$2:$B$12,$B$2:$B$12),ROW($B$2:$B$12)-ROW($B$2)+1),D17))","v":174},2,{"$f":"IF(COLUMNS($G17:G17)>$F17,\"\",INDEX($A$2:$A$12,SMALL(IF($B$2:$B$12=$E17,ROW($B$2:$B$12)-ROW($B$2)+1),COLUMNS($G17:G17))))","v":"Tina"},{"$f":"IF(COLUMNS($G17:H17)>$F17,\"\",INDEX($A$2:$A$12,SMALL(IF($B$2:$B$12=$E17,ROW($B$2:$B$12)-ROW($B$2)+1),COLUMNS($G17:H17))))","v":"Joe"},{"$f":"IF(COLUMNS($G17:I17)>$F17,\"\",INDEX($A$2:$A$12,SMALL(IF($B$2:$B$12=$E17,ROW($B$2:$B$12)-ROW($B$2)+1),COLUMNS($G17:I17))))","v":""}]
[null,null,null,4,{"$f":"INDEX($B$2:$B$12,SMALL(IF(FREQUENCY($B$2:$B$12,$B$2:$B$12),ROW($B$2:$B$12)-ROW($B$2)+1),D18))","v":167},1,{"$f":"IF(COLUMNS($G18:G18)>$F18,\"\",INDEX($A$2:$A$12,SMALL(IF($B$2:$B$12=$E18,ROW($B$2:$B$12)-ROW($B$2)+1),COLUMNS($G18:G18))))","v":"Tom"},{"$f":"IF(COLUMNS($G18:H18)>$F18,\"\",INDEX($A$2:$A$12,SMALL(IF($B$2:$B$12=$E18,ROW($B$2:$B$12)-ROW($B$2)+1),COLUMNS($G18:H18))))","v":""},{"$f":"IF(COLUMNS($G18:I18)>$F18,\"\",INDEX($A$2:$A$12,SMALL(IF($B$2:$B$12=$E18,ROW($B$2:$B$12)-ROW($B$2)+1),COLUMNS($G18:I18))))","v":""}]
[null,null,null,5,{"$f":"INDEX($B$2:$B$12,SMALL(IF(FREQUENCY($B$2:$B$12,$B$2:$B$12),ROW($B$2:$B$12)-ROW($B$2)+1),D19))","v":155},1,{"$f":"IF(COLUMNS($G19:G19)>$F19,\"\",INDEX($A$2:$A$12,SMALL(IF($B$2:$B$12=$E19,ROW($B$2:$B$12)-ROW($B$2)+1),COLUMNS($G19:G19))))","v":"Martha"},{"$f":"IF(COLUMNS($G19:H19)>$F19,\"\",INDEX($A$2:$A$12,SMALL(IF($B$2:$B$12=$E19,ROW($B$2:$B$12)-ROW($B$2)+1),COLUMNS($G19:H19))))","v":""},{"$f":"IF(COLUMNS($G19:I19)>$F19,\"\",INDEX($A$2:$A$12,SMALL(IF($B$2:$B$12=$E19,ROW($B$2:$B$12)-ROW($B$2)+1),COLUMNS($G19:I19))))","v":""}]
[]
[null,null,null,null,"To learn the basics of array formulas, see this playlist of videos:"]
[null,null,null,null,"http://www.youtube.com/view_play_list?p=007E7E9CA63304D3"]

{"sheet":"(617)","index":4,"n_rows":545,"n_cols":7,"rows_kept":545,"cut":false,"hidden":false,"merged":[]}
["Date","Sales",null,{"$f":"\"Fiscal Year \"&TEXT(D2,\"m/d/yyy\")&\" to \"&TEXT(D3,\"m/d/yyy\")","v":"Fiscal Year 7/1/2008 to 6/30/2009"},"% Change",{"$f":"\"Fiscal Year \"&TEXT(F2,\"m/d/yyy\")&\" to \"&TEXT(F3,\"m/d/yyy\")","v":"Fiscal Year 7/1/2009 to 6/30/2010"},"% Change"]
["2009-09-06",1087.9000000000001,null,"2008-07-01",null,"2009-07-01"]
["2009-07-17",1017.49,null,"2009-06-30",null,"2010-06-30"]
["2009-01-16",1312.67]
["2009-03-02",1388.51]
["2009-07-12",1110.27]
["2010-08-14",1405.81]
["2009-07-29",1008.35,null,"Other videos on Year Over Year Calculations:"]
["2009-02-19",1215.3399999999999,null,"Excel Magic Trick 610: Pivot Table Year Over Year Sales "]
["2009-11-03",1423.3,null,"Excel Magic Trick 611: Array Formula Year Over Year Sales"]
["2009-01-20",1290.49,null,"Excel Magic Trick 612: Pivot Table Year Over Year Sales"]
["2009-06-02",1042.0899999999999,null,"Excel Magic Trick 613: Array Formula Year Over Year Sales"]
["2010-05-24",1400.75,null,"Excel Magic Trick 614: Extract Full Date from Monthly Dates Listed"]
["2010-07-10",1114.3599999999999]
["2010-06-24",1446.59]
["2009-05-21",1304.45]
["2009-02-11",1068.44]
["2009-07-28",1308.01]
["2009-05-07",1280.95]
["2009-05-08",1484.56]
["2009-02-27",1383.77]
["2009-04-06",1018.08]
["2010-09-04",1355.51]
["2009-03-15",1117.73]
["2009-08-15",1391.54]
["2009-02-08",1467.27]
["2009-04-01",1321.07]
["2009-01-05",1383.84]
["2010-12-26",1226.51]
["2009-06-08",1286.05]
["2010-07-03",1297.8599999999999]
["2010-02-16",1457.7]
["2009-02-20",1116.25]
["2009-12-13",1245.44]
["2009-05-28",1385.4]
["2009-09-10",1041.94]
["2009-09-16",1096.57]
["2010-12-26",1375.5]
["2009-10-16",1108.6400000000001]
["2009-01-22",1130.69]
["2009-04-14",1212.55]
["2009-01-17",1348.25]
["2009-01-06",1225.3800000000001]
["2009-01-07",1248.42]
["2009-11-22",1494.23]
["2009-04-13",1289.22]
["2009-06-04",1083.08]
["2010-05-17",1218.71]
["2009-10-11",1030.53]
["2010-07-20",1359.39]
["2010-04-22",1244.07]
["2010-06-26",1451.54]
["2009-06-12",1228.21]
["2009-03-03",1437.63]
["2009-11-15",1281.8]
["2009-06-11",1341.74]
["2009-05-14",1205.79]
["2009-07-29",1155.1600000000001]
["2009-04-18",1470.95]
["2010-07-14",1045.83]
["2010-06-11",1439.15]
["2009-01-14",1086.33]
["2010-08-15",1351.41]
["2009-06-01",1091.42]
["2010-02-22",1061.3699999999999]
["2010-05-06",1442.3]
["2010-06-18",1255.83]
["2009-12-24",1445.97]
["2010-06-21",1383.12]
["2010-02-10",1263.6500000000001]
["2009-07-03",1179.1300000000001]
["2010-05-10",1004.04]
["2009-10-16",1346.24]
["2009-03-26",1337.73]
["2009-10-01",1466.77]
["2009-06-11",1186.9100000000001]
["2009-01-06",1391.77]
["2010-06-13",1399.23]
["2010-07-20",1141.8599999999999]
["2009-12-23",1295.1500000000001]
["2009-01-17",1003.4]
["2009-01-09",1230.1500000000001]
["2009-12-18",1313.49]
["2010-02-24",1096.1400000000001]
["2010-05-28",1407.82]
["2009-09-07",1436.33]
["2009-06-20",1168.32]
["2009-10-25",1437.11]
["2010-06-25",1161.52]
["2009-01-07",1475.39]
["2009-07-27",1115.8]
["2009-10-09",1438.84]
["2009-06-03",1112.18]
["2009-10-09",1383.05]
["2009-07-05",1313.72]
["2010-09-13",1094.5]
["2010-05-04",1486.17]
["2009-05-04",1333.94]
["2009-11-16",1011.41]
["2009-07-17",1483.01]
["2009-05-15",1409.3]
["2010-08-30",1257.81]
["2009-01-31",1403.19]
["2010-05-29",1456.38]
["2009-12-19",1298.21]
["2010-09-09",1054.57]
["2009-11-21",1360.89]
["2010-07-23",1180.1199999999999]
["2009-12-30",1051]
["2009-07-08",1182.57]
["2009-05-12",1469.3]
["2009-11-29",1386.26]
["2010-02-25",1323.42]
["2009-01-30",1102.3699999999999]
["2009-07-12",1210.02]
["2009-08-17",1392]
["2010-06-08",1020.41]
["2009-07-28",1436.53]
["2009-04-15",1284.77]
["2009-04-07",1150.83]
["2010-12-27",1438.18]
["2010-02-06",1256.8]
["2009-09-01",1178.1099999999999]
["2009-12-16",1024.56]
["2009-08-17",1455.57]
["2010-05-09",1416.75]
["2010-02-19",1496.21]
["2009-05-11",1386.36]
["2009-07-26",1187.83]
["2009-07-23",1008.96]
["2009-11-12",1295.98]
["2010-07-24",1250.9100000000001]
["2009-03-03",1280.53]
["2009-08-05",1333.88]
["2009-07-29",1011.56]
["2009-01-26",1207.3399999999999]
["2009-09-15",1162.96]
["2009-12-08",1303.6400000000001]
["2010-02-17",1409.64]
["2010-05-06",1334.09]
["2010-02-14",1328.26]
["2010-05-27",1263.01]
["2009-10-25",1089.8699999999999]
["2010-06-12",1366.6]
["2010-09-03",1207.53]
["2010-09-14",1011.4]
["2009-12-05",1459.01]
["2009-07-03",1213.69]
["2009-11-05",1071.67]
["2009-04-08",1140.44]
["2009-03-21",1211.46]
["2009-07-22",1052.1300000000001]
["2010-02-17",1445.86]
["2009-01-14",1095.6400000000001]
["2009-10-06",1288.6099999999999]
["2009-08-14",1238.95]
["2009-08-06",1277.75]
["2009-08-21",1286.72]
["2009-09-13",1058.8900000000001]
["2010-08-28",1091.1199999999999]
["2010-02-14",1091.92]
["2009-01-01",1158.6099999999999]
["2009-12-13",1463.15]
["2009-05-13",1366.77]
["2010-08-05",1145.18]
["2009-01-16",1389.3]
["2010-04-30",1481.01]
["2010-05-02",1252.53]
["2010-06-25",1311.28]
["2009-12-24",1390.95]
["2010-02-24",1380.14]
["2009-07-11",1181.7]
["2009-08-13",1081.58]
["2010-02-16",1114.73]
["2009-09-01",1100.4000000000001]
["2009-06-14",1106.8800000000001]
["2009-05-02",1390.33]
["2009-02-03",1339.08]
["2009-05-19",1256.08]
["2010-05-17",1048.5899999999999]
["2009-10-28",1039.43]
["2009-06-03",1000.88]
["2009-09-03",1213.56]
["2009-06-15",1449.11]
["2009-01-07",1104.57]
["2010-12-21",1349.05]
["2010-05-13",1084.3900000000001]
["2009-01-07",1255.8699999999999]
["2009-03-18",1002.69]
["2010-06-10",1341.14]
["2009-07-27",1446.4]
["2010-05-08",1287.94]
["2010-02-26",1488.42]
["2009-05-18",1179.43]
["2009-02-15",1107.54]
["2010-02-11",1313.14]
["2010-07-07",1075.45]
["2010-12-25",1021.29]
["2010-05-19",1016.07]
["2009-07-15",1180.69]
["2009-06-20",1294.48]
["2009-11-23",1328.64]
["2010-12-22",1053.58]
["2009-11-24",1361.57]
["2010-07-16",1243.27]
["2010-07-06",1331.31]
["2009-11-05",1258.17]
["2010-08-11",1336.68]
["2010-06-14",1087.24]
["2010-02-24",1078.31]
["2009-01-07",1050.1400000000001]
["2009-05-21",1262.22]
["2009-04-20",1042.1500000000001]
["2010-08-16",1224.75]
["2009-08-12",1200]
["2009-05-27",1166.8]
["2010-06-03",1233.19]
["2009-01-07",1115.72]
["2009-01-29",1166.42]
["2009-10-03",1380.54]
["2010-04-26",1276.0899999999999]
["2009-07-02",1335.73]
["2010-04-30",1476.91]
["2009-11-18",1004.68]
["2009-02-22",1006.72]
["2009-04-04",1210.8900000000001]
["2010-08-22",1426.11]
["2009-03-12",1117.8800000000001]
["2009-02-06",1016.41]
["2009-01-26",1310.72]
["2009-02-17",1336.81]
["2009-12-07",1383.51]
["2010-04-29",1104.6400000000001]
["2010-07-09",1439.75]
["2009-12-12",1256.8399999999999]
["2010-08-15",1432.28]
["2009-03-19",1392.76]
["2009-11-24",1452.59]
["2009-09-01",1033.28]
["2009-12-19",1494.3]
["2010-08-05",1410.8]
["2009-02-16",1150.2]
["2009-05-31",1421.83]
["2010-02-25",1085.8900000000001]
["2009-04-13",1415.89]
["2009-04-10",1434.39]
["2009-02-05",1298.75]
["2010-05-14",1349.46]
["2009-02-01",1252.28]
["2009-11-15",1198.8699999999999]
["2009-01-09",1114.6600000000001]
["2009-12-20",1357.3]
["2009-10-04",1465.81]
["2009-07-31",1426.25]
["2009-04-22",1182.73]
["2010-08-01",1419.62]
["2009-06-28",1053.4000000000001]
["2010-06-21",1360.03]
["2009-03-10",1323.02]
["2010-05-20",1329.81]
["2009-02-16",1350.97]
["2009-07-14",1038.0899999999999]
["2009-10-31",1292.1300000000001]
["2009-08-08",1148.48]
["2009-05-09",1385.94]
["2009-10-18",1468.17]
["2009-04-23",1036.99]
["2009-09-28",1210.42]
["2009-10-08",1443.55]
["2009-10-25",1369.77]
["2009-07-13",1201.6199999999999]
["2010-08-04",1455.32]
["2009-01-09",1341.37]
["2010-02-13",1294.8699999999999]
["2010-02-25",1408.4]
["2010-06-14",1157.3599999999999]
["2010-02-22",1461.69]
["2009-09-05",1115.26]
["2009-01-12",1263.8699999999999]
["2010-02-15",1054.97]
["2009-12-20",1032.6600000000001]
["2009-05-04",1112.23]
["2010-09-12",1117.93]
["2009-08-30",1257.94]
["2009-03-04",1309.98]
["2009-01-05",1328.45]
["2009-12-04",1000.49]
["2009-04-18",1386.41]
["2009-10-06",1174.1500000000001]
["2009-06-04",1373.32]
["2009-02-12",1201.75]
["2009-07-31",1123.98]
["2009-01-03",1250.74]
["2009-12-20",1067.3499999999999]
["2009-04-21",1359.46]
["2009-08-21",1469]
["2009-09-05",1432.41]
["2009-07-07",1098.98]
["2010-06-15",1430.07]
["2009-05-15",1470.17]
["2009-06-25",1011.21]
["2009-01-12",1089.3599999999999]
["2009-04-01",1188.03]
["2009-02-02",1486.5]
["2010-05-17",1194.56]
["2009-06-22",1355.71]
["2010-05-18",1114.55]
["2009-08-06",1295.4000000000001]
["2009-08-11",1482.88]
["2009-07-29",1057.3699999999999]
["2009-07-12",1022.54]
["2010-08-31",1345.83]
["2009-10-06",1232.23]
["2009-02-27",1343.07]
["2009-04-11",1472.45]
["2009-04-05",1277.19]
["2010-09-06",1366.84]
["2009-03-26",1151.8699999999999]
["2009-02-13",1033.79]
["2009-12-14",1476.17]
["2010-08-08",1317.74]
["2009-10-13",1494.9]
["2010-07-11",1102.3499999999999]
["2010-07-25",1147.4100000000001]
["2010-09-11",1332.2]
["2009-01-11",1149.21]
["2009-01-26",1353.8]
["2009-10-28",1134.8900000000001]
["2009-06-14",1173.1600000000001]
["2009-02-28",1346.73]
["2009-06-20",1168.71]
["2009-03-21",1164.8900000000001]
["2009-02-03",1362.35]
["2009-01-16",1189.51]
["2010-05-05",1032.0899999999999]
["2009-03-24",1191.78]
["2009-07-13",1120.5999999999999]
["2009-02-18",1171.45]
["2009-09-25",1484.11]
["2010-05-08",1034.28]
["2010-02-22",1313.73]
["2009-10-28",1449.49]
["2009-12-21",1231.19]
["2009-07-26",1450.7]
["2010-08-28",1209.97]
["2010-08-05",1088.75]
["2009-05-24",1118.1600000000001]
["2009-02-01",1273.21]
["2009-08-31",1088.21]
["2009-02-20",1257.03]
["2009-12-05",1021.26]
["2009-06-26",1473.55]
["2010-08-05",1409.01]
["2009-01-27",1153.8399999999999]
["2009-12-24",1019]
["2009-02-27",1437.35]
["2009-04-24",1454.21]
["2009-11-18",1245.2]
["2010-06-24",1114.56]
["2010-05-31",1283.07]
["2009-12-25",1065.68]
["2009-07-16",1113.08]
["2010-09-05",1085.0999999999999]
["2009-03-04",1061.75]
["2010-02-25",1387.96]
["2009-09-14",1497.34]
["2010-06-15",1110.47]
["2010-06-02",1032.27]
["2009-09-24",1212.8499999999999]
["2009-12-23",1196.01]
["2010-04-25",1209.54]
["2009-09-18",1211.73]
["2010-12-28",1195.48]
["2009-05-11",1145.1500000000001]
["2010-08-18",1139.97]
["2010-06-07",1324.74]
["2010-07-25",1164.29]
["2010-07-24",1127.67]
["2009-05-19",1284.77]
["2010-07-03",1176.8]
["2009-03-30",1127.51]
["2010-12-30",1330.53]
["2010-05-07",1222.45]
["2009-08-18",1122.6500000000001]
["2009-08-21",1342.56]
["2009-05-02",1218.6300000000001]
["2009-06-24",1484.78]
["2009-05-29",1476.87]
["2009-10-16",1201.1300000000001]
["2009-07-13",1115.48]
["2009-05-07",1105.5]
["2009-03-27",1382.05]
["2009-01-14",1414.11]
["2010-06-05",1444.06]
["2010-06-23",1016.89]
["2009-08-16",1077.97]
["2010-08-19",1270.1199999999999]
["2009-09-23",1245.1400000000001]
["2010-08-24",1341.8]
["2009-09-20",1270.9100000000001]
["2010-02-17",1144.3599999999999]
["2009-04-17",1374.1]
["2009-07-13",1070.29]
["2010-09-03",1220.94]
["2009-01-18",1276.48]
["2010-06-10",1180.17]
["2009-01-08",1194.18]
["2009-02-01",1062.44]
["2009-07-09",1490.01]
["2009-05-08",1178.5999999999999]
["2010-08-20",1153.8800000000001]
["2009-08-16",1100.25]
["2009-01-16",1196.1300000000001]
["2009-01-07",1281.3399999999999]
["2010-06-11",1422.8]
["2010-06-01",1079.5]
["2010-08-09",1255.8900000000001]
["2010-06-07",1173.54]
["2010-05-13",1267.68]
["2009-09-29",1465.98]
["2009-10-03",1043.82]
["2009-06-03",1083.58]
["2009-03-29",1074.57]
["2010-08-20",1436.3]
["2009-05-01",1046.57]
["2010-09-10",1041.3499999999999]
["2009-01-15",1128.57]
["2009-06-16",1325.09]
["2009-02-06",1314.32]
["2009-08-12",1463.3]
["2009-09-03",1397.67]
["2009-02-08",1337.46]
["2010-08-28",1219.7]
["2009-01-07",1411.12]
["2009-11-18",1130.7]
["2009-03-21",1278.6600000000001]
["2009-06-30",1057.4100000000001]
["2009-11-22",1363.07]
["2009-05-26",1461.54]
["2010-05-01",1152.47]
["2009-11-21",1170.05]
["2009-07-30",1120.92]
["2009-04-07",1439.88]
["2009-04-24",1354.99]
["2010-05-18",1436.96]
["2010-08-25",1167.96]
["2009-01-25",1384.8]
["2010-08-21",1446.89]
["2010-05-26",1408.04]
["2010-07-13",1185.45]
["2009-05-22",1358.78]
["2009-01-11",1477.75]
["2010-12-25",1189.74]
["2009-04-26",1472.01]
["2009-09-22",1342.3]
["2010-05-24",1313.71]
["2009-05-02",1277.17]
["2010-07-16",1284.75]
["2010-07-05",1058.74]
["2009-01-12",1110.27]
["2009-03-08",1354.47]
["2010-08-01",1264.01]
["2009-02-23",1383.5]
["2009-01-10",1473.89]
["2009-07-20",1090.8699999999999]
["2009-10-27",1285.82]
["2010-08-02",1416.86]
["2009-03-09",1333.53]
["2009-04-18",1029.21]
["2010-08-13",1314.56]
["2010-12-27",1361.89]
["2009-12-21",1257.96]
["2010-04-26",1248.79]
["2009-01-10",1343.93]
["2010-02-22",1135.19]
["2009-06-16",1097.18]
["2009-03-09",1351.97]
["2009-11-19",1296.73]
["2010-02-17",1191.04]
["2009-01-13",1483.7]
["2010-07-17",1127.77]
["2009-06-07",1398.44]
["2009-10-14",1347.52]
["2010-08-25",1202.8800000000001]
["2009-01-24",1235.96]
["2010-09-05",1123.07]
["2009-04-29",1327.5]
["2009-11-12",1003.41]
["2010-07-13",1121.8599999999999]
["2010-08-13",1221.8399999999999]
["2009-04-03",1458.24]
["2009-01-08",1229.72]
["2009-08-22",1270.05]
["2010-02-07",1170.99]
["2009-04-20",1495.33]
["2010-09-06",1109.6300000000001]
["2009-04-18",1022.65]
["2009-05-25",1432.55]
["2009-08-29",1173.54]
["2009-02-25",1364.28]
["2009-01-21",1403.06]
["2010-07-21",1040.32]
["2009-10-02",1061.99]
["2009-07-03",1231.5]
["2009-07-16",1330.62]
["2010-06-09",1264.5899999999999]
["2009-04-28",1424.42]
["2009-06-11",1277.06]
["2010-09-05",1235.19]
["2010-05-14",1411.62]
["2010-06-09",1171.56]
["2009-01-10",1379.96]
["2009-01-28",1477.33]
["2009-06-21",1484.27]
["2009-11-10",1363.04]
["2009-05-07",1092.6300000000001]
["2009-11-01",1179.7]
["2009-05-24",1263.69]
["2009-07-09",1142.5899999999999]
["2009-05-28",1367.9]
["2009-03-07",1092.43]
["2009-10-08",1260.3699999999999]
["2009-09-02",1198.48]
["2009-07-27",1490.55]
["2009-04-29",1378.7]
["2009-05-09",1412.63]
["2009-03-18",1064.3900000000001]
["2009-08-29",1209.96]
["2009-05-11",1184.8800000000001]
["2010-07-27",1388.24]
["2009-03-05",1064.07]
["2009-11-12",1052.1400000000001]
["2009-07-22",1472.99]
["2009-12-08",1341.64]
["2009-12-19",1483.86]
["2009-09-28",1069.06]
["2009-09-16",1352.24]
["2009-04-21",1129.93]
["2009-12-13",1391.16]
["2009-06-10",1411.11]
["2009-11-30",1195.8499999999999]
["2010-06-10",1340.52]
["2010-09-08",1411.09]
["2009-12-08",1021.29]
["2009-08-11",1489.43]

{"sheet":"(617an)","index":5,"n_rows":545,"n_cols":7,"rows_kept":545,"cut":false,"hidden":false,"merged":[]}
["Date","Sales",null,{"$f":"\"Fiscal Year \"&TEXT(D2,\"m/d/yyy\")&\" to \"&TEXT(D3,\"m/d/yyy\")","v":"Fiscal Year 7/1/2008 to 6/30/2009"},"% Change",{"$f":"\"Fiscal Year \"&TEXT(F2,\"m/d/yyy\")&\" to \"&TEXT(F3,\"m/d/yyy\")","v":"Fiscal Year 7/1/2009 to 6/30/2010"},"% Change"]
["2009-09-06",1087.9000000000001,null,"2008-07-01",null,"2009-07-01"]
["2009-07-17",1017.49,null,"2009-06-30",null,"2010-06-30"]
["2009-01-16",1312.67,null,{"$f":"SUMIFS($B$2:$B$545,$A$2:$A$545,\">=\"&D2,$A$2:$A$545,\"<=\"&D3)","v":256295.55999999997},{"$f":"D4/$D4-1","v":0},{"$f":"SUMIFS($B$2:$B$545,$A$2:$A$545,\">=\"&F2,$A$2:$A$545,\"<=\"&F3)","v":328452.89999999991},{"$f":"F4/$D4-1","v":0.2815395631512303}]
["2009-03-02",1388.51,null,{"$f":"SUMPRODUCT(--($A$2:$A$545>=D2),--($A$2:$A$545<=D3),$B$2:$B$545)","v":256295.55999999997},{"$f":"D5/$D5-1","v":0},{"$f":"SUMPRODUCT(--($A$2:$A$545>=F2),--($A$2:$A$545<=F3),$B$2:$B$545)","v":328452.89999999991},{"$f":"F5/$D5-1","v":0.2815395631512303}]
["2009-07-12",1110.27]
["2010-08-14",1405.81]
["2009-07-29",1008.35,null,"Other videos on Year Over Year Calculations:"]
["2009-02-19",1215.3399999999999,null,"Excel Magic Trick 610: Pivot Table Year Over Year Sales "]
["2009-11-03",1423.3,null,"Excel Magic Trick 611: Array Formula Year Over Year Sales"]
["2009-01-20",1290.49,null,"Excel Magic Trick 612: Pivot Table Year Over Year Sales"]
["2009-06-02",1042.0899999999999,null,"Excel Magic Trick 613: Array Formula Year Over Year Sales"]
["2010-05-24",1400.75,null,"Excel Magic Trick 614: Extract Full Date from Monthly Dates Listed"]
["2010-07-10",1114.3599999999999]
["2010-06-24",1446.59]
["2009-05-21",1304.45]
["2009-02-11",1068.44]
["2009-07-28",1308.01]
["2009-05-07",1280.95]
["2009-05-08",1484.56]
["2009-02-27",1383.77]
["2009-04-06",1018.08]
["2010-09-04",1355.51]
["2009-03-15",1117.73]
["2009-08-15",1391.54]
["2009-02-08",1467.27]
["2009-04-01",1321.07]
["2009-01-05",1383.84]
["2010-12-26",1226.51]
["2009-06-08",1286.05]
["2010-07-03",1297.8599999999999]
["2010-02-16",1457.7]
["2009-02-20",1116.25]
["2009-12-13",1245.44]
["2009-05-28",1385.4]
["2009-09-10",1041.94]
["2009-09-16",1096.57]
["2010-12-26",1375.5]
["2009-10-16",1108.6400000000001]
["2009-01-22",1130.69]
["2009-04-14",1212.55]
["2009-01-17",1348.25]
["2009-01-06",1225.3800000000001]
["2009-01-07",1248.42]
["2009-11-22",1494.23]
["2009-04-13",1289.22]
["2009-06-04",1083.08]
["2010-05-17",1218.71]
["2009-10-11",1030.53]
["2010-07-20",1359.39]
["2010-04-22",1244.07]
["2010-06-26",1451.54]
["2009-06-12",1228.21]
["2009-03-03",1437.63]
["2009-11-15",1281.8]
["2009-06-11",1341.74]
["2009-05-14",1205.79]
["2009-07-29",1155.1600000000001]
["2009-04-18",1470.95]
["2010-07-14",1045.83]
["2010-06-11",1439.15]
["2009-01-14",1086.33]
["2010-08-15",1351.41]
["2009-06-01",1091.42]
["2010-02-22",1061.3699999999999]
["2010-05-06",1442.3]
["2010-06-18",1255.83]
["2009-12-24",1445.97]
["2010-06-21",1383.12]
["2010-02-10",1263.6500000000001]
["2009-07-03",1179.1300000000001]
["2010-05-10",1004.04]
["2009-10-16",1346.24]
["2009-03-26",1337.73]
["2009-10-01",1466.77]
["2009-06-11",1186.9100000000001]
["2009-01-06",1391.77]
["2010-06-13",1399.23]
["2010-07-20",1141.8599999999999]
["2009-12-23",1295.1500000000001]
["2009-01-17",1003.4]
["2009-01-09",1230.1500000000001]
["2009-12-18",1313.49]
["2010-02-24",1096.1400000000001]
["2010-05-28",1407.82]
["2009-09-07",1436.33]
["2009-06-20",1168.32]
["2009-10-25",1437.11]
["2010-06-25",1161.52]
["2009-01-07",1475.39]
["2009-07-27",1115.8]
["2009-10-09",1438.84]
["2009-06-03",1112.18]
["2009-10-09",1383.05]
["2009-07-05",1313.72]
["2010-09-13",1094.5]
["2010-05-04",1486.17]
["2009-05-04",1333.94]
["2009-11-16",1011.41]
["2009-07-17",1483.01]
["2009-05-15",1409.3]
["2010-08-30",1257.81]
["2009-01-31",1403.19]
["2010-05-29",1456.38]
["2009-12-19",1298.21]
["2010-09-09",1054.57]
["2009-11-21",1360.89]
["2010-07-23",1180.1199999999999]
["2009-12-30",1051]
["2009-07-08",1182.57]
["2009-05-12",1469.3]
["2009-11-29",1386.26]
["2010-02-25",1323.42]
["2009-01-30",1102.3699999999999]
["2009-07-12",1210.02]
["2009-08-17",1392]
["2010-06-08",1020.41]
["2009-07-28",1436.53]
["2009-04-15",1284.77]
["2009-04-07",1150.83]
["2010-12-27",1438.18]
["2010-02-06",1256.8]
["2009-09-01",1178.1099999999999]
["2009-12-16",1024.56]
["2009-08-17",1455.57]
["2010-05-09",1416.75]
["2010-02-19",1496.21]
["2009-05-11",1386.36]
["2009-07-26",1187.83]
["2009-07-23",1008.96]
["2009-11-12",1295.98]
["2010-07-24",1250.9100000000001]
["2009-03-03",1280.53]
["2009-08-05",1333.88]
["2009-07-29",1011.56]
["2009-01-26",1207.3399999999999]
["2009-09-15",1162.96]
["2009-12-08",1303.6400000000001]
["2010-02-17",1409.64]
["2010-05-06",1334.09]
["2010-02-14",1328.26]
["2010-05-27",1263.01]
["2009-10-25",1089.8699999999999]
["2010-06-12",1366.6]
["2010-09-03",1207.53]
["2010-09-14",1011.4]
["2009-12-05",1459.01]
["2009-07-03",1213.69]
["2009-11-05",1071.67]
["2009-04-08",1140.44]
["2009-03-21",1211.46]
["2009-07-22",1052.1300000000001]
["2010-02-17",1445.86]
["2009-01-14",1095.6400000000001]
["2009-10-06",1288.6099999999999]
["2009-08-14",1238.95]
["2009-08-06",1277.75]
["2009-08-21",1286.72]
["2009-09-13",1058.8900000000001]
["2010-08-28",1091.1199999999999]
["2010-02-14",1091.92]
["2009-01-01",1158.6099999999999]
["2009-12-13",1463.15]
["2009-05-13",1366.77]
["2010-08-05",1145.18]
["2009-01-16",1389.3]
["2010-04-30",1481.01]
["2010-05-02",1252.53]
["2010-06-25",1311.28]
["2009-12-24",1390.95]
["2010-02-24",1380.14]
["2009-07-11",1181.7]
["2009-08-13",1081.58]
["2010-02-16",1114.73]
["2009-09-01",1100.4000000000001]
["2009-06-14",1106.8800000000001]
["2009-05-02",1390.33]
["2009-02-03",1339.08]
["2009-05-19",1256.08]
["2010-05-17",1048.5899999999999]
["2009-10-28",1039.43]
["2009-06-03",1000.88]
["2009-09-03",1213.56]
["2009-06-15",1449.11]
["2009-01-07",1104.57]
["2010-12-21",1349.05]
["2010-05-13",1084.3900000000001]
["2009-01-07",1255.8699999999999]
["2009-03-18",1002.69]
["2010-06-10",1341.14]
["2009-07-27",1446.4]
["2010-05-08",1287.94]
["2010-02-26",1488.42]
["2009-05-18",1179.43]
["2009-02-15",1107.54]
["2010-02-11",1313.14]
["2010-07-07",1075.45]
["2010-12-25",1021.29]
["2010-05-19",1016.07]
["2009-07-15",1180.69]
["2009-06-20",1294.48]
["2009-11-23",1328.64]
["2010-12-22",1053.58]
["2009-11-24",1361.57]
["2010-07-16",1243.27]
["2010-07-06",1331.31]
["2009-11-05",1258.17]
["2010-08-11",1336.68]
["2010-06-14",1087.24]
["2010-02-24",1078.31]
["2009-01-07",1050.1400000000001]
["2009-05-21",1262.22]
["2009-04-20",1042.1500000000001]
["2010-08-16",1224.75]
["2009-08-12",1200]
["2009-05-27",1166.8]
["2010-06-03",1233.19]
["2009-01-07",1115.72]
["2009-01-29",1166.42]
["2009-10-03",1380.54]
["2010-04-26",1276.0899999999999]
["2009-07-02",1335.73]
["2010-04-30",1476.91]
["2009-11-18",1004.68]
["2009-02-22",1006.72]
["2009-04-04",1210.8900000000001]
["2010-08-22",1426.11]
["2009-03-12",1117.8800000000001]
["2009-02-06",1016.41]
["2009-01-26",1310.72]
["2009-02-17",1336.81]
["2009-12-07",1383.51]
["2010-04-29",1104.6400000000001]
["2010-07-09",1439.75]
["2009-12-12",1256.8399999999999]
["2010-08-15",1432.28]
["2009-03-19",1392.76]
["2009-11-24",1452.59]
["2009-09-01",1033.28]
["2009-12-19",1494.3]
["2010-08-05",1410.8]
["2009-02-16",1150.2]
["2009-05-31",1421.83]
["2010-02-25",1085.8900000000001]
["2009-04-13",1415.89]
["2009-04-10",1434.39]
["2009-02-05",1298.75]
["2010-05-14",1349.46]
["2009-02-01",1252.28]
["2009-11-15",1198.8699999999999]
["2009-01-09",1114.6600000000001]
["2009-12-20",1357.3]
["2009-10-04",1465.81]
["2009-07-31",1426.25]
["2009-04-22",1182.73]
["2010-08-01",1419.62]
["2009-06-28",1053.4000000000001]
["2010-06-21",1360.03]
["2009-03-10",1323.02]
["2010-05-20",1329.81]
["2009-02-16",1350.97]
["2009-07-14",1038.0899999999999]
["2009-10-31",1292.1300000000001]
["2009-08-08",1148.48]
["2009-05-09",1385.94]
["2009-10-18",1468.17]
["2009-04-23",1036.99]
["2009-09-28",1210.42]
["2009-10-08",1443.55]
["2009-10-25",1369.77]
["2009-07-13",1201.6199999999999]
["2010-08-04",1455.32]
["2009-01-09",1341.37]
["2010-02-13",1294.8699999999999]
["2010-02-25",1408.4]
["2010-06-14",1157.3599999999999]
["2010-02-22",1461.69]
["2009-09-05",1115.26]
["2009-01-12",1263.8699999999999]
["2010-02-15",1054.97]
["2009-12-20",1032.6600000000001]
["2009-05-04",1112.23]
["2010-09-12",1117.93]
["2009-08-30",1257.94]
["2009-03-04",1309.98]
["2009-01-05",1328.45]
["2009-12-04",1000.49]
["2009-04-18",1386.41]
["2009-10-06",1174.1500000000001]
["2009-06-04",1373.32]
["2009-02-12",1201.75]
["2009-07-31",1123.98]
["2009-01-03",1250.74]
["2009-12-20",1067.3499999999999]
["2009-04-21",1359.46]
["2009-08-21",1469]
["2009-09-05",1432.41]
["2009-07-07",1098.98]
["2010-06-15",1430.07]
["2009-05-15",1470.17]
["2009-06-25",1011.21]
["2009-01-12",1089.3599999999999]
["2009-04-01",1188.03]
["2009-02-02",1486.5]
["2010-05-17",1194.56]
["2009-06-22",1355.71]
["2010-05-18",1114.55]
["2009-08-06",1295.4000000000001]
["2009-08-11",1482.88]
["2009-07-29",1057.3699999999999]
["2009-07-12",1022.54]
["2010-08-31",1345.83]
["2009-10-06",1232.23]
["2009-02-27",1343.07]
["2009-04-11",1472.45]
["2009-04-05",1277.19]
["2010-09-06",1366.84]
["2009-03-26",1151.8699999999999]
["2009-02-13",1033.79]
["2009-12-14",1476.17]
["2010-08-08",1317.74]
["2009-10-13",1494.9]
["2010-07-11",1102.3499999999999]
["2010-07-25",1147.4100000000001]
["2010-09-11",1332.2]
["2009-01-11",1149.21]
["2009-01-26",1353.8]
["2009-10-28",1134.8900000000001]
["2009-06-14",1173.1600000000001]
["2009-02-28",1346.73]
["2009-06-20",1168.71]
["2009-03-21",1164.8900000000001]
["2009-02-03",1362.35]
["2009-01-16",1189.51]
["2010-05-05",1032.0899999999999]
["2009-03-24",1191.78]
["2009-07-13",1120.5999999999999]
["2009-02-18",1171.45]
["2009-09-25",1484.11]
["2010-05-08",1034.28]
["2010-02-22",1313.73]
["2009-10-28",1449.49]
["2009-12-21",1231.19]
["2009-07-26",1450.7]
["2010-08-28",1209.97]
["2010-08-05",1088.75]
["2009-05-24",1118.1600000000001]
["2009-02-01",1273.21]
["2009-08-31",1088.21]
["2009-02-20",1257.03]
["2009-12-05",1021.26]
["2009-06-26",1473.55]
["2010-08-05",1409.01]
["2009-01-27",1153.8399999999999]
["2009-12-24",1019]
["2009-02-27",1437.35]
["2009-04-24",1454.21]
["2009-11-18",1245.2]
["2010-06-24",1114.56]
["2010-05-31",1283.07]
["2009-12-25",1065.68]
["2009-07-16",1113.08]
["2010-09-05",1085.0999999999999]
["2009-03-04",1061.75]
["2010-02-25",1387.96]
["2009-09-14",1497.34]
["2010-06-15",1110.47]
["2010-06-02",1032.27]
["2009-09-24",1212.8499999999999]
["2009-12-23",1196.01]
["2010-04-25",1209.54]
["2009-09-18",1211.73]
["2010-12-28",1195.48]
["2009-05-11",1145.1500000000001]
["2010-08-18",1139.97]
["2010-06-07",1324.74]
["2010-07-25",1164.29]
["2010-07-24",1127.67]
["2009-05-19",1284.77]
["2010-07-03",1176.8]
["2009-03-30",1127.51]
["2010-12-30",1330.53]
["2010-05-07",1222.45]
["2009-08-18",1122.6500000000001]
["2009-08-21",1342.56]
["2009-05-02",1218.6300000000001]
["2009-06-24",1484.78]
["2009-05-29",1476.87]
["2009-10-16",1201.1300000000001]
["2009-07-13",1115.48]
["2009-05-07",1105.5]
["2009-03-27",1382.05]
["2009-01-14",1414.11]
["2010-06-05",1444.06]
["2010-06-23",1016.89]
["2009-08-16",1077.97]
["2010-08-19",1270.1199999999999]
["2009-09-23",1245.1400000000001]
["2010-08-24",1341.8]
["2009-09-20",1270.9100000000001]
["2010-02-17",1144.3599999999999]
["2009-04-17",1374.1]
["2009-07-13",1070.29]
["2010-09-03",1220.94]
["2009-01-18",1276.48]
["2010-06-10",1180.17]
["2009-01-08",1194.18]
["2009-02-01",1062.44]
["2009-07-09",1490.01]
["2009-05-08",1178.5999999999999]
["2010-08-20",1153.8800000000001]
["2009-08-16",1100.25]
["2009-01-16",1196.1300000000001]
["2009-01-07",1281.3399999999999]
["2010-06-11",1422.8]
["2010-06-01",1079.5]
["2010-08-09",1255.8900000000001]
["2010-06-07",1173.54]
["2010-05-13",1267.68]
["2009-09-29",1465.98]
["2009-10-03",1043.82]
["2009-06-03",1083.58]
["2009-03-29",1074.57]
["2010-08-20",1436.3]
["2009-05-01",1046.57]
["2010-09-10",1041.3499999999999]
["2009-01-15",1128.57]
["2009-06-16",1325.09]
["2009-02-06",1314.32]
["2009-08-12",1463.3]
["2009-09-03",1397.67]
["2009-02-08",1337.46]
["2010-08-28",1219.7]
["2009-01-07",1411.12]
["2009-11-18",1130.7]
["2009-03-21",1278.6600000000001]
["2009-06-30",1057.4100000000001]
["2009-11-22",1363.07]
["2009-05-26",1461.54]
["2010-05-01",1152.47]
["2009-11-21",1170.05]
["2009-07-30",1120.92]
["2009-04-07",1439.88]
["2009-04-24",1354.99]
["2010-05-18",1436.96]
["2010-08-25",1167.96]
["2009-01-25",1384.8]
["2010-08-21",1446.89]
["2010-05-26",1408.04]
["2010-07-13",1185.45]
["2009-05-22",1358.78]
["2009-01-11",1477.75]
["2010-12-25",1189.74]
["2009-04-26",1472.01]
["2009-09-22",1342.3]
["2010-05-24",1313.71]
["2009-05-02",1277.17]
["2010-07-16",1284.75]
["2010-07-05",1058.74]
["2009-01-12",1110.27]
["2009-03-08",1354.47]
["2010-08-01",1264.01]
["2009-02-23",1383.5]
["2009-01-10",1473.89]
["2009-07-20",1090.8699999999999]
["2009-10-27",1285.82]
["2010-08-02",1416.86]
["2009-03-09",1333.53]
["2009-04-18",1029.21]
["2010-08-13",1314.56]
["2010-12-27",1361.89]
["2009-12-21",1257.96]
["2010-04-26",1248.79]
["2009-01-10",1343.93]
["2010-02-22",1135.19]
["2009-06-16",1097.18]
["2009-03-09",1351.97]
["2009-11-19",1296.73]
["2010-02-17",1191.04]
["2009-01-13",1483.7]
["2010-07-17",1127.77]
["2009-06-07",1398.44]
["2009-10-14",1347.52]
["2010-08-25",1202.8800000000001]
["2009-01-24",1235.96]
["2010-09-05",1123.07]
["2009-04-29",1327.5]
["2009-11-12",1003.41]
["2010-07-13",1121.8599999999999]
["2010-08-13",1221.8399999999999]
["2009-04-03",1458.24]
["2009-01-08",1229.72]
["2009-08-22",1270.05]
["2010-02-07",1170.99]
["2009-04-20",1495.33]
["2010-09-06",1109.6300000000001]
["2009-04-18",1022.65]
["2009-05-25",1432.55]
["2009-08-29",1173.54]
["2009-02-25",1364.28]
["2009-01-21",1403.06]
["2010-07-21",1040.32]
["2009-10-02",1061.99]
["2009-07-03",1231.5]
["2009-07-16",1330.62]
["2010-06-09",1264.5899999999999]
["2009-04-28",1424.42]
["2009-06-11",1277.06]
["2010-09-05",1235.19]
["2010-05-14",1411.62]
["2010-06-09",1171.56]
["2009-01-10",1379.96]
["2009-01-28",1477.33]
["2009-06-21",1484.27]
["2009-11-10",1363.04]
["2009-05-07",1092.6300000000001]
["2009-11-01",1179.7]
["2009-05-24",1263.69]
["2009-07-09",1142.5899999999999]
["2009-05-28",1367.9]
["2009-03-07",1092.43]
["2009-10-08",1260.3699999999999]
["2009-09-02",1198.48]
["2009-07-27",1490.55]
["2009-04-29",1378.7]
["2009-05-09",1412.63]
["2009-03-18",1064.3900000000001]
["2009-08-29",1209.96]
["2009-05-11",1184.8800000000001]
["2010-07-27",1388.24]
["2009-03-05",1064.07]
["2009-11-12",1052.1400000000001]
["2009-07-22",1472.99]
["2009-12-08",1341.64]
["2009-12-19",1483.86]
["2009-09-28",1069.06]
["2009-09-16",1352.24]
["2009-04-21",1129.93]
["2009-12-13",1391.16]
["2009-06-10",1411.11]
["2009-11-30",1195.8499999999999]
["2010-06-10",1340.52]
["2010-09-08",1411.09]
["2009-12-08",1021.29]
["2009-08-11",1489.43]

{"sheet":"(618)","index":6,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["David \"Excel Master\" Rosenthal"]
[]
["Ctrl + ;","Today's date hard coded"]
["Ctrl + Shift ;","Today's time hard coded"]
[{"$f":"A3&\" + space + \"&A4","v":"Ctrl + ; + space + Ctrl + Shift ;"},"Today's date and time hard coded"]
[]
[]
[]
[]
[]
[]
["Ctrl + Shift + ~","General Number Format"]

{"sheet":"(618an)","index":7,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["David \"Excel Master\" Rosenthal"]
[]
["Ctrl + ;","Today's date hard coded"]
["Ctrl + Shift ;","Today's time hard coded"]
[{"$f":"A3&\" + space + \"&A4","v":"Ctrl + ; + space + Ctrl + Shift ;"},"Today's date and time hard coded"]
[]
["2010-06-04"]
["10:10:00"]
["2010-06-04T10:10:00"]
[]
[]
["Ctrl + Shift + ~","General Number Format"]

{"sheet":"(619)","index":8,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["COUNTA",null,"CLEAN removes non-printing Characters - so a space remains in cell. COUNTA only counts empty cells.","TRIM removes all spaces except a single space between each word. If you trim a space, the TRIM function delivers a blank to a cell - which is considered something by the COUNTA function."]
["Data",null,"CLEAN","TRIM"]
[2,null,null,null,null,null,"Ctrl + H for Replace","COUNTIF function"]
["red",null,null,null,null,null,2,2]
[" ","<< Space",null,null," {\" \",\"<< Space\",\" \",\"\"}",null,"red","red"]
["rad",null,null,null,null,null," "," "]
[23,null,null,null,null,null,"rad","rad"]
[{"$f":"COUNTA(A3:A7)","v":5},null,null,null,null,null,23,23]
[null,null,null,null,null,null,{"$f":"COUNTA(G4:G8)","v":5}]
["COUNTA counts all non-empty cells. Cells with a space or a blank delivered by a formula are not considered empty."]

{"sheet":"(619an)","index":9,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["COUNTA",null,"CLEAN removes non-printing Characters - so a space remains in cell. COUNTA only counts empty cells.","TRIM removes all spaces except a single space between each word. If you trim a space, the TRIM function delivers a blank to a cell - which is considered something by the COUNTA function."]
["Data",null,"CLEAN","TRIM"]
[2,null,{"$f":"CLEAN(A3)","v":"2"},{"$f":"TRIM(A3)","v":"2"},null,null,"Ctrl + H for Replace","COUNTIF function"]
["red",null,{"$f":"CLEAN(A4)","v":"red"},{"$f":"TRIM(A4)","v":"red"},null,null,2,2]
[" ","<< Space"," ",""," {\" \",\"<< Space\",\" \",\"\"}",null,"red","red"]
["rad",null,"rad","rad",null,null,null," "]
[23,null,"23","23",null,null,"rad","rad"]
[{"$f":"COUNTA(A3:A7)","v":5},null,{"$f":"COUNTA(C3:C7)","v":5},{"$f":"COUNTA(D3:D7)","v":5},null,null,23,23]
[null,null,null,null,null,null,{"$f":"COUNTA(G4:G8)","v":4},{"$f":"COUNTIF(H4:H8,\"<>\"&\" \")","v":4}]
["COUNTA counts all non-empty cells. Cells with a space or a blank delivered by a formula are not considered empty."]

{"sheet":"(620)","index":10,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Names",null,"Count Unique"]
["Sioux",null,null," =SUMPRODUCT((A2:A13<>\"\")/COUNTIF(A2:A13,A2:A13&\"\"))"]
["Sioux",null,null," =SUMPRODUCT(1/COUNTIF(A2:A13,A2:A13&\"\"))",null,"The (A2:A13<>\"\") part avoids counting one of the empty cells as a unique value"]
["Sioux",null,null," =SUMPRODUCT(1/COUNTIF(A2:A13,A2:A13))",null,"The &\"\" avoids the Divide by zero error cause by the empty cell in the denominator"]
["Sue"]
[2]
["Jo"]
["Jo"]
["Joe"]
[]
["Joe"]
["Sue"]
[]
[]
["Names",null,"Count Unique"]
["Sioux",null,{"$f":"SUMPRODUCT((A16:A27<>\"\")/COUNTIF(A16:A27,A16:A27&\"\"))","v":5.833333333333333}," =SUMPRODUCT((A16:A27<>\"\")/COUNTIF(A16:A27,A16:A27&\"\"))"]
["Sioux",null,{"$f":"SUMPRODUCT(1/COUNTIF(A16:A27,A16:A27&\"\"))","v":6.833333333333333}," =SUMPRODUCT(1/COUNTIF(A16:A27,A16:A27&\"\"))",null,"The (A2:A13<>\"\") part avoids counting one of the empty cells as a unique value"]
["*Sioux",null,{"$f":"SUMPRODUCT(1/COUNTIF(A16:A27,A16:A27))","v":{"$error":"#DIV/0!"}}," =SUMPRODUCT(1/COUNTIF(A16:A27,A16:A27))",null,"The &\"\" avoids the Divide by zero error cause by the empty cell in the denominator"]
["Sue"]
[2,null,"This formula works if you have wild cards"]
["Jo",null,null," =SUM(IF(FREQUENCY(IF(A16:A27<>\"\",MATCH(\"~\"&A16:A27,A16:A27&\"\",0)),ROW(A16:A27)-ROW(A16)+1),1))"]
["*Jo"]
["Joe"]
[]
[null,null,"To learn the basics of array formulas, see this playlist of videos:"]
[null,null,"http://www.youtube.com/view_play_list?p=007E7E9CA63304D3"]

{"sheet":"(620an)","index":11,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Names",null,"Count Unique"]
["Sioux",null,{"$f":"SUMPRODUCT((A2:A13<>\"\")/COUNTIF(A2:A13,A2:A13&\"\"))","v":5}," =SUMPRODUCT((A2:A13<>\"\")/COUNTIF(A2:A13,A2:A13&\"\"))"]
["Sioux",null,{"$f":"SUMPRODUCT(1/COUNTIF(A2:A13,A2:A13&\"\"))","v":6}," =SUMPRODUCT(1/COUNTIF(A2:A13,A2:A13&\"\"))",null,"The (A2:A13<>\"\") part avoids counting one of the empty cells as a unique value"]
["Sioux",null,{"$f":"SUMPRODUCT(1/COUNTIF(A2:A13,A2:A13))","v":{"$error":"#DIV/0!"}}," =SUMPRODUCT(1/COUNTIF(A2:A13,A2:A13))",null,"The &\"\" avoids the Divide by zero error cause by the empty cell in the denominator"]
["Sue"]
[2]
["Jo"]
["Jo"]
["Joe"]
[]
["Joe"]
["Sue"]
[]
[]
["Names",null,"Count Unique"]
["Sioux",null,{"$f":"SUMPRODUCT((A16:A27<>\"\")/COUNTIF(A16:A27,A16:A27&\"\"))","v":5.833333333333333}," =SUMPRODUCT((A16:A27<>\"\")/COUNTIF(A16:A27,A16:A27&\"\"))"]
["Sioux",null,{"$f":"SUMPRODUCT(1/COUNTIF(A16:A27,A16:A27&\"\"))","v":6.833333333333333}," =SUMPRODUCT(1/COUNTIF(A16:A27,A16:A27&\"\"))",null,"The (A2:A13<>\"\") part avoids counting one of the empty cells as a unique value"]
["*Sioux",null,{"$f":"SUMPRODUCT(1/COUNTIF(A16:A27,A16:A27))","v":{"$error":"#DIV/0!"}}," =SUMPRODUCT(1/COUNTIF(A16:A27,A16:A27))",null,"The &\"\" avoids the Divide by zero error cause by the empty cell in the denominator"]
["Sue"]
[2,null,"This formula works if you have wild cards"]
["Jo",null,{"$f":"SUM(IF(FREQUENCY(IF(A16:A27<>\"\",MATCH(\"~\"&A16:A27,A16:A27&\"\",0)),ROW(A16:A27)-ROW(A16)+1),1))","v":7}," =SUM(IF(FREQUENCY(IF(A16:A27<>\"\",MATCH(\"~\"&A16:A27,A16:A27&\"\",0)),ROW(A16:A27)-ROW(A16)+1),1))"]
["*Jo"]
["Joe"]
[]
[null,null,"To learn the basics of array formulas, see this playlist of videos:"]
[null,null,"http://www.youtube.com/view_play_list?p=007E7E9CA63304D3"]

{"sheet":"(621)","index":12,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Criteria",{"$f":"\"Count Unique Numbers for \"&D2","v":"Count Unique Numbers for SR1"}]
[null,null,null,"SR1",{"$f":"SUM(--(FREQUENCY(IF(B5:B12=D2,A5:A12),A5:A12)>0))","v":3}]
[null,null,null,null,{"$f":"SUM(IF(FREQUENCY(IF(B5:B12=D2,IF(A5:A12<>\"\",MATCH(\"~\"&A5:A12,A5:A12&\"\",0))),ROW(B5:B12)-ROW(B5)+1),1,0))","v":3}]
["Sales","SalesRep"]
[12,"SR1"]
[2,"SR2"]
[3,"SR1"]
[4,"SR2"]
[12,"SR1"]
[12,"SR1"]
[2,"SR2"]
[2,"SR1",null,null,null,null,null,"For more about logical formulas see:",null,null,null,null,"Highline Excel Class 11: Logical formulas, IS & IF functions"]
[null,null,null,null,null,null,null,"For more about conditional formatting see:",null,null,null,null,"http://www.youtube.com/watch?v=9Dk1JoL_Pe4"]
[null,null,null,null,null,null,null,"For more about COUNTIFS function see:",null,null,null,null,"http://www.youtube.com/watch?v=_cWg850PMys"]

{"sheet":"(621an)","index":13,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Criteria",{"$f":"\"Count Unique Numbers for \"&D2","v":"Count Unique Numbers for SR2"}]
[null,null,null,"SR2",{"$f":"SUM(--(FREQUENCY(IF(B5:B12=D2,A5:A12),A5:A12)>0))","v":2}]
[null,null,null,null,{"$f":"SUM(IF(FREQUENCY(IF(B5:B12=D2,IF(A5:A12<>\"\",MATCH(\"~\"&A5:A12,A5:A12&\"\",0))),ROW(B5:B12)-ROW(B5)+1),1,0))","v":2}]
["Sales","SalesRep"]
[12,"SR1",null,{"$f":"AND($B5=$D$2,COUNTIFS($A$5:$A5,$A5,$B$5:$B5,$D$2)=1)","v":false},{"$f":"AND($B5=$D$2,COUNTIFS($A$5:$A5,$A5,$B$5:$B5,$D$2)=1)","v":false}]
[2,"SR2",null,{"$f":"AND($B6=$D$2,COUNTIFS($A$5:$A6,$A6,$B$5:$B6,$D$2)=1)","v":true},{"$f":"AND($B6=$D$2,COUNTIFS($A$5:$A6,$A6,$B$5:$B6,$D$2)=1)","v":true}]
[3,"SR1",null,{"$f":"AND($B7=$D$2,COUNTIFS($A$5:$A7,$A7,$B$5:$B7,$D$2)=1)","v":false},{"$f":"AND($B7=$D$2,COUNTIFS($A$5:$A7,$A7,$B$5:$B7,$D$2)=1)","v":false}]
[4,"SR2",null,{"$f":"AND($B8=$D$2,COUNTIFS($A$5:$A8,$A8,$B$5:$B8,$D$2)=1)","v":true},{"$f":"AND($B8=$D$2,COUNTIFS($A$5:$A8,$A8,$B$5:$B8,$D$2)=1)","v":true}]
[12,"SR1",null,{"$f":"AND($B9=$D$2,COUNTIFS($A$5:$A9,$A9,$B$5:$B9,$D$2)=1)","v":false},{"$f":"AND($B9=$D$2,COUNTIFS($A$5:$A9,$A9,$B$5:$B9,$D$2)=1)","v":false}]
[12,"SR1",null,{"$f":"AND($B10=$D$2,COUNTIFS($A$5:$A10,$A10,$B$5:$B10,$D$2)=1)","v":false},{"$f":"AND($B10=$D$2,COUNTIFS($A$5:$A10,$A10,$B$5:$B10,$D$2)=1)","v":false}]
[2,"SR2",null,{"$f":"AND($B11=$D$2,COUNTIFS($A$5:$A11,$A11,$B$5:$B11,$D$2)=1)","v":false},{"$f":"AND($B11=$D$2,COUNTIFS($A$5:$A11,$A11,$B$5:$B11,$D$2)=1)","v":false}]
[2,"SR1",null,{"$f":"AND($B12=$D$2,COUNTIFS($A$5:$A12,$A12,$B$5:$B12,$D$2)=1)","v":false},{"$f":"AND($B12=$D$2,COUNTIFS($A$5:$A12,$A12,$B$5:$B12,$D$2)=1)","v":false},null,null,"For more about logical formulas see:",null,null,null,null,"Highline Excel Class 11: Logical formulas, IS & IF functions"]
[null,null,null,null,null,null,null,"For more about conditional formatting see:",null,null,null,null,"http://www.youtube.com/watch?v=9Dk1JoL_Pe4"]
[null,null,null,null,null,null,null,"For more about COUNTIFS function see:",null,null,null,null,"http://www.youtube.com/watch?v=_cWg850PMys"]

{"sheet":"(622)","index":14,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Data1","Data2","Data3"]
[{"$f":"ROW()+COLUMN()","v":3},4,5]
[4,5,6,null,"Return Only Even Row Data",null,null,null,"Return 2nd, 4th, etc. data entries"]
[5,6,7,null,"Count Even Rows",null,null,null,"Count Even Rows"]
[6,7,8,null,"Data1","Data2","Data3",null,"Data1","Data2","Data3"]
[7,8,9]
[8,9,10]
[9,10,11]
[10,11,12]
[11,12,13]
[12,13,14]
[13,14,15]
[14,15,16]
[15,16,17]
[]
[]
[null,null,null,null,"To learn the basics of array formulas, see this playlist of videos:"]
[null,null,null,null,"http://www.youtube.com/view_play_list?p=007E7E9CA63304D3"]

{"sheet":"(622an)","index":15,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Data1","Data2","Data3"]
[{"$f":"ROW()+COLUMN()","v":3},4,5]
[4,5,6,null,"Return Only Even Row Data",null,null,null,"Return 2nd, 4th, etc. data entries"]
[5,6,7,null,"Count Even Rows",null,{"$f":"SUMPRODUCT(--(MOD(ROW(A2:A14),2)=0))","v":7},null,"Count Even Rows",null,{"$f":"SUMPRODUCT(--(MOD(ROW(A2:A14),2)))","v":6}]
[6,7,8,null,"Data1","Data2","Data3",null,"Data1","Data2","Data3"]
[7,8,9,null,{"$f":"IF(ROWS(E$6:E6)>$G$4,\"\",INDEX(A$2:A$14,SMALL(IF(MOD(ROW($A$2:$A$14),2)=0,ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(E$6:E6))))","v":3},{"$f":"IF(ROWS(F$6:F6)>$G$4,\"\",INDEX(B$2:B$14,SMALL(IF(MOD(ROW($A$2:$A$14),2)=0,ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(F$6:F6))))","v":4},{"$f":"IF(ROWS(G$6:G6)>$G$4,\"\",INDEX(C$2:C$14,SMALL(IF(MOD(ROW($A$2:$A$14),2)=0,ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(G$6:G6))))","v":5},null,{"$f":"IF(ROWS(I$6:I6)>$K$4,\"\",INDEX(A$2:A$14,SMALL(IF(MOD(ROW($A$2:$A$14),2),ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(I$6:I6))))","v":4},{"$f":"IF(ROWS(J$6:J6)>$K$4,\"\",INDEX(B$2:B$14,SMALL(IF(MOD(ROW($A$2:$A$14),2),ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(J$6:J6))))","v":5},{"$f":"IF(ROWS(K$6:K6)>$K$4,\"\",INDEX(C$2:C$14,SMALL(IF(MOD(ROW($A$2:$A$14),2),ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(K$6:K6))))","v":6}]
[8,9,10,null,{"$f":"IF(ROWS(E$6:E7)>$G$4,\"\",INDEX(A$2:A$14,SMALL(IF(MOD(ROW($A$2:$A$14),2)=0,ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(E$6:E7))))","v":5},{"$f":"IF(ROWS(F$6:F7)>$G$4,\"\",INDEX(B$2:B$14,SMALL(IF(MOD(ROW($A$2:$A$14),2)=0,ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(F$6:F7))))","v":6},{"$f":"IF(ROWS(G$6:G7)>$G$4,\"\",INDEX(C$2:C$14,SMALL(IF(MOD(ROW($A$2:$A$14),2)=0,ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(G$6:G7))))","v":7},null,{"$f":"IF(ROWS(I$6:I7)>$K$4,\"\",INDEX(A$2:A$14,SMALL(IF(MOD(ROW($A$2:$A$14),2),ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(I$6:I7))))","v":6},{"$f":"IF(ROWS(J$6:J7)>$K$4,\"\",INDEX(B$2:B$14,SMALL(IF(MOD(ROW($A$2:$A$14),2),ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(J$6:J7))))","v":7},{"$f":"IF(ROWS(K$6:K7)>$K$4,\"\",INDEX(C$2:C$14,SMALL(IF(MOD(ROW($A$2:$A$14),2),ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(K$6:K7))))","v":8}]
[9,10,11,null,{"$f":"IF(ROWS(E$6:E8)>$G$4,\"\",INDEX(A$2:A$14,SMALL(IF(MOD(ROW($A$2:$A$14),2)=0,ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(E$6:E8))))","v":7},{"$f":"IF(ROWS(F$6:F8)>$G$4,\"\",INDEX(B$2:B$14,SMALL(IF(MOD(ROW($A$2:$A$14),2)=0,ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(F$6:F8))))","v":8},{"$f":"IF(ROWS(G$6:G8)>$G$4,\"\",INDEX(C$2:C$14,SMALL(IF(MOD(ROW($A$2:$A$14),2)=0,ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(G$6:G8))))","v":9},null,{"$f":"IF(ROWS(I$6:I8)>$K$4,\"\",INDEX(A$2:A$14,SMALL(IF(MOD(ROW($A$2:$A$14),2),ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(I$6:I8))))","v":8},{"$f":"IF(ROWS(J$6:J8)>$K$4,\"\",INDEX(B$2:B$14,SMALL(IF(MOD(ROW($A$2:$A$14),2),ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(J$6:J8))))","v":9},{"$f":"IF(ROWS(K$6:K8)>$K$4,\"\",INDEX(C$2:C$14,SMALL(IF(MOD(ROW($A$2:$A$14),2),ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(K$6:K8))))","v":10}]
[10,11,12,null,{"$f":"IF(ROWS(E$6:E9)>$G$4,\"\",INDEX(A$2:A$14,SMALL(IF(MOD(ROW($A$2:$A$14),2)=0,ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(E$6:E9))))","v":9},{"$f":"IF(ROWS(F$6:F9)>$G$4,\"\",INDEX(B$2:B$14,SMALL(IF(MOD(ROW($A$2:$A$14),2)=0,ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(F$6:F9))))","v":10},{"$f":"IF(ROWS(G$6:G9)>$G$4,\"\",INDEX(C$2:C$14,SMALL(IF(MOD(ROW($A$2:$A$14),2)=0,ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(G$6:G9))))","v":11},null,{"$f":"IF(ROWS(I$6:I9)>$K$4,\"\",INDEX(A$2:A$14,SMALL(IF(MOD(ROW($A$2:$A$14),2),ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(I$6:I9))))","v":10},{"$f":"IF(ROWS(J$6:J9)>$K$4,\"\",INDEX(B$2:B$14,SMALL(IF(MOD(ROW($A$2:$A$14),2),ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(J$6:J9))))","v":11},{"$f":"IF(ROWS(K$6:K9)>$K$4,\"\",INDEX(C$2:C$14,SMALL(IF(MOD(ROW($A$2:$A$14),2),ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(K$6:K9))))","v":12}]
[11,12,13,null,{"$f":"IF(ROWS(E$6:E10)>$G$4,\"\",INDEX(A$2:A$14,SMALL(IF(MOD(ROW($A$2:$A$14),2)=0,ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(E$6:E10))))","v":11},{"$f":"IF(ROWS(F$6:F10)>$G$4,\"\",INDEX(B$2:B$14,SMALL(IF(MOD(ROW($A$2:$A$14),2)=0,ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(F$6:F10))))","v":12},{"$f":"IF(ROWS(G$6:G10)>$G$4,\"\",INDEX(C$2:C$14,SMALL(IF(MOD(ROW($A$2:$A$14),2)=0,ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(G$6:G10))))","v":13},null,{"$f":"IF(ROWS(I$6:I10)>$K$4,\"\",INDEX(A$2:A$14,SMALL(IF(MOD(ROW($A$2:$A$14),2),ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(I$6:I10))))","v":12},{"$f":"IF(ROWS(J$6:J10)>$K$4,\"\",INDEX(B$2:B$14,SMALL(IF(MOD(ROW($A$2:$A$14),2),ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(J$6:J10))))","v":13},{"$f":"IF(ROWS(K$6:K10)>$K$4,\"\",INDEX(C$2:C$14,SMALL(IF(MOD(ROW($A$2:$A$14),2),ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(K$6:K10))))","v":14}]
[12,13,14,null,{"$f":"IF(ROWS(E$6:E11)>$G$4,\"\",INDEX(A$2:A$14,SMALL(IF(MOD(ROW($A$2:$A$14),2)=0,ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(E$6:E11))))","v":13},{"$f":"IF(ROWS(F$6:F11)>$G$4,\"\",INDEX(B$2:B$14,SMALL(IF(MOD(ROW($A$2:$A$14),2)=0,ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(F$6:F11))))","v":14},{"$f":"IF(ROWS(G$6:G11)>$G$4,\"\",INDEX(C$2:C$14,SMALL(IF(MOD(ROW($A$2:$A$14),2)=0,ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(G$6:G11))))","v":15},null,{"$f":"IF(ROWS(I$6:I11)>$K$4,\"\",INDEX(A$2:A$14,SMALL(IF(MOD(ROW($A$2:$A$14),2),ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(I$6:I11))))","v":14},{"$f":"IF(ROWS(J$6:J11)>$K$4,\"\",INDEX(B$2:B$14,SMALL(IF(MOD(ROW($A$2:$A$14),2),ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(J$6:J11))))","v":15},{"$f":"IF(ROWS(K$6:K11)>$K$4,\"\",INDEX(C$2:C$14,SMALL(IF(MOD(ROW($A$2:$A$14),2),ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(K$6:K11))))","v":16}]
[13,14,15,null,{"$f":"IF(ROWS(E$6:E12)>$G$4,\"\",INDEX(A$2:A$14,SMALL(IF(MOD(ROW($A$2:$A$14),2)=0,ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(E$6:E12))))","v":15},{"$f":"IF(ROWS(F$6:F12)>$G$4,\"\",INDEX(B$2:B$14,SMALL(IF(MOD(ROW($A$2:$A$14),2)=0,ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(F$6:F12))))","v":16},{"$f":"IF(ROWS(G$6:G12)>$G$4,\"\",INDEX(C$2:C$14,SMALL(IF(MOD(ROW($A$2:$A$14),2)=0,ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(G$6:G12))))","v":17},null,{"$f":"IF(ROWS(I$6:I12)>$K$4,\"\",INDEX(A$2:A$14,SMALL(IF(MOD(ROW($A$2:$A$14),2),ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(I$6:I12))))","v":""},{"$f":"IF(ROWS(J$6:J12)>$K$4,\"\",INDEX(B$2:B$14,SMALL(IF(MOD(ROW($A$2:$A$14),2),ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(J$6:J12))))","v":""},{"$f":"IF(ROWS(K$6:K12)>$K$4,\"\",INDEX(C$2:C$14,SMALL(IF(MOD(ROW($A$2:$A$14),2),ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(K$6:K12))))","v":""}]
[14,15,16,null,{"$f":"IF(ROWS(E$6:E13)>$G$4,\"\",INDEX(A$2:A$14,SMALL(IF(MOD(ROW($A$2:$A$14),2)=0,ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(E$6:E13))))","v":""},{"$f":"IF(ROWS(F$6:F13)>$G$4,\"\",INDEX(B$2:B$14,SMALL(IF(MOD(ROW($A$2:$A$14),2)=0,ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(F$6:F13))))","v":""},{"$f":"IF(ROWS(G$6:G13)>$G$4,\"\",INDEX(C$2:C$14,SMALL(IF(MOD(ROW($A$2:$A$14),2)=0,ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(G$6:G13))))","v":""},null,{"$f":"IF(ROWS(I$6:I13)>$K$4,\"\",INDEX(A$2:A$14,SMALL(IF(MOD(ROW($A$2:$A$14),2),ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(I$6:I13))))","v":""},{"$f":"IF(ROWS(J$6:J13)>$K$4,\"\",INDEX(B$2:B$14,SMALL(IF(MOD(ROW($A$2:$A$14),2),ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(J$6:J13))))","v":""},{"$f":"IF(ROWS(K$6:K13)>$K$4,\"\",INDEX(C$2:C$14,SMALL(IF(MOD(ROW($A$2:$A$14),2),ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(K$6:K13))))","v":""}]
[15,16,17,null,{"$f":"IF(ROWS(E$6:E14)>$G$4,\"\",INDEX(A$2:A$14,SMALL(IF(MOD(ROW($A$2:$A$14),2)=0,ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(E$6:E14))))","v":""},{"$f":"IF(ROWS(F$6:F14)>$G$4,\"\",INDEX(B$2:B$14,SMALL(IF(MOD(ROW($A$2:$A$14),2)=0,ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(F$6:F14))))","v":""},{"$f":"IF(ROWS(G$6:G14)>$G$4,\"\",INDEX(C$2:C$14,SMALL(IF(MOD(ROW($A$2:$A$14),2)=0,ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(G$6:G14))))","v":""},null,{"$f":"IF(ROWS(I$6:I14)>$K$4,\"\",INDEX(A$2:A$14,SMALL(IF(MOD(ROW($A$2:$A$14),2),ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(I$6:I14))))","v":""},{"$f":"IF(ROWS(J$6:J14)>$K$4,\"\",INDEX(B$2:B$14,SMALL(IF(MOD(ROW($A$2:$A$14),2),ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(J$6:J14))))","v":""},{"$f":"IF(ROWS(K$6:K14)>$K$4,\"\",INDEX(C$2:C$14,SMALL(IF(MOD(ROW($A$2:$A$14),2),ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(K$6:K14))))","v":""}]
[null,null,null,null,{"$f":"IF(ROWS(E$6:E15)>$G$4,\"\",INDEX(A$2:A$14,SMALL(IF(MOD(ROW($A$2:$A$14),2)=0,ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(E$6:E15))))","v":""},{"$f":"IF(ROWS(F$6:F15)>$G$4,\"\",INDEX(B$2:B$14,SMALL(IF(MOD(ROW($A$2:$A$14),2)=0,ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(F$6:F15))))","v":""},{"$f":"IF(ROWS(G$6:G15)>$G$4,\"\",INDEX(C$2:C$14,SMALL(IF(MOD(ROW($A$2:$A$14),2)=0,ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(G$6:G15))))","v":""},null,{"$f":"IF(ROWS(I$6:I15)>$K$4,\"\",INDEX(A$2:A$14,SMALL(IF(MOD(ROW($A$2:$A$14),2),ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(I$6:I15))))","v":""},{"$f":"IF(ROWS(J$6:J15)>$K$4,\"\",INDEX(B$2:B$14,SMALL(IF(MOD(ROW($A$2:$A$14),2),ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(J$6:J15))))","v":""},{"$f":"IF(ROWS(K$6:K15)>$K$4,\"\",INDEX(C$2:C$14,SMALL(IF(MOD(ROW($A$2:$A$14),2),ROW($A$2:$A$14)-ROW($A$2)+1),ROWS(K$6:K15))))","v":""}]
[]
[null,null,null,null,"To learn the basics of array formulas, see this playlist of videos:"]
[null,null,null,null,"http://www.youtube.com/view_play_list?p=007E7E9CA63304D3"]

{"sheet":"Sheet2","index":16,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":17,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}