{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Overview","User_Input","Array","Selection","Range.FindExactMatch","Range.FindPartialMatch","Find and Replace"],"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":"Overview","index":0,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Overview of Finding Multiple Values with  VBA in Excel"]
[]
[null,"Books","Author","Genre","Published",null,"Find Author(s)"]
[null,"Fire and Blood","George R.R.Martin","Fantasy",2018,null,"George R.R.Martin"]
[null,"The Gene","Siddhartha Mukherjee","Non-Fiction",2016,null,"George Orwell"]
[null,1984,"George Orwell","Dystopian Fiction",1949,null,"Siddhartha Mukherjee"]
[null,"A Game of Thrones","George R.R.Martin","Fantasy",1996,null,"Haruki Murakami"]
[null,"Kafka on the Shore","Haruki Murakami","Fiction",2002,null,"Dan Brown"]
[null,"Animal Farm: A Fairy Story","George Orwell","Dystopian Fiction",1945]
[null,"The Emperor of All Maladies","Siddhartha Mukherjee","Non-Fiction",2010]
[null,"The Da Vinci Code","Dan Brown","Fiction",2003]
[null,"Norwegian Wood","Haruki Murakami","Fiction",1987]
[null,"Inferno","Dan Brown","Fiction",2013]

{"sheet":"User_Input","index":1,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Finding Multiple Values from User Input"]
[]
[null,"Books","Author","Genre","Published"]
[null,"Fire and Blood","George R.R.Martin","Fantasy",2018]
[null,"The Gene","Siddhartha Mukherjee","Non-Fiction",2016]
[null,1984,"George Orwell","Dystopian Fiction",1949]
[null,"A Game of Thrones","George R.R.Martin","Fantasy",1996]
[null,"Kafka on the Shore","Haruki Murakami","Fiction",2002]
[null,"Animal Farm: A Fairy Story","George Orwell","Dystopian Fiction",1945]
[null,"The Emperor of All Maladies","Siddhartha Mukherjee","Non-Fiction",2010]
[null,"The Da Vinci Code","Dan Brown","Fiction",2003]
[null,"Norwegian Wood","Haruki Murakami","Fiction",1987]
[null,"Inferno","Dan Brown","Fiction",2013]

{"sheet":"Array","index":2,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using Array to Find Multiple Values"]
[]
[null,"Books","Author","Genre","Published"]
[null,"Fire and Blood","George R.R.Martin","Fantasy",2018]
[null,"The Gene","Siddhartha Mukherjee","Non-Fiction",2016]
[null,1984,"George Orwell","Dystopian Fiction",1949]
[null,"A Game of Thrones","George R.R.Martin","Fantasy",1996]
[null,"Kafka on the Shore","Haruki Murakami","Fiction",2002]
[null,"Animal Farm: A Fairy Story","George Orwell","Dystopian Fiction",1945]
[null,"The Emperor of All Maladies","Siddhartha Mukherjee","Non-Fiction",2010]
[null,"The Da Vinci Code","Dan Brown","Fiction",2003]
[null,"Norwegian Wood","Haruki Murakami","Fiction",1987]
[null,"Inferno","Dan Brown","Fiction",2013]

{"sheet":"Selection","index":3,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Finding Multiple Values from Selection"]
[]
[null,"Books","Author","Genre","Published",null,"Find Author(s)"]
[null,"Fire and Blood","George R.R.Martin","Fantasy",2018,null,"George R.R.Martin"]
[null,"The Gene","Siddhartha Mukherjee","Non-Fiction",2016,null,"George Orwell"]
[null,1984,"George Orwell","Dystopian Fiction",1949,null,"Siddhartha Mukherjee"]
[null,"A Game of Thrones","George R.R.Martin","Fantasy",1996,null,"Haruki Murakami"]
[null,"Kafka on the Shore","Haruki Murakami","Fiction",2002,null,"Dan Brown"]
[null,"Animal Farm: A Fairy Story","George Orwell","Dystopian Fiction",1945]
[null,"The Emperor of All Maladies","Siddhartha Mukherjee","Non-Fiction",2010]
[null,"The Da Vinci Code","Dan Brown","Fiction",2003]
[null,"Norwegian Wood","Haruki Murakami","Fiction",1987]
[null,"Inferno","Dan Brown","Fiction",2013]

{"sheet":"Range.FindExactMatch","index":4,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using Range.Find Method to Find Multiple Values with Exact Match"]
[]
[null,"Books","Author","Genre","Published"]
[null,"Fire and Blood","George R.R.Martin","Fantasy",2018]
[null,"The Gene","Siddhartha Mukherjee","Non-Fiction",2016]
[null,1984,"George Orwell","Dystopian Fiction",1949]
[null,"A Game of Thrones","George R.R.Martin","Fantasy",1996]
[null,"Kafka on the Shore","Haruki Murakami","Fiction",2002]
[null,"Animal Farm: A Fairy Story","George Orwell","Dystopian Fiction",1945]
[null,"The Emperor of All Maladies","Siddhartha Mukherjee","Non-Fiction",2010]
[null,"The Da Vinci Code","Dan Brown","Fiction",2003]
[null,"Norwegian Wood","Haruki Murakami","Fiction",1987]
[null,"Inferno","Dan Brown","Fiction",2013]

{"sheet":"Range.FindPartialMatch","index":5,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using Range.Find Method to Find Multiple Values with Partial Match"]
[]
[null,"Books","Author","Genre","Published"]
[null,"Fire and Blood","George R.R.Martin","Fantasy",2018]
[null,"The Gene","Siddhartha Mukherjee","Non-Fiction",2016]
[null,1984,"George Orwell","Dystopian Fiction",1949]
[null,"A Game of Thrones","George R.R.Martin","Fantasy",1996]
[null,"Kafka on the Shore","Haruki Murakami","Fiction",2002]
[null,"Animal Farm: A Fairy Story","George Orwell","Dystopian Fiction",1945]
[null,"The Emperor of All Maladies","Siddhartha Mukherjee","Non-Fiction",2010]
[null,"The Da Vinci Code","Dan Brown","Fiction",2003]
[null,"Norwegian Wood","Haruki Murakami","Fiction",1987]
[null,"Inferno","Dan Brown","Fiction",2013]

{"sheet":"Find and Replace","index":6,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Find and Replace Multiple Values"]
[]
[null,"Books","Author","Genre","Published",null,"Find","Replace With"]
[null,"Fire and Blood","George R.R.Martin","Fantasy",2018,null,"Dystopian Fiction","Fiction"]
[null,"The Gene","Siddhartha Mukherjee","Science Fiction",2016,null,"Science Fiction","Non-Fiction"]
[null,1984,"George Orwell","Dystopian Fiction",1949]
[null,"A Game of Thrones","George R.R.Martin","Fantasy",1996]
[null,"Kafka on the Shore","Haruki Murakami","Fiction",2002]
[null,"Animal Farm: A Fairy Story","George Orwell","Dystopian Fiction",1945]
[null,"The Emperor of All Maladies","Siddhartha Mukherjee","Science Fiction",2010]
[null,"The Da Vinci Code","Dan Brown","Fiction",2003]
[null,"Norwegian Wood","Haruki Murakami","Fiction",1987]
[null,"Inferno","Dan Brown","Fiction",2013]