{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Introduction","Excel_Calculations","VBA_Macros","VBA_SQL"],"not_rendered":{"charts":0,"images":8,"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":"Introduction","index":0,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[[2,1,18,9]]}
[null,null,null,null,null,"www.Tricks12345.com"]
[]
[null,"Excel - VBA - SQL"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Pavan Kumar Gundlapalli"]

{"sheet":"Excel_Calculations","index":1,"n_rows":18,"n_cols":12,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Day","Institute","Course","Trainer","Unique -I","Unique - C",1,2,3]
["2017-01-01","First","Excel","Guru",{"$f":"IFERROR(INDEX($B$2:$B$18, MATCH(0, COUNTIF($E$1:E1, $B$2:$B$18), 0)),\"\")","v":"First"},{"$f":"IFERROR(INDEX($C$2:$C$18, MATCH(0, COUNTIF($F$1:F1, $C$2:$C$18), 0)),\"\")","v":"Excel"},{"$f":"IF(B2=$K$3,D2,\"\")","v":"Guru"},{"$f":"IF(COUNTIF($G$2:G2,G2)=1,G2,\"\")","v":"Guru"},{"$f":"IF(AND(B2=$K$3,C2=$L$3),D2,\"\")","v":"Guru"},null,"Institute","Course"]
["2017-01-02","Second","VBA","Pavan",{"$f":"IFERROR(INDEX($B$2:$B$18, MATCH(0, COUNTIF($E$1:E2, $B$2:$B$18), 0)),\"\")","v":"Second"},{"$f":"IFERROR(INDEX($C$2:$C$18, MATCH(0, COUNTIF($F$1:F2, $C$2:$C$18), 0)),\"\")","v":"VBA"},{"$f":"IF(B3=$K$3,D3,\"\")","v":""},{"$f":"IF(COUNTIF($G$2:G3,G3)=1,G3,\"\")","v":""},{"$f":"IF(AND(B3=$K$3,C3=$L$3),D3,\"\")","v":""},null,"First","Excel"]
["2017-01-03","First","SQL","Pavan",{"$f":"IFERROR(INDEX($B$2:$B$18, MATCH(0, COUNTIF($E$1:E3, $B$2:$B$18), 0)),\"\")","v":"Third"},{"$f":"IFERROR(INDEX($C$2:$C$18, MATCH(0, COUNTIF($F$1:F3, $C$2:$C$18), 0)),\"\")","v":"SQL"},"Pavan",{"$f":"IF(COUNTIF($G$2:G4,G4)=1,G4,\"\")","v":"Pavan"},""]
["2017-01-04","Second","Excel","Raghu",{"$f":"IFERROR(INDEX($B$2:$B$18, MATCH(0, COUNTIF($E$1:E4, $B$2:$B$18), 0)),\"\")","v":"Fourth"},{"$f":"IFERROR(INDEX($C$2:$C$18, MATCH(0, COUNTIF($F$1:F4, $C$2:$C$18), 0)),\"\")","v":""},"",{"$f":"IF(COUNTIF($G$2:G5,G5)=1,G5,\"\")","v":""},""]
["2017-01-05","First","VBA","Pavan",{"$f":"IFERROR(INDEX($B$2:$B$18, MATCH(0, COUNTIF($E$1:E5, $B$2:$B$18), 0)),\"\")","v":"Fifth"},{"$f":"IFERROR(INDEX($C$2:$C$18, MATCH(0, COUNTIF($F$1:F5, $C$2:$C$18), 0)),\"\")","v":""},"Pavan",{"$f":"IF(COUNTIF($G$2:G6,G6)=1,G6,\"\")","v":""},""]
["2017-01-06","Second","SQL","Guru",{"$f":"IFERROR(INDEX($B$2:$B$18, MATCH(0, COUNTIF($E$1:E6, $B$2:$B$18), 0)),\"\")","v":""},{"$f":"IFERROR(INDEX($C$2:$C$18, MATCH(0, COUNTIF($F$1:F6, $C$2:$C$18), 0)),\"\")","v":""},"",{"$f":"IF(COUNTIF($G$2:G7,G7)=1,G7,\"\")","v":""},"",1,"List the Trainers Based on Institute"]
["2017-01-07","First","Excel","Charan",{"$f":"IFERROR(INDEX($B$2:$B$18, MATCH(0, COUNTIF($E$1:E7, $B$2:$B$18), 0)),\"\")","v":""},{"$f":"IFERROR(INDEX($C$2:$C$18, MATCH(0, COUNTIF($F$1:F7, $C$2:$C$18), 0)),\"\")","v":""},"Charan",{"$f":"IF(COUNTIF($G$2:G8,G8)=1,G8,\"\")","v":"Charan"},"Charan",2,"List the Unique Trainers Based on Institute"]
["2017-01-08","Second","Excel","Pavan",{"$f":"IFERROR(INDEX($B$2:$B$18, MATCH(0, COUNTIF($E$1:E8, $B$2:$B$18), 0)),\"\")","v":""},{"$f":"IFERROR(INDEX($C$2:$C$18, MATCH(0, COUNTIF($F$1:F8, $C$2:$C$18), 0)),\"\")","v":""},"",{"$f":"IF(COUNTIF($G$2:G9,G9)=1,G9,\"\")","v":""},"",3,"List the Trainers works in Particular Institute and Course"]
["2017-01-09","First","VBA","Raghu",{"$f":"IFERROR(INDEX($B$2:$B$18, MATCH(0, COUNTIF($E$1:E9, $B$2:$B$18), 0)),\"\")","v":""},{"$f":"IFERROR(INDEX($C$2:$C$18, MATCH(0, COUNTIF($F$1:F9, $C$2:$C$18), 0)),\"\")","v":""},"Raghu",{"$f":"IF(COUNTIF($G$2:G10,G10)=1,G10,\"\")","v":"Raghu"},""]
["2017-01-10","First","SQL","Pavan",{"$f":"IFERROR(INDEX($B$2:$B$18, MATCH(0, COUNTIF($E$1:E10, $B$2:$B$18), 0)),\"\")","v":""},{"$f":"IFERROR(INDEX($C$2:$C$18, MATCH(0, COUNTIF($F$1:F10, $C$2:$C$18), 0)),\"\")","v":""},"Pavan",{"$f":"IF(COUNTIF($G$2:G11,G11)=1,G11,\"\")","v":""},""]
["2017-01-11","First","Excel","Raghu",{"$f":"IFERROR(INDEX($B$2:$B$18, MATCH(0, COUNTIF($E$1:E11, $B$2:$B$18), 0)),\"\")","v":""},{"$f":"IFERROR(INDEX($C$2:$C$18, MATCH(0, COUNTIF($F$1:F11, $C$2:$C$18), 0)),\"\")","v":""},"Raghu",{"$f":"IF(COUNTIF($G$2:G12,G12)=1,G12,\"\")","v":""},"Raghu"]
["2017-01-12","Third","VBA","Ramu",{"$f":"IFERROR(INDEX($B$2:$B$18, MATCH(0, COUNTIF($E$1:E12, $B$2:$B$18), 0)),\"\")","v":""},{"$f":"IFERROR(INDEX($C$2:$C$18, MATCH(0, COUNTIF($F$1:F12, $C$2:$C$18), 0)),\"\")","v":""},"",{"$f":"IF(COUNTIF($G$2:G13,G13)=1,G13,\"\")","v":""},""]
["2017-01-13","Fourth","SQL","Guru",{"$f":"IFERROR(INDEX($B$2:$B$18, MATCH(0, COUNTIF($E$1:E13, $B$2:$B$18), 0)),\"\")","v":""},{"$f":"IFERROR(INDEX($C$2:$C$18, MATCH(0, COUNTIF($F$1:F13, $C$2:$C$18), 0)),\"\")","v":""},"",{"$f":"IF(COUNTIF($G$2:G14,G14)=1,G14,\"\")","v":""},""]
["2017-01-14","Second","Excel","Charan",{"$f":"IFERROR(INDEX($B$2:$B$18, MATCH(0, COUNTIF($E$1:E14, $B$2:$B$18), 0)),\"\")","v":""},{"$f":"IFERROR(INDEX($C$2:$C$18, MATCH(0, COUNTIF($F$1:F14, $C$2:$C$18), 0)),\"\")","v":""},"",{"$f":"IF(COUNTIF($G$2:G15,G15)=1,G15,\"\")","v":""},""]
["2017-01-15","First","SQL","Ramu",{"$f":"IFERROR(INDEX($B$2:$B$18, MATCH(0, COUNTIF($E$1:E15, $B$2:$B$18), 0)),\"\")","v":""},{"$f":"IFERROR(INDEX($C$2:$C$18, MATCH(0, COUNTIF($F$1:F15, $C$2:$C$18), 0)),\"\")","v":""},"Ramu",{"$f":"IF(COUNTIF($G$2:G16,G16)=1,G16,\"\")","v":"Ramu"},""]
["2017-01-16","Second","SQL","Guru",{"$f":"IFERROR(INDEX($B$2:$B$18, MATCH(0, COUNTIF($E$1:E16, $B$2:$B$18), 0)),\"\")","v":""},{"$f":"IFERROR(INDEX($C$2:$C$18, MATCH(0, COUNTIF($F$1:F16, $C$2:$C$18), 0)),\"\")","v":""},"",{"$f":"IF(COUNTIF($G$2:G17,G17)=1,G17,\"\")","v":""},""]
["2017-01-17","Fifth","Excel","Pavan",{"$f":"IFERROR(INDEX($B$2:$B$18, MATCH(0, COUNTIF($E$1:E17, $B$2:$B$18), 0)),\"\")","v":""},{"$f":"IFERROR(INDEX($C$2:$C$18, MATCH(0, COUNTIF($F$1:F17, $C$2:$C$18), 0)),\"\")","v":""},"",{"$f":"IF(COUNTIF($G$2:G18,G18)=1,G18,\"\")","v":""},""]

{"sheet":"VBA_Macros","index":2,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Day","Institute","Course","Trainer","Unique -I","Unique - C",1,2,3]
["2017-01-01","First","Excel","Guru","First","Excel","Guru","Guru","Guru",null,null,null,"Institute","Course"]
["2017-01-02","Second","VBA","Pavan","Second","VBA","Pavan","Pavan","Charan",null,null,null,"First","Excel"]
["2017-01-03","First","SQL","Pavan","Third","SQL","Pavan","Charan","Raghu"]
["2017-01-04","Second","Excel","Raghu","Fourth",null,"Charan","Raghu"]
["2017-01-05","First","VBA","Pavan","Fifth",null,"Raghu","Ramu",null,null,1,"List the Trainers works in Particular Institute"]
["2017-01-06","Second","SQL","Guru",null,null,"Pavan",null,null,null,2,"List the unique Trainers works in Particular Institute"]
["2017-01-07","First","Excel","Charan",null,null,"Raghu",null,null,null,3,"List the Trainers works in Particular Institute and Course"]
["2017-01-08","Second","Excel","Pavan",null,null,"Ramu"]
["2017-01-09","First","VBA","Raghu"]
["2017-01-10","First","SQL","Pavan"]
["2017-01-11","First","Excel","Raghu"]
["2017-01-12","Third","VBA","Ramu"]
["2017-01-13","Fourth","SQL","Guru"]
["2017-01-14","Second","Excel","Charan"]
["2017-01-15","First","SQL","Ramu"]
["2017-01-16","Second","SQL","Guru"]
["2017-01-17","Fifth","Excel","Pavan"]

{"sheet":"VBA_SQL","index":3,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Day","Institute","Course","Trainer",1,2,3]
["2017-01-01","First","Excel","Guru","Guru","Guru","Charan"]
["2017-01-02","Second","VBA","Pavan","Ramu","Pavan","Guru"]
["2017-01-03","First","SQL","Pavan","Pavan","Raghu","Pavan"]
["2017-01-04","Second","Excel","Raghu","Raghu","Ramu","Raghu"]
["2017-01-05","First","VBA","Pavan","Pavan",null,"Ramu"]
["2017-01-06","Second","SQL","Guru"]
["2017-01-07","First","Excel","Ramu",null,null,null,null,null,1,"Works in FIRST institute and Teaches EXCEL"]
["2017-01-08","Second","Excel","Pavan",null,null,null,null,null,2,"List the unique Trainers from Q1"]
["2017-01-09","First","VBA","Raghu",null,null,null,null,null,3,"Who teaches VBA in First or second Institute"]
["2017-01-10","First","Excel","Pavan"]
["2017-01-11","First","Excel","Raghu"]
["2017-01-12","Third","VBA","Ramu"]
["2017-01-13","Fourth","SQL","Guru"]
["2017-01-14","Second","Excel","Charan"]
["2017-01-15","First","SQL","Ramu"]
["2017-01-16","Second","SQL","Guru"]
["2017-01-17","First","Excel","Pavan"]