{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Dataset","Intersection Operator Single","Intersection Operator Multiple","Intersection Named Range","Named Range Drop-Down","Formula Intersection 2 Columns","VBA Intersection 2 Columns","Implicit Operator"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":15,"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":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Customer Satisfaction Rating"]
[]
[null,"Customer ID","Sales Rep","Jan","Feb","Mar"]
[null,1001,"Emma Johnson",4.2,4.5,4.8]
[null,1002,"David Smith",3.9,4.2,4.0999999999999996]
[null,1003,"Ava Blake",4.5999999999999996,4.4000000000000004,4.7]
[null,1004,"Oliver Davis",3.8,3.6,3.9]
[null,1005,"Sophia Lane",4.3,4.0999999999999996,4.5]
[null,1006,"Mia Roberts",3.7,4,3.8]
[null,1007,"Henry Wilson",4.5,4.7,4.5999999999999996]
[null,1008,"Isabella Taylor",3.6,3.9,3.7]
[null,1009,"Lucas Moore",4.4000000000000004,4.5999999999999996,4.3]
[null,1010,"Johny Bilbert",3.9,4.0999999999999996,3.8]

{"sheet":"Intersection Operator Single","index":1,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Finding Intersection of Single Row and Column"]
[]
[null,"Customer ID","Sales Rep","Jan","Feb","Mar"]
[null,1001,"Emma Johnson",4.2,4.5,4.8]
[null,1002,"David Smith",3.9,4.2,4.0999999999999996]
[null,1003,"Ava Blake",4.5999999999999996,4.4000000000000004,4.7]
[null,1004,"Oliver Davis",3.8,3.6,3.9]
[null,1005,"Sophia Lane",4.3,4.0999999999999996,4.5]
[null,1006,"Mia Roberts",3.7,4,3.8]
[null,1007,"Henry Wilson",4.5,4.7,4.5999999999999996]
[null,1008,"Isabella Taylor",3.6,3.9,3.7]
[null,1009,"Lucas Moore",4.4000000000000004,4.5999999999999996,4.3]
[null,1010,"Johny Bilbert",3.9,4.0999999999999996,3.8]
[]
[null,"Sales Rep","Ava Blake"]
[null,"Month","Feb"]
[null,"Rating",{"$f":"B7:F7 E4:E14","v":4.4000000000000004}]

{"sheet":"Intersection Operator Multiple","index":2,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,5],[15,2,15,3]]}
[]
[null,"Identifying Intersection of Multiple Rows and Columns"]
[]
[null,"Customer ID","Sales Rep","Jan","Feb","Mar"]
[null,1001,"Emma Johnson",4.2,4.5,4.8]
[null,1002,"David Smith",3.9,4.2,4.0999999999999996]
[null,1003,"Ava Blake",4.5999999999999996,4.4000000000000004,4.7]
[null,1004,"Oliver Davis",3.8,3.6,3.9]
[null,1005,"Sophia Lane",4.3,4.0999999999999996,4.5]
[null,1006,"Mia Roberts",3.7,4,3.8]
[null,1007,"Henry Wilson",4.5,4.7,4.5999999999999996]
[null,1008,"Isabella Taylor",3.6,3.9,3.7]
[null,1009,"Lucas Moore",4.4000000000000004,4.5999999999999996,4.3]
[null,1010,"Johny Bilbert",3.9,4.0999999999999996,3.8]
[]
[null,"Sales Rep","Ava Blake"]
[null,"Month","Jan","Feb"]
[null,"Rating",{"$f":"B7:F7 D4:E14","v":4.5999999999999996},4.4000000000000004]

