{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["main","find substitute","match sequence","array","Position VBA","search","vba string"],"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":"main","index":0,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[4,1,9,1],[1,1,1,3]]}
[]
[null,"Find Last Occurrence of Character in String"]
[]
[null,"Company Name","Employee Code","Last Occurrence"]
[null,"Company XYZ","Mike/32/Marketing"]
[null,null,"Adam/35/Sales"]
[null,null,"Heather/43/Accounting"]
[null,null,"John/47/HR"]
[null,null,"Jacob/34/Sales"]
[null,null,"Jonathan/34/Accounting"]

{"sheet":"find substitute","index":1,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[4,1,9,1],[1,1,1,3],[4,6,9,6],[1,6,1,8]]}
[]
[null,"Find Position of Last Occurrence of Character in String Using FIND, SUBSTITUTE Functions",null,null,null,null,"Practice"]
[]
[null,"Company Name","Employee Code","Last Occurrence of /",null,null,"Company Name","Employee Code","Last Occurrence of /"]
[null,"Company XYZ","Mike/32/Marketing",{"$f":"FIND(CHAR(134),SUBSTITUTE(C5,\"/\",CHAR(134),(LEN(C5)-LEN(SUBSTITUTE(C5,\"/\",\"\")))/LEN(\"/\")))","v":8},null,null,"Company XYZ","Mike/32/Marketing"]
[null,null,"Adam/35/Sales",{"$f":"FIND(CHAR(134),SUBSTITUTE(C6,\"/\",CHAR(134),(LEN(C6)-LEN(SUBSTITUTE(C6,\"/\",\"\")))/LEN(\"/\")))","v":8},null,null,null,"Adam/35/Sales"]
[null,null,"Heather/43/Accounting",11,null,null,null,"Heather/43/Accounting"]
[null,null,"John/47/HR",8,null,null,null,"John/47/HR"]
[null,null,"Jacob/34/Sales",9,null,null,null,"Jacob/34/Sales"]
[null,null,"Jonathan/34/Accounting",12,null,null,null,"Jonathan/34/Accounting"]

{"sheet":"match sequence","index":2,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[4,1,9,1],[1,1,1,3],[4,6,9,6],[1,6,1,8]]}
[]
[null,"Find Position of Last Occurrence of Character in String Using MATCH, SEQUENCE Functions",null,null,null,null,"Practice"]
[]
[null,"Company Name","Employee Code","Last Occurrence of /",null,null,"Company Name","Employee Code","Last Occurrence of /"]
[null,"Company XYZ","Mike/32/Marketing",{"$f":"MATCH(2,1/(MID(C5,_xlfn.SEQUENCE(LEN(C5)),1)=\"/\"))","v":8},null,null,"Company XYZ","Mike/32/Marketing"]
[null,null,"Adam/35/Sales",{"$f":"MATCH(2,1/(MID(C6,_xlfn.SEQUENCE(LEN(C6)),1)=\"/\"))","v":8},null,null,null,"Adam/35/Sales"]
[null,null,"Heather/43/Accounting",{"$f":"MATCH(2,1/(MID(C7,_xlfn.SEQUENCE(LEN(C7)),1)=\"/\"))","v":11},null,null,null,"Heather/43/Accounting"]
[null,null,"John/47/HR",{"$f":"MATCH(2,1/(MID(C8,_xlfn.SEQUENCE(LEN(C8)),1)=\"/\"))","v":8},null,null,null,"John/47/HR"]
[null,null,"Jacob/34/Sales",{"$f":"MATCH(2,1/(MID(C9,_xlfn.SEQUENCE(LEN(C9)),1)=\"/\"))","v":9},null,null,null,"Jacob/34/Sales"]
[null,null,"Jonathan/34/Accounting",{"$f":"MATCH(2,1/(MID(C10,_xlfn.SEQUENCE(LEN(C10)),1)=\"/\"))","v":12},null,null,null,"Jonathan/34/Accounting"]

{"sheet":"array","index":3,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[4,1,9,1],[1,1,1,3],[4,6,9,6],[1,6,1,8]]}
[]
[null,"Find Position of Last Occurrence of Character in String Using an Array Formula",null,null,null,null,"Practice"]
[]
[null,"Company Name","Employee Code","Last Occurrence of /",null,null,"Company Name","Employee Code","Last Occurrence of /"]
[null,"Company XYZ","Mike/32/Marketing",{"$f":"MATCH(2,1/(MID(C5,ROW($C$1:INDEX(C:C,LEN(C5))),1)=\"/\"))","v":8},null,null,"Company XYZ","Mike/32/Marketing"]
[null,null,"Adam/35/Sales",{"$f":"MATCH(2,1/(MID(C6,ROW($C$1:INDEX(C:C,LEN(C6))),1)=\"/\"))","v":8},null,null,null,"Adam/35/Sales"]
[null,null,"Heather/43/Accounting",{"$f":"MATCH(2,1/(MID(C7,ROW($C$1:INDEX(C:C,LEN(C7))),1)=\"/\"))","v":11},null,null,null,"Heather/43/Accounting"]
[null,null,"John/47/HR",{"$f":"MATCH(2,1/(MID(C8,ROW($C$1:INDEX(C:C,LEN(C8))),1)=\"/\"))","v":8},null,null,null,"John/47/HR"]
[null,null,"Jacob/34/Sales",{"$f":"MATCH(2,1/(MID(C9,ROW($C$1:INDEX(C:C,LEN(C9))),1)=\"/\"))","v":9},null,null,null,"Jacob/34/Sales"]
[null,null,"Jonathan/34/Accounting",{"$f":"MATCH(2,1/(MID(C10,ROW($C$1:INDEX(C:C,LEN(C10))),1)=\"/\"))","v":12},null,null,null,"Jonathan/34/Accounting"]

