{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Overview","Keyboard Shortcuts","Delete","COUNTBLANK","Filter","IF","INDEX","COUNT","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Overview","index":0,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Skip Blank Rows"]
[]
[null,"Name","ID","EEE","ME","CE"]
[null,"Smith","S2001",74,84,83]
[]
[null,"Bob","S2003",78,85,78]
[null,"Mark","S2004",88,90,78]
[null,"Emma","S2005",90,71,85]
[]
[null,"Cathy","S2007",73,76,70]
[null,"Milan","S2008",87,88,72]
[]
[null,"Edward","S2010",88,85,71]

{"sheet":"Keyboard Shortcuts","index":1,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Skip Blank Rows"]
[]
[null,"Name","ID","EEE","ME","CE"]
[null,"Smith","S2001",74,84,83]
[null,"Bob","S2003",78,85,78]
[null,"Mark","S2004",88,90,78]
[null,"Emma","S2005",90,71,85]
[null,"Cathy","S2007",73,76,70]
[null,"Milan","S2008",87,88,72]
[null,"Edward","S2010",88,85,71]

{"sheet":"Delete","index":2,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Skip Blank Rows"]
[]
[null,"Name","ID","EEE","ME","CE"]
[null,"Smith","S2001",74,84,83]
[null,"Bob","S2003",78,85,78]
[null,"Mark","S2004",88,90,78]
[null,"Emma","S2005",90,71,85]
[null,"Cathy","S2007",73,76,70]
[null,"Milan","S2008",87,88,72]
[null,"Edward","S2010",88,85,71]

{"sheet":"COUNTBLANK","index":3,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Skip Blank Rows"]
[]
[null,"Name","ID","EEE","ME","CE","Blank"]
[null,"Smith","S2001",74,84,83,{"$f":"COUNTBLANK(B5:F5)","v":0}]
[null,null,null,null,null,null,{"$f":"COUNTBLANK(B6:F6)","v":5}]
[null,"Bob","S2003",78,85,78,0]
[null,"Mark","S2004",88,90,78,0]
[null,"Emma","S2005",90,71,85,0]
[null,null,null,null,null,null,5]
[null,"Cathy","S2007",73,76,70,0]
[null,"Milan","S2008",87,88,72,0]
[null,null,null,null,null,null,5]
[null,"Edward","S2010",88,85,71,0]

{"sheet":"Filter","index":4,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,9]]}
[]
[null,"Apply the FILTER Function to Skip Blank Rows"]
[]
[null,"Name","EEE","ME","CE",null,"Name","EEE","ME","CE"]
[null,"Smith",74,84,83,null,{"$f":"_xlfn._xlws.FILTER(B5:E14,(B5:B14<>\"\")*(C5:C14<>\"\")*(D5:D14<>\"\")*(E5:E14<>\"\"))","v":"Smith"},74,84,83]
[null,null,null,null,null,null,"Bob",78,85,78]
[null,"Bob",78,85,78,null,"Mark",88,90,78]
[null,"Mark",88,90,78,null,"Emma",90,71,85]
[null,"Emma",90,71,85,null,"Cathy",73,76,70]
[null,null,null,null,null,null,"Milan",87,88,72]
[null,"Cathy",73,76,70,null,"Edward",88,85,71]
[null,"Milan",87,88,72]
[]
[null,"Edward",88,85,71]

{"sheet":"IF","index":5,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"IF, AND, & ISERROR Functions to Skip Blank Rows"]
[]
[null,"Name","EEE","ME","CE","Remark"]
[null,"Smith",74,84,83,{"$f":"IF(AND(ISBLANK(B5), ISBLANK(C5),ISBLANK(D5),ISBLANK(E5)),\"Blank\", \"Not-Blank\")","v":"Not-Blank"}]
[null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B6), ISBLANK(C6),ISBLANK(D6),ISBLANK(E6)),\"Blank\", \"Not-Blank\")","v":"Blank"}]
[null,"Bob",78,85,78,"Not-Blank"]
[null,"Mark",88,90,78,"Not-Blank"]
[null,"Emma",90,71,85,"Not-Blank"]
[null,null,null,null,null,"Blank"]
[null,"Cathy",73,76,70,"Not-Blank"]
[null,"Milan",87,88,72,"Not-Blank"]
[null,null,null,null,null,"Blank"]
[null,"Edward",88,85,71,"Not-Blank"]

