{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dataset","Using LOOKUP","Using INDEX & COUNT","Using MIN & COLUMN then INDEX","Using VBA","Practice Sheet"],"not_rendered":{"charts":0,"images":0,"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":"Dataset","index":0,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"Excel Find Last Column With Data"]
[]
[null,"Order Date","Order ID","Amount"]
[null,"2021-12-15",1001,450]
[null,"2021-12-16",1002,325]
[null,"2021-12-17",1003,678]
[null,"2021-12-18",1004,876]
[null,"2021-12-19",1005,342]
[null,"2021-12-20",1006,543]

{"sheet":"Using LOOKUP","index":1,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,1,0,6],[2,5,2,6],[3,5,3,6]]}
[null,"Using LOOKUP to Find Last Column With Data"]
[]
[null,"Order Date","Order ID","Amount",null,"Last Column Data"]
[null,"2021-12-15",1001,450,null,{"$f":"LOOKUP(2,1/(D:D<>\"\"),D:D)","v":543}]
[null,"2021-12-16",1002,325]
[null,"2021-12-17",1003,678]
[null,"2021-12-18",1004,876]
[null,"2021-12-19",1005,342]
[null,"2021-12-20",1006,543]

{"sheet":"Using INDEX & COUNT","index":2,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,1,0,6],[2,5,2,6],[3,5,3,6]]}
[null,"Using INDEX & COUNT to Find Last Column With Data"]
[]
[null,"Order Date","Order ID","Amount",null,"Last Column Data"]
[null,"2021-12-15",1001,450,null,{"$f":"INDEX(D4:D9,COUNT(D4:D9))","v":543}]
[null,"2021-12-16",1002,325]
[null,"2021-12-17",1003,678]
[null,"2021-12-18",1004,876]
[null,"2021-12-19",1005,342]
[null,"2021-12-20",1006,543]

{"sheet":"Using MIN & COLUMN then INDEX","index":3,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["Using MIN & COLUMN then INDEX Find Last Column With Data"]
[]
["Order Date","Order ID","Amount",null,"Last Column",{"$f":"MIN(COLUMN(A4:C9))+COLUMNS(A4:C9)-1","v":3}]
["2021-12-15",1001,450,null,"Data",{"$f":"INDEX(A4:C9,6,F3)","v":543}]
["2021-12-16",1002,325]
["2021-12-17",1003,678]
["2021-12-18",1004,876]
["2021-12-19",1005,342]
["2021-12-20",1006,543]

{"sheet":"Using VBA","index":4,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Using VBA to Find Last Column With Data"]
[]
[null,"Order Date","Order ID","Amount"]
[null,"2021-12-15",1001,450]
[null,"2021-12-16",1002,325]
[null,"2021-12-17",1003,678]
[null,"2021-12-18",1004,876]
[null,"2021-12-19",1005,342]
[null,"2021-12-20",1006,543]

{"sheet":"Practice Sheet","index":5,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,1,0,6],[2,5,2,6],[3,5,3,6]]}
[null,"Do it YourSelf"]
[]
[null,"Order Date","Order ID","Amount",null,"Last Column Data"]
[null,"2021-12-15",1001,450]
[null,"2021-12-16",1002,325]
[null,"2021-12-17",1003,678]
[null,"2021-12-18",1004,876]
[null,"2021-12-19",1005,342]
[null,"2021-12-20",1006,543]