{"sheet":"Intersection Named Range","index":3,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Locating Intersection of Single Row and Column"]
[]
[null,"Customer ID","Sales Rep","Jan","Feb","Mar"]
[null,1001,"Emma Johnson",4.2,4.5,4.8]
[null,1002,"David Smith",3.9,4.2,4.0999999999999996]
[null,1003,"Ava Blake",4.5999999999999996,4.4000000000000004,4.7]
[null,1004,"Oliver Davis",3.8,3.6,3.9]
[null,1005,"Sophia Lane",4.3,4.0999999999999996,4.5]
[null,1006,"Mia Roberts",3.7,4,3.8]
[null,1007,"Henry Wilson",4.5,4.7,4.5999999999999996]
[null,1008,"Isabella Taylor",3.6,3.9,3.7]
[null,1009,"Lucas Moore",4.4000000000000004,4.5999999999999996,4.3]
[null,1010,"Johny Bilbert",3.9,4.0999999999999996,3.8]
[]
[null,"Sales Rep","Ava Blake"]
[null,"Month","Feb"]
[null,"Rating",{"$f":"SalesRep_Ava Month_Feb","v":4.4000000000000004}]

{"sheet":"Named Range Drop-Down","index":4,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Finding Intersection of Named Ranges with Drop-down List"]
[]
[null,"Customer ID","Sales Rep","Jan","Feb","Mar"]
[null,1001,"Emma_Johnson",4.2,4.5,4.8]
[null,1002,"David_Smith",3.9,4.2,4.0999999999999996]
[null,1003,"Ava_Blake",4.5999999999999996,4.4000000000000004,4.7]
[null,1004,"Oliver_Davis",3.8,3.6,3.9]
[null,1005,"Sophia_Lane",4.3,4.0999999999999996,4.5]
[null,1006,"Mia_Roberts",3.7,4,3.8]
[null,1007,"Henry_Wilson",4.5,4.7,4.5999999999999996]
[null,1008,"Isabella_Taylor",3.6,3.9,3.7]
[null,1009,"Lucas_Moore",4.4000000000000004,4.5999999999999996,4.3]
[null,1010,"Johny_Bilbert",3.9,4.0999999999999996,3.8]
[]
[null,"Sales Rep","Ava_Blake"]
[null,"Month","Feb"]
[null,"Rating",{"$f":"INDIRECT(C16) INDIRECT(C17)","v":4.4000000000000004}]

{"sheet":"Formula Intersection 2 Columns","index":5,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using Formula to Find Intersection in Two Columns"]
[]
[null,"Customer ID","Sales Rep","Jan","Feb","Common Rating"]
[null,1001,"Emma Johnson",4.2,4.5,{"$f":"IF(ISERROR(MATCH(D5,$E$5:$E$14,0)),\"\",D5)","v":4.2}]
[null,1002,"David Smith",3.9,4.2,{"$f":"IF(ISERROR(MATCH(D6,$E$5:$E$14,0)),\"\",D6)","v":3.9}]
[null,1003,"Ava Blake",4.5999999999999996,4.4000000000000004,4.5999999999999996]
[null,1004,"Oliver Davis",3.8,3.6,""]
[null,1005,"Sophia Lane",4.3,4.0999999999999996,""]
[null,1006,"Mia Roberts",3.7,4,""]
[null,1007,"Henry Wilson",4.5,4.7,4.5]
[null,1008,"Isabella Taylor",3.6,3.9,3.6]
[null,1009,"Lucas Moore",4.4000000000000004,4.5999999999999996,4.4000000000000004]
[null,1010,"Johny Bilbert",3.9,4.0999999999999996,3.9]

{"sheet":"VBA Intersection 2 Columns","index":6,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using Formula to Find Intersection in Two Columns"]
[]
[null,"Customer ID","Sales Rep","Jan","Feb","Common Rating"]
[null,1001,"Emma Johnson",4.2,4.5,4.2]
[null,1002,"David Smith",3.9,4.2,3.9]
[null,1003,"Ava Blake",4.5999999999999996,4.4000000000000004,4.5999999999999996]
[null,1004,"Oliver Davis",3.8,3.6]
[null,1005,"Sophia Lane",4.3,4.0999999999999996]
[null,1006,"Mia Roberts",3.7,4]
[null,1007,"Henry Wilson",4.5,4.7,4.5]
[null,1008,"Isabella Taylor",3.6,3.9,3.6]
[null,1009,"Lucas Moore",4.4000000000000004,4.5999999999999996,4.4000000000000004]
[null,1010,"Johny Bilbert",3.9,4.0999999999999996,3.9]

{"sheet":"Implicit Operator","index":7,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Using Implicit Operator"]
[]
[null,"Customer ID","Sales Rep","Jan","Feb","Mar","Total Rating","Total Rating with @ Operator"]
[null,1001,"Emma Johnson",4.2,4.5,4.8,{"$f":"D5:D14+E5:E14+F5:F14","v":13.5},{"$f":"D5:D14+E5:E14+F5:F14","v":13.5}]
[null,1002,"David Smith",3.9,4.2,4.0999999999999996,12.2]
[null,1003,"Ava Blake",4.5999999999999996,4.4000000000000004,4.7,13.7]
[null,1004,"Oliver Davis",3.8,3.6,3.9,11.3]
[null,1005,"Sophia Lane",4.3,4.0999999999999996,4.5,12.899999999999999]
[null,1006,"Mia Roberts",3.7,4,3.8,11.5]
[null,1007,"Henry Wilson",4.5,4.7,4.5999999999999996,13.799999999999999]
[null,1008,"Isabella Taylor",3.6,3.9,3.7,11.2]
[null,1009,"Lucas Moore",4.4000000000000004,4.5999999999999996,4.3,13.3]
[null,1010,"Johny Bilbert",3.9,4.0999999999999996,3.8,11.8]