{"sheet":"Position VBA","index":4,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[4,1,9,1],[1,1,1,3],[4,6,9,6],[1,6,1,8]]}
[]
[null,"Find Position of Last Occurrence of Character in String Using a Custom VBA Function",null,null,null,null,"Practice"]
[]
[null,"Company Name","Employee Code","Last Occurrence of /",null,null,"Company Name","Employee Code","Last Occurrence of /"]
[null,"Company XYZ","Mike/32/Marketing",{"$f":"LOccurence(C5,\"/\")","v":8},null,null,"Company XYZ","Mike/32/Marketing"]
[null,null,"Adam/35/Sales",{"$f":"LOccurence(C6,\"/\")","v":8},null,null,null,"Adam/35/Sales"]
[null,null,"Heather/43/Accounting",{"$f":"LOccurence(C7,\"/\")","v":11},null,null,null,"Heather/43/Accounting"]
[null,null,"John/47/HR",{"$f":"LOccurence(C8,\"/\")","v":8},null,null,null,"John/47/HR"]
[null,null,"Jacob/34/Sales",{"$f":"LOccurence(C9,\"/\")","v":9},null,null,null,"Jacob/34/Sales"]
[null,null,"Jonathan/34/Accounting",{"$f":"LOccurence(C10,\"/\")","v":12},null,null,null,"Jonathan/34/Accounting"]

{"sheet":"search","index":5,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[4,1,9,1],[1,1,1,3],[4,6,9,6],[1,6,1,8]]}
[]
[null,"Find Last Occurrence of Character in String Using SEARCH, SUBSTITUTE Functions",null,null,null,null,"Practice"]
[]
[null,"Company Name","Employee Code","After Last Occurrence of /",null,null,"Company Name","Employee Code","Last Occurrence of /"]
[null,"Company XYZ","Mike/32/Marketing",{"$f":"RIGHT(C5,LEN(C5)-SEARCH(CHAR(134),SUBSTITUTE(C5,\"/\",CHAR(134),LEN(C5)-LEN(SUBSTITUTE(C5,\"/\",\"\")))))","v":"Marketing"},null,null,"Company XYZ","Mike/32/Marketing"]
[null,null,"Adam/35/Sales",{"$f":"RIGHT(C6,LEN(C6)-SEARCH(CHAR(134),SUBSTITUTE(C6,\"/\",CHAR(134),LEN(C6)-LEN(SUBSTITUTE(C6,\"/\",\"\")))))","v":"Sales"},null,null,null,"Adam/35/Sales"]
[null,null,"Heather/43/Accounting","Accounting",null,null,null,"Heather/43/Accounting"]
[null,null,"John/47/HR","HR",null,null,null,"John/47/HR"]
[null,null,"Jacob/34/Sales","Sales",null,null,null,"Jacob/34/Sales"]
[null,null,"Jonathan/34/Accounting","Accounting",null,null,null,"Jonathan/34/Accounting"]

{"sheet":"vba string","index":6,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[4,1,9,1],[1,1,1,3],[4,6,9,6],[1,6,1,8]]}
[]
[null,"Find Last Occurrence of Character in String Using a Custom VBA Formula",null,null,null,null,"Practice"]
[]
[null,"Company Name","Employee Code","After Last Occurrence of /",null,null,"Company Name","Employee Code","Last Occurrence of /"]
[null,"Company XYZ","Mike/32/Marketing",{"$f":"RIGHT(C5,LEN(C5)-LastString(C5,\"/\")+1)","v":"Marketing"},null,null,"Company XYZ","Mike/32/Marketing"]
[null,null,"Adam/35/Sales",{"$f":"RIGHT(C6,LEN(C6)-LastString(C6,\"/\")+1)","v":"Sales"},null,null,null,"Adam/35/Sales"]
[null,null,"Heather/43/Accounting",{"$f":"RIGHT(C7,LEN(C7)-LastString(C7,\"/\")+1)","v":"Accounting"},null,null,null,"Heather/43/Accounting"]
[null,null,"John/47/HR",{"$f":"RIGHT(C8,LEN(C8)-LastString(C8,\"/\")+1)","v":"HR"},null,null,null,"John/47/HR"]
[null,null,"Jacob/34/Sales",{"$f":"RIGHT(C9,LEN(C9)-LastString(C9,\"/\")+1)","v":"Sales"},null,null,null,"Jacob/34/Sales"]
[null,null,"Jonathan/34/Accounting",{"$f":"RIGHT(C10,LEN(C10)-LastString(C10,\"/\")+1)","v":"Accounting"},null,null,null,"Jonathan/34/Accounting"]