{"sheet":"INDEX","index":6,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,9]]}
[]
[null,"Apply the IFERROR, INDEX, SMALL, IF, ROW, & ROWS Functions "]
[]
[null,"Name","EEE","ME","CE",null,"Name","EEE","ME","CE"]
[null,"Smith",74,84,83,null,{"$f":"IFERROR(INDEX(B:B,SMALL(IF(B$5:B$14<>\"\",ROW(B$5:B$14)), ROWS(B$5:B5))), \"\")","v":"Smith"},{"$f":"IFERROR(INDEX(C:C,SMALL(IF(C$5:C$14<>\"\",ROW(C$5:C$14)), ROWS(C$5:C5))), \"\")","v":74},{"$f":"IFERROR(INDEX(D:D,SMALL(IF(D$5:D$14<>\"\",ROW(D$5:D$14)), ROWS(D$5:D5))), \"\")","v":84},{"$f":"IFERROR(INDEX(E:E,SMALL(IF(E$5:E$14<>\"\",ROW(E$5:E$14)), ROWS(E$5:E5))), \"\")","v":83}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(B:B,SMALL(IF(B$5:B$14<>\"\",ROW(B$5:B$14)), ROWS(B$5:B6))), \"\")","v":"Bob"},{"$f":"IFERROR(INDEX(C:C,SMALL(IF(C$5:C$14<>\"\",ROW(C$5:C$14)), ROWS(C$5:C6))), \"\")","v":78},{"$f":"IFERROR(INDEX(D:D,SMALL(IF(D$5:D$14<>\"\",ROW(D$5:D$14)), ROWS(D$5:D6))), \"\")","v":85},{"$f":"IFERROR(INDEX(E:E,SMALL(IF(E$5:E$14<>\"\",ROW(E$5:E$14)), ROWS(E$5:E6))), \"\")","v":78}]
[null,"Bob",78,85,78,null,{"$f":"IFERROR(INDEX(B:B,SMALL(IF(B$5:B$14<>\"\",ROW(B$5:B$14)), ROWS(B$5:B7))), \"\")","v":"Mark"},{"$f":"IFERROR(INDEX(C:C,SMALL(IF(C$5:C$14<>\"\",ROW(C$5:C$14)), ROWS(C$5:C7))), \"\")","v":88},{"$f":"IFERROR(INDEX(D:D,SMALL(IF(D$5:D$14<>\"\",ROW(D$5:D$14)), ROWS(D$5:D7))), \"\")","v":90},{"$f":"IFERROR(INDEX(E:E,SMALL(IF(E$5:E$14<>\"\",ROW(E$5:E$14)), ROWS(E$5:E7))), \"\")","v":78}]
[null,"Mark",88,90,78,null,{"$f":"IFERROR(INDEX(B:B,SMALL(IF(B$5:B$14<>\"\",ROW(B$5:B$14)), ROWS(B$5:B8))), \"\")","v":"Emma"},{"$f":"IFERROR(INDEX(C:C,SMALL(IF(C$5:C$14<>\"\",ROW(C$5:C$14)), ROWS(C$5:C8))), \"\")","v":90},{"$f":"IFERROR(INDEX(D:D,SMALL(IF(D$5:D$14<>\"\",ROW(D$5:D$14)), ROWS(D$5:D8))), \"\")","v":71},{"$f":"IFERROR(INDEX(E:E,SMALL(IF(E$5:E$14<>\"\",ROW(E$5:E$14)), ROWS(E$5:E8))), \"\")","v":85}]
[null,"Emma",90,71,85,null,{"$f":"IFERROR(INDEX(B:B,SMALL(IF(B$5:B$14<>\"\",ROW(B$5:B$14)), ROWS(B$5:B9))), \"\")","v":"Cathy"},{"$f":"IFERROR(INDEX(C:C,SMALL(IF(C$5:C$14<>\"\",ROW(C$5:C$14)), ROWS(C$5:C9))), \"\")","v":73},{"$f":"IFERROR(INDEX(D:D,SMALL(IF(D$5:D$14<>\"\",ROW(D$5:D$14)), ROWS(D$5:D9))), \"\")","v":76},{"$f":"IFERROR(INDEX(E:E,SMALL(IF(E$5:E$14<>\"\",ROW(E$5:E$14)), ROWS(E$5:E9))), \"\")","v":70}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(B:B,SMALL(IF(B$5:B$14<>\"\",ROW(B$5:B$14)), ROWS(B$5:B10))), \"\")","v":"Milan"},{"$f":"IFERROR(INDEX(C:C,SMALL(IF(C$5:C$14<>\"\",ROW(C$5:C$14)), ROWS(C$5:C10))), \"\")","v":87},{"$f":"IFERROR(INDEX(D:D,SMALL(IF(D$5:D$14<>\"\",ROW(D$5:D$14)), ROWS(D$5:D10))), \"\")","v":88},{"$f":"IFERROR(INDEX(E:E,SMALL(IF(E$5:E$14<>\"\",ROW(E$5:E$14)), ROWS(E$5:E10))), \"\")","v":72}]
[null,"Cathy",73,76,70,null,{"$f":"IFERROR(INDEX(B:B,SMALL(IF(B$5:B$14<>\"\",ROW(B$5:B$14)), ROWS(B$5:B11))), \"\")","v":"Edward"},{"$f":"IFERROR(INDEX(C:C,SMALL(IF(C$5:C$14<>\"\",ROW(C$5:C$14)), ROWS(C$5:C11))), \"\")","v":88},{"$f":"IFERROR(INDEX(D:D,SMALL(IF(D$5:D$14<>\"\",ROW(D$5:D$14)), ROWS(D$5:D11))), \"\")","v":85},{"$f":"IFERROR(INDEX(E:E,SMALL(IF(E$5:E$14<>\"\",ROW(E$5:E$14)), ROWS(E$5:E11))), \"\")","v":71}]
[null,"Milan",87,88,72,null,{"$f":"IFERROR(INDEX(B:B,SMALL(IF(B$5:B$14<>\"\",ROW(B$5:B$14)), ROWS(B$5:B12))), \"\")","v":""},{"$f":"IFERROR(INDEX(C:C,SMALL(IF(C$5:C$14<>\"\",ROW(C$5:C$14)), ROWS(C$5:C12))), \"\")","v":""},{"$f":"IFERROR(INDEX(D:D,SMALL(IF(D$5:D$14<>\"\",ROW(D$5:D$14)), ROWS(D$5:D12))), \"\")","v":""},{"$f":"IFERROR(INDEX(E:E,SMALL(IF(E$5:E$14<>\"\",ROW(E$5:E$14)), ROWS(E$5:E12))), \"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(B:B,SMALL(IF(B$5:B$14<>\"\",ROW(B$5:B$14)), ROWS(B$5:B13))), \"\")","v":""},{"$f":"IFERROR(INDEX(C:C,SMALL(IF(C$5:C$14<>\"\",ROW(C$5:C$14)), ROWS(C$5:C13))), \"\")","v":""},{"$f":"IFERROR(INDEX(D:D,SMALL(IF(D$5:D$14<>\"\",ROW(D$5:D$14)), ROWS(D$5:D13))), \"\")","v":""},{"$f":"IFERROR(INDEX(E:E,SMALL(IF(E$5:E$14<>\"\",ROW(E$5:E$14)), ROWS(E$5:E13))), \"\")","v":""}]
[null,"Edward",88,85,71,null,{"$f":"IFERROR(INDEX(B:B,SMALL(IF(B$5:B$14<>\"\",ROW(B$5:B$14)), ROWS(B$5:B14))), \"\")","v":""},{"$f":"IFERROR(INDEX(C:C,SMALL(IF(C$5:C$14<>\"\",ROW(C$5:C$14)), ROWS(C$5:C14))), \"\")","v":""},{"$f":"IFERROR(INDEX(D:D,SMALL(IF(D$5:D$14<>\"\",ROW(D$5:D$14)), ROWS(D$5:D14))), \"\")","v":""},{"$f":"IFERROR(INDEX(E:E,SMALL(IF(E$5:E$14<>\"\",ROW(E$5:E$14)), ROWS(E$5:E14))), \"\")","v":""}]

{"sheet":"COUNT","index":7,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,9]]}
[]
[null,"Use the IF, ROWS, COUNT, INDEX, SMALL, ROW, & ROWS Functions"]
[]
[null,"Name","EEE","ME","CE",null,"Name","EEE","ME","CE"]
[null,"Smith",74,84,83,null,{"$f":"IF(ROWS(B$5:B5)>COUNTA(B:B),\"\",INDEX(B:B,SMALL(IF(B$5:B$14<>\"\", ROW(B$5:B$14)),ROWS(B$5:B5))))","v":"Smith"},{"$f":"IF(ROWS(C$5:C5)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$5:C$14<>\"\", ROW(C$5:C$14)),ROWS(C$5:C5))))","v":74},{"$f":"IF(ROWS(D$5:D5)>COUNTA(D:D),\"\",INDEX(D:D,SMALL(IF(D$5:D$14<>\"\", ROW(D$5:D$14)),ROWS(D$5:D5))))","v":84},{"$f":"IF(ROWS(E$5:E5)>COUNTA(E:E),\"\",INDEX(E:E,SMALL(IF(E$5:E$14<>\"\", ROW(E$5:E$14)),ROWS(E$5:E5))))","v":83}]
[null,null,null,null,null,null,{"$f":"IF(ROWS(B$5:B6)>COUNTA(B:B),\"\",INDEX(B:B,SMALL(IF(B$5:B$14<>\"\", ROW(B$5:B$14)),ROWS(B$5:B6))))","v":"Bob"},{"$f":"IF(ROWS(C$5:C6)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$5:C$14<>\"\", ROW(C$5:C$14)),ROWS(C$5:C6))))","v":78},{"$f":"IF(ROWS(D$5:D6)>COUNTA(D:D),\"\",INDEX(D:D,SMALL(IF(D$5:D$14<>\"\", ROW(D$5:D$14)),ROWS(D$5:D6))))","v":85},{"$f":"IF(ROWS(E$5:E6)>COUNTA(E:E),\"\",INDEX(E:E,SMALL(IF(E$5:E$14<>\"\", ROW(E$5:E$14)),ROWS(E$5:E6))))","v":78}]
[null,"Bob",78,85,78,null,{"$f":"IF(ROWS(B$5:B7)>COUNTA(B:B),\"\",INDEX(B:B,SMALL(IF(B$5:B$14<>\"\", ROW(B$5:B$14)),ROWS(B$5:B7))))","v":"Mark"},{"$f":"IF(ROWS(C$5:C7)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$5:C$14<>\"\", ROW(C$5:C$14)),ROWS(C$5:C7))))","v":88},{"$f":"IF(ROWS(D$5:D7)>COUNTA(D:D),\"\",INDEX(D:D,SMALL(IF(D$5:D$14<>\"\", ROW(D$5:D$14)),ROWS(D$5:D7))))","v":90},{"$f":"IF(ROWS(E$5:E7)>COUNTA(E:E),\"\",INDEX(E:E,SMALL(IF(E$5:E$14<>\"\", ROW(E$5:E$14)),ROWS(E$5:E7))))","v":78}]
[null,"Mark",88,90,78,null,{"$f":"IF(ROWS(B$5:B8)>COUNTA(B:B),\"\",INDEX(B:B,SMALL(IF(B$5:B$14<>\"\", ROW(B$5:B$14)),ROWS(B$5:B8))))","v":"Emma"},{"$f":"IF(ROWS(C$5:C8)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$5:C$14<>\"\", ROW(C$5:C$14)),ROWS(C$5:C8))))","v":90},{"$f":"IF(ROWS(D$5:D8)>COUNTA(D:D),\"\",INDEX(D:D,SMALL(IF(D$5:D$14<>\"\", ROW(D$5:D$14)),ROWS(D$5:D8))))","v":71},{"$f":"IF(ROWS(E$5:E8)>COUNTA(E:E),\"\",INDEX(E:E,SMALL(IF(E$5:E$14<>\"\", ROW(E$5:E$14)),ROWS(E$5:E8))))","v":85}]
[null,"Emma",90,71,85,null,{"$f":"IF(ROWS(B$5:B9)>COUNTA(B:B),\"\",INDEX(B:B,SMALL(IF(B$5:B$14<>\"\", ROW(B$5:B$14)),ROWS(B$5:B9))))","v":"Cathy"},{"$f":"IF(ROWS(C$5:C9)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$5:C$14<>\"\", ROW(C$5:C$14)),ROWS(C$5:C9))))","v":73},{"$f":"IF(ROWS(D$5:D9)>COUNTA(D:D),\"\",INDEX(D:D,SMALL(IF(D$5:D$14<>\"\", ROW(D$5:D$14)),ROWS(D$5:D9))))","v":76},{"$f":"IF(ROWS(E$5:E9)>COUNTA(E:E),\"\",INDEX(E:E,SMALL(IF(E$5:E$14<>\"\", ROW(E$5:E$14)),ROWS(E$5:E9))))","v":70}]
[null,null,null,null,null,null,{"$f":"IF(ROWS(B$5:B10)>COUNTA(B:B),\"\",INDEX(B:B,SMALL(IF(B$5:B$14<>\"\", ROW(B$5:B$14)),ROWS(B$5:B10))))","v":"Milan"},{"$f":"IF(ROWS(C$5:C10)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$5:C$14<>\"\", ROW(C$5:C$14)),ROWS(C$5:C10))))","v":87},{"$f":"IF(ROWS(D$5:D10)>COUNTA(D:D),\"\",INDEX(D:D,SMALL(IF(D$5:D$14<>\"\", ROW(D$5:D$14)),ROWS(D$5:D10))))","v":88},{"$f":"IF(ROWS(E$5:E10)>COUNTA(E:E),\"\",INDEX(E:E,SMALL(IF(E$5:E$14<>\"\", ROW(E$5:E$14)),ROWS(E$5:E10))))","v":72}]
[null,"Cathy",73,76,70,null,{"$f":"IF(ROWS(B$5:B11)>COUNTA(B:B),\"\",INDEX(B:B,SMALL(IF(B$5:B$14<>\"\", ROW(B$5:B$14)),ROWS(B$5:B11))))","v":"Edward"},{"$f":"IF(ROWS(C$5:C11)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$5:C$14<>\"\", ROW(C$5:C$14)),ROWS(C$5:C11))))","v":88},{"$f":"IF(ROWS(D$5:D11)>COUNTA(D:D),\"\",INDEX(D:D,SMALL(IF(D$5:D$14<>\"\", ROW(D$5:D$14)),ROWS(D$5:D11))))","v":85},{"$f":"IF(ROWS(E$5:E11)>COUNTA(E:E),\"\",INDEX(E:E,SMALL(IF(E$5:E$14<>\"\", ROW(E$5:E$14)),ROWS(E$5:E11))))","v":71}]
[null,"Milan",87,88,72]
[]
[null,"Edward",88,85,71]

{"sheet":"VBA","index":8,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"RUN a VBA Code to Skip Blank Rows"]
[]
[null,"Name","ID","EEE","ME","CE"]
[null,"Smith","S2001",74,84,83]
[null,"Bob","S2003",78,85,78]
[null,"Mark","S2004",88,90,78]
[null,"Emma","S2005",90,71,85]
[null,"Cathy","S2007",73,76,70]
[null,"Milan","S2008",87,88,72]
[null,"Edward","S2010",88,85,71]