{"text_format":"1","workbook":"xlsx","n_sheets":130,"sheets":["Introduction","Buttons","ABS","Address","Aggregate_Average","Aggregate_Count","Aggregate_CountA","Aggregate_MAX","Aggregate_MIN","And_Operator","Average","Cal_Price_Rng_Using_IndexMatch","Cell_Function_info_type_address","Cell_Function_info_type_content","Cell_Function_info_type_filenam","Cell_Function_infotype_col","Cell_Function_infotype_Row","Cell_Function_Infotype_type","Cell_Function_infotype_width","Choose","Column","Compare_Two_Lists_Only_In_First","Compare_Two_Lists_Only_In_Secnd","Concatenate","Concatenate_With_Cell_Reference","Count","Count_Blank_Cells_Using_CountIF","Count_NonTextCells_UsingCountIF","CountA","CountIF","CountIF_FourthChar_As_L","CountIF_Function_With_Dates","CountIF_PartialMatch_WildCard","CountIf_Sum_Multiple_Criterias","CountIF_with_Conditional_Format","CountIf_With_Single_Criteria","CountIfOnDynamicRng UsingOffset","CountNonBlankCellsUsing_CountIF","Date","Day","Days360","Double_VLookup","Even","Exact","Filldown_Dates_5_Days_Diff","Find","Find_Function_Extract_TextNumb","Find_Function_Split_Left_Part","Find_Function_Split_Right_Part","HLookup","Hour","Identify_Dupes_On_Multi_Columns","IF_Condition_Assign_Grades","If_Condition_Pass_Or_Fail","IF_Condition_Using_Min_And_Max","IF_Function_With_And_Operator","Index","Index_Function","Indirect","Indirect_Dependant_Dropdown","ISBLANK","ISError_With_VLookup","ISEven","ISFORMULA","ISNA_With_VLookup","ISNONTEXT","IsNumber","ISODD","ISText","Large","Left","Len","Lookup_RightToLeft_IndexMatch","Lower","Match","Max","MID","MID_Function_Extract_GmailIDs","Min","Mod","Month","Multiple_Condns_to_OR_with_IF","NestedIF_Function_Grading_Price","NetWorkingDays","Now","ODD","OR_Operator","OR_Operator_with_IF_Condition","Proper","Quotient","Rank","Rank_when_Duplicates_Exists","Remove_Dupes_IndexMatchIfError","Remove_Dupes_VLookupIFError_Row","Remove_Duplicates_IF_CountIF","Remove_Last_Two_Chars_Left_Len","Replace","Replace_Using_IF_And_Left_Func","Rept","Retrieve_Dupes_Using_CountIF_IF","Right","ROMAN","Round","RoundDown","RoundUp","Row","Search","SHEET","Small","Split_The_Text_Using_FIND_func","Substitute","Sum","Sum_Based_On_Incremental_Range","Sum_Large_Three_Values","Sum_The_Named_Range","SumIF_Based_On_Len_Of_Text","SumIF_Based_On_WildCard_Chactr","SumIF_Dates","SumIF_Function","SumIF_Multiple_Criteria_On_Col","SumIFs_With_Dates","Time_Add_Hrs_Mins_Secs","Trim","Trim_Remove_Space","Upper","VLookup_Grades_With_ApproxMatch","VLookup_Match_Function_For_Col","VLookup_TotalCost_Calculation","Year","Add_SerialNumbs_UsingIsBlank_IF"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":7,"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 Functions"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Pavan Kumar Gundlapalli"]

{"sheet":"Buttons","index":1,"n_rows":130,"n_cols":1,"rows_kept":130,"cut":false,"hidden":false,"merged":[]}
["Worksheets"]
["Introduction"]
["Add_SerialNumbs_UsingIsBlank_IF"]
["ABS"]
["Address"]
["Aggregate_Average"]
["Aggregate_Count"]
["Aggregate_CountA"]
["Aggregate_MAX"]
["Aggregate_MIN"]
["And_Operator"]
["Average"]
["Cal_Price_Rng_Using_IndexMatch"]
["Cell_Function_info_type_address"]
["Cell_Function_info_type_content"]
["Cell_Function_info_type_filenam"]
["Cell_Function_infotype_col"]
["Cell_Function_infotype_Row"]
["Cell_Function_Infotype_type"]
["Cell_Function_infotype_width"]
["Choose"]
["Column"]
["Compare_Two_Lists_Only_In_First"]
["Compare_Two_Lists_Only_In_Secnd"]
["Concatenate"]
["Concatenate_With_Cell_Reference"]
["Count"]
["Count_Blank_Cells_Using_CountIF"]
["Count_NonTextCells_UsingCountIF"]
["CountA"]
["CountIF"]
["CountIF_FourthChar_As_L"]
["CountIF_Function_With_Dates"]
["CountIF_PartialMatch_WildCard"]
["CountIf_Sum_Multiple_Criterias"]
["CountIF_with_Conditional_Format"]
["CountIf_With_Single_Criteria"]
["CountIfOnDynamicRng UsingOffset"]
["CountNonBlankCellsUsing_CountIF"]
["Date"]
["Day"]
["Days360"]
["Double_VLookup"]
["Even"]
["Exact"]
["Filldown_Dates_5_Days_Diff"]
["Find"]
["Find_Function_Extract_TextNumb"]
["Find_Function_Split_Left_Part"]
["Find_Function_Split_Right_Part"]
["HLookup"]
["Hour"]
["Identify_Dupes_On_Multi_Columns"]
["IF_Condition_Assign_Grades"]
["If_Condition_Pass_Or_Fail"]
["IF_Condition_Using_Min_And_Max"]
["IF_Function_With_And_Operator"]
["Index"]
["Index_Function"]
["Indirect"]
["Indirect_Dependant_Dropdown"]
["ISBLANK"]
["ISError_With_VLookup"]
["ISEven"]
["ISFORMULA"]
["ISNA_With_VLookup"]
["ISNONTEXT"]
["IsNumber"]
["ISODD"]
["ISText"]
["Large"]
["Left"]
["Len"]
["Lookup_RightToLeft_IndexMatch"]
["Lower"]
["Match"]
["Max"]
["MID"]
["MID_Function_Extract_GmailIDs"]
["Min"]
["Mod"]
["Month"]
["Multiple_Condns_to_OR_with_IF"]
["NestedIF_Function_Grading_Price"]
["NetWorkingDays"]
["Now"]
["ODD"]
["OR_Operator"]
["OR_Operator_with_IF_Condition"]
["Proper"]
["Quotient"]
["Rank"]
["Rank_when_Duplicates_Exists"]
["Remove_Dupes_IndexMatchIfError"]
["Remove_Dupes_VLookupIFError_Row"]
["Remove_Duplicates_IF_CountIF"]
["Remove_Last_Two_Chars_Left_Len"]
["Replace"]
["Replace_Using_IF_And_Left_Func"]
["Rept"]
["Retrieve_Dupes_Using_CountIF_IF"]
["Right"]
["ROMAN"]
["Round"]
["RoundDown"]
["RoundUp"]
["Row"]
["Search"]
["SHEET"]
["Small"]
["Split_The_Text_Using_FIND_func"]
["Substitute"]
["Sum"]
["Sum_Based_On_Incremental_Range"]
["Sum_Large_Three_Values"]
["Sum_The_Named_Range"]
["SumIF_Based_On_Len_Of_Text"]
["SumIF_Based_On_WildCard_Chactr"]
["SumIF_Dates"]
["SumIF_Function"]
["SumIF_Multiple_Criteria_On_Col"]
["SumIFs_With_Dates"]
["Time_Add_Hrs_Mins_Secs"]
["Trim"]
["Trim_Remove_Space"]
["Upper"]
["VLookup_Grades_With_ApproxMatch"]
["VLookup_Match_Function_For_Col"]
["VLookup_TotalCost_Calculation"]
["Year"]

{"sheet":"ABS","index":2,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["ABS Function",null,null,null,null,null,null,null,null,"Return To Index"]
["Data","Price","Formula"]
[-44,{"$f":"ABS(A3)","v":44}," =ABS(A3)"]
[58,{"$f":"ABS(A4)","v":58}," =ABS(A4)"]
[48.56,48.56," =ABS(A5)"]
[-48,48," =ABS(A6)"]
[0.66,0.66," =ABS(A7)"]

{"sheet":"Address","index":3,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Address Fucntion",null,null,null,null,null,null,null,null,"Return To Index"]
["Data","Result","Formula"]
["Apple",{"$f":"ADDRESS(ROW(),1,1,TRUE,\"Address\")","v":"Address!$A$3"}," =ADDRESS(ROW(),1,1,TRUE,\"Address\")"]
["Banana",{"$f":"ADDRESS(ROW(),1,1,TRUE,\"Address\")","v":"Address!$A$4"}," =ADDRESS(ROW(),1,1,TRUE,\"Address\")"]
["Orange","Address!$A$5"," =ADDRESS(ROW(),1,1,TRUE,\"Address\")"]
["Grapes","Address!$A$6"," =ADDRESS(ROW(),1,1,TRUE,\"Address\")"]
["PineApple","Address!$A$7"," =ADDRESS(ROW(),1,1,TRUE,\"Address\")"]
[]
[]
[]
[]
[null,null,null,null,"Lookup & Reference Function"]
[null,null,null,null,"It returns cell reference as Address"]

{"sheet":"Aggregate_Average","index":4,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Aggregate Function - Average",null,null,null,null,null,null,null,null,"Return To Index"]
["Data","Price","Result","Formula"]
["Apple",55,{"$f":"_xlfn.AGGREGATE(1,,B3:B$7)","v":49.8}," =AGGREGATE(1,,B3:B$7)"]
["Banana",25,{"$f":"_xlfn.AGGREGATE(1,,B4:B$7)","v":48.5}," =AGGREGATE(1,,B4:B$7)"]
["Orange",48,{"$f":"_xlfn.AGGREGATE(1,,B5:B$7)","v":56.333333333333336}," =AGGREGATE(1,,B5:B$7)"]
["Grapes",85,{"$f":"_xlfn.AGGREGATE(1,,B6:B$7)","v":60.5}," =AGGREGATE(1,,B6:B$7)"]
["PineApple",36,{"$f":"_xlfn.AGGREGATE(1,,B7:B$7)","v":36}," =AGGREGATE(1,,B7:B$7)"]
[]
[]
[]
[]
[null,null,null,"Math & Trig Function"]

{"sheet":"Aggregate_Count","index":5,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Aggregate Function - Count",null,null,null,null,null,null,null,null,"Return To Index"]
["Data","Price","Result","Formula"]
["Apple",55,{"$f":"_xlfn.AGGREGATE(2,,B3:B$7)","v":5}," =AGGREGATE(2,,B3:B$7)"]
["Banana",25,{"$f":"_xlfn.AGGREGATE(2,,B4:B$7)","v":4}," =AGGREGATE(2,,B4:B$7)"]
["Orange",48,{"$f":"_xlfn.AGGREGATE(2,,B5:B$7)","v":3}," =AGGREGATE(2,,B5:B$7)"]
["Grapes",85,{"$f":"_xlfn.AGGREGATE(2,,B6:B$7)","v":2}," =AGGREGATE(2,,B6:B$7)"]
["PineApple",36,{"$f":"_xlfn.AGGREGATE(2,,B7:B$7)","v":1}," =AGGREGATE(2,,B7:B$7)"]
[]
[]
[]
[]
[null,null,null,"Math & Trig Function"]

{"sheet":"Aggregate_CountA","index":6,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Aggregate Function - CountA",null,null,null,null,null,null,null,null,"Return To Index"]
["Data","Price","Result","Formula"]
["Apple",55,{"$f":"_xlfn.AGGREGATE(3,4,B3:B$7)","v":5}," =AGGREGATE(3,4,B3:B$7)"]
["Banana",25,{"$f":"_xlfn.AGGREGATE(3,4,B4:B$7)","v":4}," =AGGREGATE(3,4,B4:B$7)"]
["Orange",48,{"$f":"_xlfn.AGGREGATE(3,4,B5:B$7)","v":3}," =AGGREGATE(3,4,B5:B$7)"]
["Grapes",85,{"$f":"_xlfn.AGGREGATE(3,4,B6:B$7)","v":2}," =AGGREGATE(3,4,B6:B$7)"]
["PineApple",36,{"$f":"_xlfn.AGGREGATE(3,4,B7:B$7)","v":1}," =AGGREGATE(3,4,B7:B$7)"]
[]
[]
[]
[]
[null,null,null,"Math & Trig Function"]

{"sheet":"Aggregate_MAX","index":7,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Aggregate Function - MAX",null,null,null,null,null,null,null,null,"Return To Index"]
["Data","Price","Result","Formula"]
["Apple",55,{"$f":"_xlfn.AGGREGATE(4,4,B3:B$7)","v":98}," =AGGREGATE(4,4,B3:B$7)"]
["Banana",98,{"$f":"_xlfn.AGGREGATE(4,4,B4:B$7)","v":98}," =AGGREGATE(4,4,B4:B$7)"]
["Orange",48,{"$f":"_xlfn.AGGREGATE(4,4,B5:B$7)","v":85}," =AGGREGATE(4,4,B5:B$7)"]
["Grapes",85,{"$f":"_xlfn.AGGREGATE(4,4,B6:B$7)","v":85}," =AGGREGATE(4,4,B6:B$7)"]
["PineApple",36,{"$f":"_xlfn.AGGREGATE(4,4,B7:B$7)","v":36}," =AGGREGATE(4,4,B7:B$7)"]
[]
[]
[]
[]
[null,null,null,"Math & Trig Function"]

{"sheet":"Aggregate_MIN","index":8,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Aggregate Function - MIN",null,null,null,null,null,null,null,null,"Return To Index"]
["Data","Price","Result","Formula"]
["Apple",55,{"$f":"_xlfn.AGGREGATE(5,4,B3:B$7)","v":18}," =AGGREGATE(5,4,B3:B$7)"]
["Banana",18,{"$f":"_xlfn.AGGREGATE(5,4,B4:B$7)","v":18}," =AGGREGATE(5,4,B4:B$7)"]
["Orange",25,{"$f":"_xlfn.AGGREGATE(5,4,B5:B$7)","v":25}," =AGGREGATE(5,4,B5:B$7)"]
["Grapes",85,{"$f":"_xlfn.AGGREGATE(5,4,B6:B$7)","v":36}," =AGGREGATE(5,4,B6:B$7)"]
["PineApple",36,{"$f":"_xlfn.AGGREGATE(5,4,B7:B$7)","v":36}," =AGGREGATE(5,4,B7:B$7)"]
[]
[]
[]
[]
[null,null,null,"Math & Trig Function"]

{"sheet":"And_Operator","index":9,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["AND Operator",null,null,null,null,null,null,null,null,"Return To Index"]
["Number","Result","Formula"]
[15,{"$f":"AND(A3>11,A3<18)","v":true}," =AND(A3>11,A3<18)"]
[20,false," =AND(A4>11,A4<18)"]
[16,true," =AND(A5>11,A5<18)"]
[20,false," =AND(A6>11,A6<18)"]
[18,false," =AND(A7>11,A7<18)"]

{"sheet":"Average","index":10,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Average Function",null,null,null,null,null,null,null,null,"Return To Index"]
["Data","Average","Formula"]
[55,{"$f":"AVERAGE(A3:A$9)","v":55.857142857142854}," =AVERAGE(A3:A$9)"]
[45,{"$f":"AVERAGE(A4:A$9)","v":56}," =AVERAGE(A4:A$9)"]
[36,{"$f":"AVERAGE(A5:A$9)","v":58.2}," =AVERAGE(A5:A$9)"]
[78,{"$f":"AVERAGE(A6:A$9)","v":63.75}," =AVERAGE(A6:A$9)"]
[55,{"$f":"AVERAGE(A7:A$9)","v":59}," =AVERAGE(A7:A$9)"]
[78,{"$f":"AVERAGE(A8:A$9)","v":61}," =AVERAGE(A8:A$9)"]
[44,{"$f":"AVERAGE(A9:A$9)","v":44}," =AVERAGE(A9:A$9)"]

{"sheet":"Cal_Price_Rng_Using_IndexMatch","index":11,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":false,"merged":[[7,3,12,4],[1,4,1,5]]}
["Qty","Fruit","Price",null,null,null,null,null,null,"Return To Index"]
[1100,"Apple",100,null,"Enter the Approx Number"]
[1101,"Banana",200,null,350]
[1102,"Grapes",300]
[1103,"Papaya",400,null,{"$f":"INDEX(B2:B8,MATCH(E3,C2:C8,1))","v":"Grapes"}]
[1104,"PineApple",500," =INDEX(B2:B8,MATCH(E3,C2:C8,1))"]
[1105,"PromeGranete",600]
[1106,"BlackBerries",700,"Based on number\n mentioned in E3, \nwe can retrieve \nthe Fruit name"]

{"sheet":"Cell_Function_info_type_address","index":12,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Cell Function - Info_type = address",null,null,null,null,null,null,null,null,"Return To Index"]
["Data","Result","Formula"]
["Apple",{"$f":"CELL(\"address\",A3)","v":"$A$3"}," =CELL(\"address\",A3)"]
["Banana",{"$f":"CELL(\"address\",A4)","v":"$A$4"}," =CELL(\"address\",A4)"]
["Orange","$A$5"," =CELL(\"address\",A5)"]
["Grapes","$A$6"," =CELL(\"address\",A6)"]
["PineApple","$A$7"," =CELL(\"address\",A7)"]
[]
[]
[]
[]
[null,null,null,"Information Function Liabrary"]

{"sheet":"Cell_Function_info_type_content","index":13,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Cell Function - Info_type = contents",null,null,null,null,null,null,null,null,"Return To Index"]
["Data","Result","Formula"]
["Apple",{"$f":"CELL(\"contents\",A3)","v":"Apple"}," =CELL(\"contents\",A3)"," "]
["Banana",{"$f":"CELL(\"contents\",A4)","v":"Banana"}," =CELL(\"contents\",A4)"]
["Orange","Orange"," =CELL(\"contents\",A5)"]
["Grapes","Grapes"," =CELL(\"contents\",A6)"]
["PineApple","PineApple"," =CELL(\"contents\",A7)"]
[]
[]
[]
[]
[null,null,null,"Information Function Liabrary"]

{"sheet":"Cell_Function_info_type_filenam","index":14,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Cell Function - Info_type = filename",null,null,null,null,null,null,null,null,"Return To Index"]
["Data","Result","Formula"]
["Apple",{"$f":"CELL(\"filename\",A3)","v":"C:\\Users\\PavanKumar\\Desktop\\Testing\\[Excel_Functions.xlsm]Cell_Function_info_type_filenam"}," =CELL(\"filename\",A3)"]
["Banana",{"$f":"CELL(\"filename\",A4)","v":"C:\\Users\\PavanKumar\\Desktop\\Testing\\[Excel_Functions.xlsm]Cell_Function_info_type_filenam"}," =CELL(\"filename\",A4)"]
["Orange","C:\\Users\\PavanKumar\\Desktop\\Testing\\[Excel_Functions.xlsm]Cell_Function_info_type_filenam"," =CELL(\"filename\",A5)"]
["Grapes","C:\\Users\\PavanKumar\\Desktop\\Testing\\[Excel_Functions.xlsm]Cell_Function_info_type_filenam"," =CELL(\"filename\",A6)"]
["PineApple","C:\\Users\\PavanKumar\\Desktop\\Testing\\[Excel_Functions.xlsm]Cell_Function_info_type_filenam"," =CELL(\"filename\",A7)"]
[]
[]
[]
[]
[null,null,null,"Information Function Liabrary"]

{"sheet":"Cell_Function_infotype_col","index":15,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Cell Function - Info_type = col",null,null,null,null,null,null,null,null,"Return To Index"]
["Data","Result","Formula"]
["Apple",{"$f":"CELL(\"col\",A3)","v":1}," =CELL(\"col\",A3)"]
["Banana",{"$f":"CELL(\"col\",A4)","v":1}," =CELL(\"col\",A4)"]
["Orange",1," =CELL(\"col\",A5)"]
["Grapes",1," =CELL(\"col\",A6)"]
["PineApple",1," =CELL(\"col\",A7)"]
[]
[]
[]
[]
[null,null,null,"Information Function Liabrary"]

{"sheet":"Cell_Function_infotype_Row","index":16,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Cell Function - Info_type = row",null,null,null,null,null,null,null,null,"Return To Index"]
["Data","Result","Formula"]
["Apple",{"$f":"CELL(\"row\",A3)","v":3}," =CELL(\"row\",A3)"]
["Banana",{"$f":"CELL(\"row\",A4)","v":4}," =CELL(\"row\",A4)"]
["Orange",5," =CELL(\"row\",A5)"]
["Grapes",6," =CELL(\"row\",A6)"]
["PineApple",7," =CELL(\"row\",A7)"]
[]
[]
[]
[]
[null,null,null,"Information Function Liabrary"]

{"sheet":"Cell_Function_Infotype_type","index":17,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Cell Function - Info_type = row",null,null,null,null,null,null,null,null,"Return To Index"]
["Data","Result","Formula"]
["Apple",{"$f":"CELL(\"type\",A3)","v":"l"}," =CELL(\"type\",A3)"]
[45,{"$f":"CELL(\"type\",A4)","v":"v"}," =CELL(\"type\",A4)"]
[0.5,"v"," =CELL(\"type\",A5)"]
[{"$f":"A4+A5","v":45.5},"v"," =CELL(\"type\",A6)"]
["PineApple","l"," =CELL(\"type\",A7)"]
[]
[]
[]
[]
[null,null,null,"Information Function Liabrary"]

{"sheet":"Cell_Function_infotype_width","index":18,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Cell Function - Info_type = width",null,null,null,null,null,null,null,null,"Return To Index"]
["Data","Result","Formula"]
["Apple",{"$f":"CELL(\"width\",A3)","v":15}," =CELL(\"width\",A3)"]
["Banana",{"$f":"CELL(\"width\",A4)","v":15}," =CELL(\"width\",A4)"]
["Orange",15," =CELL(\"width\",A5)"]
["Grapes",15," =CELL(\"width\",A6)"]
["PineApple",15," =CELL(\"width\",A7)"]
[]
[]
[]
[]
[null,null,null,"Information Function Liabrary"]

{"sheet":"Choose","index":19,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Choose Function",null,null,null,null,null,null,null,null,"Return To Index"]
["Fruit","Result","Formula"]
["Apple",{"$f":"CHOOSE(3,$A$3,$A$4,$A$5,$A$6,$A$7)","v":"Orange"}," =CHOOSE(3,$A$3,$A$4,$A$5,$A$6,$A$7)"]
["Banana",{"$f":"CHOOSE(4,$A$3,$A$4,$A$5,$A$6,$A$7)","v":"Grapes"}," =CHOOSE(4,$A$3,$A$4,$A$5,$A$6,$A$7)"]
["Orange",{"$f":"CHOOSE(5,$A$3,$A$4,$A$5,$A$6,$A$7)","v":"PineApple"}," =CHOOSE(5,$A$3,$A$4,$A$5,$A$6,$A$7)"]
["Grapes",{"$f":"CHOOSE(1,$A$3,$A$4,$A$5,$A$6,$A$7)","v":"Apple"}," =CHOOSE(1,$A$3,$A$4,$A$5,$A$6,$A$7)"]
["PineApple",{"$f":"CHOOSE(2,$A$3,$A$4,$A$5,$A$6,$A$7)","v":"Banana"}," =CHOOSE(2,$A$3,$A$4,$A$5,$A$6,$A$7)"]

{"sheet":"Column","index":20,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Reference Provided","Reference Omitted",null,null,null,null,null,null,null,"Return To Index"]
[null,{"$f":"COLUMN()","v":2},{"$f":"COLUMN()","v":3},{"$f":"COLUMN()","v":4},{"$f":"COLUMN()","v":5},{"$f":"COLUMN()","v":6},{"$f":"COLUMN()","v":7},{"$f":"COLUMN()","v":8},{"$f":"COLUMN()","v":9},{"$f":"COLUMN()","v":10},{"$f":"COLUMN()","v":11},{"$f":"COLUMN()","v":12},{"$f":"COLUMN()","v":13}]
[{"$f":"COLUMN(G5)","v":7},{"$f":"COLUMN()","v":2}," =COLUMN()"," =COLUMN()"," =COLUMN()"," =COLUMN()"," =COLUMN()"," =COLUMN()"," =COLUMN()"," =COLUMN()"," =COLUMN()"," =COLUMN()"," =COLUMN()"]
[null,{"$f":"COLUMN()","v":2}]
[{"$f":"COLUMN(M3)","v":13},{"$f":"COLUMN()","v":2}]
[null,{"$f":"COLUMN()","v":2}]
[null,{"$f":"COLUMN()","v":2}]
[null,{"$f":"COLUMN()","v":2}]
[null,{"$f":"COLUMN()","v":2}]
[null,{"$f":"COLUMN()","v":2}]
[null,{"$f":"COLUMN()","v":2}]
[null,{"$f":"COLUMN()","v":2}]
[null,{"$f":"COLUMN()","v":2}]
[null,{"$f":"COLUMN()","v":2}]

{"sheet":"Compare_Two_Lists_Only_In_First","index":21,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Compare Two Lists - Data Exists in First Not In Second",null,null,null,null,null,null,null,null,"Return To Index"]
["First List","Second List","Result","Formula"]
["Apple","Pen",{"$f":"VLOOKUP(A3,$B$3:$B$7,1,0)","v":"Apple"}," =VLOOKUP(A3,$B$3:$B$7,1,0)"]
["Banana","Pencil",{"$f":"VLOOKUP(A4,$B$3:$B$7,1,0)","v":{"$error":"#N/A"}}," =VLOOKUP(A4,$B$3:$B$7,1,0)"]
["Orange","Orange","Orange"," =VLOOKUP(A5,$B$3:$B$7,1,0)"]
["Grapes","Apple",{"$error":"#N/A"}," =VLOOKUP(A6,$B$3:$B$7,1,0)"]
["Papaya","Eraser",{"$error":"#N/A"}," =VLOOKUP(A7,$B$3:$B$7,1,0)"]
[]
[]
[null,null,null," "]

{"sheet":"Compare_Two_Lists_Only_In_Secnd","index":22,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Compare Two Lists - Data Exists in Second Not In First",null,null,null,null,null,null,null,null,"Return To Index"]
["First List","Second List","Result","Formula"]
["Apple","Pen",{"$f":"VLOOKUP(B3,$A$3:$A$6,1,0)","v":{"$error":"#N/A"}}," =VLOOKUP(B3,$A$3:$A$6,1,0)"]
["Banana","Pencil",{"$f":"VLOOKUP(B4,$A$3:$A$6,1,0)","v":{"$error":"#N/A"}}," =VLOOKUP(B4,$A$3:$A$6,1,0)"]
["Orange","Orange","Orange"," =VLOOKUP(B5,$A$3:$A$6,1,0)"]
["Grapes","Apple","Apple"," =VLOOKUP(B6,$A$3:$A$6,1,0)"]
["Papaya","Eraser",{"$error":"#N/A"}," =VLOOKUP(B7,$A$3:$A$6,1,0)"]

{"sheet":"Concatenate","index":23,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,1,4]]}
["Concatenate function",null,null,null,null,null,null,null,null,"Return To Index"]
[]
["S.No","Text 1","Text 2","Result","Formula"]
["1)","One","Two",{"$f":"CONCATENATE(\"one\",\"two\")","v":"onetwo"}," =CONCATENATE(\"one\",\"two\")"]
["2)","One","Two",{"$f":"CONCATENATE(\"one\",\" \",\"two\")","v":"one two"}," =CONCATENATE(\"one\",\" \",\"two\")"]
["3)","One","Two",{"$f":"CONCATENATE(\"one\",\"   \",\"two\")","v":"one   two"}," =CONCATENATE(\"one\",\"   \",\"two\")"]
[]
[]
["In the first example: No space between the texts"]
["In the Second example: Single space, space should mention in QUOTES"]
["In the Third example: Three spaces, space should mention in QUOTES"]

{"sheet":"Concatenate_With_Cell_Reference","index":24,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,5,1,6]]}
[null,null,null,null,null,null,null,null,null,"Return To Index"]
[null,null,null,null,null,"Required Data"]
["Name","Job","Location","Salary",null,"Name","E"]
["A","Software","Hyderabad",40000]
["B","Hardware","Pune",{"$f":"D4+15245","v":55245}]
["C","Mechanic","Chennai",25000]
["D","Doctor","Delhi",{"$f":"D6+15245","v":40245},null,"Job",{"$f":"VLOOKUP(G3,A3:D10,2,0)","v":"Teacher"}]
["E","Teacher","Surat",35242,null,"Location",{"$f":"VLOOKUP(G3,A3:D10,3,0)","v":"Surat"}]
["F","Police","Mumbai",50487,null,"Salary",{"$f":"VLOOKUP(G3,A4:D10,4,0)","v":35242}]
["G","pilot","Ahemadabad",35025]
[]
[null,null,null,null,null,null,{"$f":"CONCATENATE(G3,\" \",\"doing job of\",\" \",G7,\" \")","v":"E doing job of Teacher "}]
[null,null,null,null,null,null,{"$f":"CONCATENATE(G3,\" \",\"doing job in\",\" \",G8)","v":"E doing job in Surat"}]
[null,null,null,null,null,null,{"$f":"CONCATENATE(G3,\" \",\"earning salary \",\" \",G9)","v":"E earning salary  35242"}]

{"sheet":"Count","index":25,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Count Function",null,null,null,null,null,null,null,null,"Return To Index"]
["Data","Count","Formula"]
["Apple",{"$f":"COUNT(A3:A$9)","v":2}," =COUNT(A3:A$9)"]
["Banana",{"$f":"COUNT(A4:A$9)","v":2}," =COUNT(A4:A$9)"]
["Orange",{"$f":"COUNT(A5:A$9)","v":2}," =COUNT(A5:A$9)"]
[33,{"$f":"COUNT(A6:A$9)","v":2}," =COUNT(A6:A$9)"]
["PineApple",{"$f":"COUNT(A7:A$9)","v":1}," =COUNT(A7:A$9)"]
["Papaya",{"$f":"COUNT(A8:A$9)","v":1}," =COUNT(A8:A$9)"]
[65,{"$f":"COUNT(A9:A$9)","v":1}," =COUNT(A9:A$9)"]

{"sheet":"Count_Blank_Cells_Using_CountIF","index":26,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Count Blank Cells",null,null,null,null,null,null,null,null,"Return To Index"]
["Data","Result","Formula"]
[55,{"$f":"COUNTIF(A3:A$7,\"=\"&\"\")","v":2}," =COUNTIF(A3:A$7,\"=\"&\"\")"]
[null,{"$f":"COUNTIF(A4:A$7,\"=\"&\"\")","v":2}," =COUNTIF(A4:A$7,\"=\"&\"\")"]
["Apple",{"$f":"COUNTIF(A5:A$7,\"=\"&\"\")","v":1}," =COUNTIF(A5:A$7,\"=\"&\"\")"]
[null,{"$f":"COUNTIF(A6:A$7,\"=\"&\"\")","v":1}," =COUNTIF(A6:A$7,\"=\"&\"\")"]
["Orange",{"$f":"COUNTIF(A7:A$7,\"=\"&\"\")","v":0}," =COUNTIF(A7:A$7,\"=\"&\"\")"]

{"sheet":"Count_NonTextCells_UsingCountIF","index":27,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Count Non TEXT Cells Using COUNTIF Function",null,null,null,null,null,null,null,null,"Return To Index"]
["Data","Result","Formula"]
[55,{"$f":"COUNTIF(A3:A$7,\"<>\" & \"*\")","v":2}," =COUNTIF(A3:A$7,\"<>\" & \"*\")"]
["Grapes",{"$f":"COUNTIF(A4:A$7,\"<>\" & \"*\")","v":1}," =COUNTIF(A4:A$7,\"<>\" & \"*\")"]
["Apple",{"$f":"COUNTIF(A5:A$7,\"<>\" & \"*\")","v":1}," =COUNTIF(A5:A$7,\"<>\" & \"*\")"]
[150,{"$f":"COUNTIF(A6:A$7,\"<>\" & \"*\")","v":1}," =COUNTIF(A6:A$7,\"<>\" & \"*\")"]
["Orange",{"$f":"COUNTIF(A7:A$7,\"<>\" & \"*\")","v":0}," =COUNTIF(A7:A$7,\"<>\" & \"*\")"]

{"sheet":"CountA","index":28,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["CountA  Function",null,null,null,null,null,null,null,null,"Return To Index"]
["Data","Result","Formula"]
[55,{"$f":"COUNTA(A3:A$7)","v":5}," =COUNTA(A3:A$7)"]
["Grapes",{"$f":"COUNTA(A4:A$7)","v":4}," =COUNTA(A4:A$7)"]
["Apple",{"$f":"COUNTA(A5:A$7)","v":3}," =COUNTA(A5:A$7)"]
["2021-01-28",{"$f":"COUNTA(A6:A$7)","v":2}," =COUNTA(A6:A$7)"]
["Orange",{"$f":"COUNTA(A7:A$7)","v":1}," =COUNTA(A7:A$7)"]

{"sheet":"CountIF","index":29,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["CountIF Function",null,null,null,null,null,null,null,null,"Return To Index"]
["Data","Result","Formula"]
["Apple",{"$f":"COUNTIF($A3:$A$7,A3)","v":2}," =COUNTIF($A3:$A$7,A3)"]
["Orange",{"$f":"COUNTIF($A4:$A$7,A4)","v":2}," =COUNTIF($A4:$A$7,A4)"]
["Grapes",{"$f":"COUNTIF($A5:$A$7,A5)","v":1}," =COUNTIF($A5:$A$7,A5)"]
["Apple",{"$f":"COUNTIF($A6:$A$7,A6)","v":1}," =COUNTIF($A6:$A$7,A6)"]
["Orange",{"$f":"COUNTIF($A7:$A$7,A7)","v":1}," =COUNTIF($A7:$A$7,A7)"]

{"sheet":"CountIF_FourthChar_As_L","index":30,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["CountIF Function - 4th Character as L",null,null,null,null,null,null,null,null,"Return To Index"]
["Data","Result","Formula"]
["Apple",{"$f":"COUNTIF(A3:$A$7,\"???l*\")","v":3}," =COUNTIF(A3:$A$7,\"???l*\")"]
["App",{"$f":"COUNTIF(A4:$A$7,\"???l*\")","v":2}," =COUNTIF(A4:$A$7,\"???l*\")"]
["Apple",{"$f":"COUNTIF(A5:$A$7,\"???l*\")","v":2}," =COUNTIF(A5:$A$7,\"???l*\")"]
["Aplep",{"$f":"COUNTIF(A6:$A$7,\"???l*\")","v":1}," =COUNTIF(A6:$A$7,\"???l*\")"]
["Apple",{"$f":"COUNTIF(A7:$A$7,\"???l*\")","v":1}," =COUNTIF(A7:$A$7,\"???l*\")"]

{"sheet":"CountIF_Function_With_Dates","index":31,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["CountIF Function with Dates",null,null,null,null,null,null,null,null,"Return To Index"]
["Dates","Result","Formula"]
["2021-01-20",{"$f":"COUNTIF(OFFSET(A$3,0,0,COUNTA(A:A),1),A3)","v":3}," =COUNTIF(OFFSET(A$3,0,0,COUNTA(A:A),1),A3)"]
["2021-01-21",{"$f":"COUNTIF(OFFSET(A$3,0,0,COUNTA(A:A),1),\">=1/21/2021\")","v":2}," =COUNTIF(OFFSET(A$3,0,0,COUNTA(A:A),1),\">=1/21/2021\")"]
["2021-01-20",{"$f":"COUNTIF(OFFSET(A$3,0,0,COUNTA(A:A),1),\"=1/20/2021\")","v":3}," =COUNTIF(OFFSET(A$3,0,0,COUNTA(A:A),1),\"=1/20/2021\")"]
["2021-01-23",{"$f":"COUNTIF(OFFSET(A$3,0,0,COUNTA(A:A),1),A6)","v":1}," =COUNTIF(OFFSET(A$3,0,0,COUNTA(A:A),1),A6)"]
["2021-01-20",3," =COUNTIF(OFFSET(A$3,0,0,COUNTA(A:A),1),A7)"]

{"sheet":"CountIF_PartialMatch_WildCard","index":32,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["CountIF Function - Partial Match Using WildCard",null,null,null,null,null,null,null,null,"Return To Index"]
["Data","Result","Formula"]
["Apple",{"$f":"COUNTIF(A3:$A$7,\"*pp*\")","v":3}," =COUNTIF(A3:$A$7,\"*pp*\")"]
["Banana",{"$f":"COUNTIF(A4:$A$7,\"*pp*\")","v":2}," =COUNTIF(A4:$A$7,\"*pp*\")"]
["Apple",{"$f":"COUNTIF(A5:$A$7,\"*pp*\")","v":2}," =COUNTIF(A5:$A$7,\"*pp*\")"]
["Grapes",{"$f":"COUNTIF(A6:$A$7,\"*pp*\")","v":1}," =COUNTIF(A6:$A$7,\"*pp*\")"]
["PineApple",{"$f":"COUNTIF(A7:$A$7,\"*pp*\")","v":1}," =COUNTIF(A7:$A$7,\"*pp*\")"]

{"sheet":"CountIf_Sum_Multiple_Criterias","index":33,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["CountIf  Function - Sum of  Multiple Criterias",null,null,null,null,null,null,null,null,"Return To Index"]
["Data","Result","Formula"]
["Milk",{"$f":"COUNTIF(A$1:A$10,A3) + COUNTIF(A$1:A$10,A4)","v":4}," =COUNTIF(A$1:A$10,A3) + COUNTIF(A$1:A$10,A4"]
["Pens",{"$f":"COUNTIF(A$1:A$10,A4) + COUNTIF(A$1:A$10,A5)","v":4}," =COUNTIF(A$1:A$10,A4) + COUNTIF(A$1:A$10,A5)"]
["Butter",3," =COUNTIF(A$1:A$10,A5) + COUNTIF(A$1:A$10,A6)"]
["Pencils",3," =COUNTIF(A$1:A$10,A6) + COUNTIF(A$1:A$10,A7)"]
["Pens",{"$f":"COUNTIF(A$1:A$10,\"Pens\") + COUNTIF(A$1:A$10,\"Milk\")","v":4}," =COUNTIF(A$1:A$10,\"Pens\") + COUNTIF(A$1:A$10,\"Milk\")"]
["Milk",3," =COUNTIF(A$1:A$10,A8) + COUNTIF(A$1:A$10,A9)"]
["Curd",3," =COUNTIF(A$1:A$10,A9) + COUNTIF(A$1:A$10,A10)"]
["Butter",{"$f":"COUNTIF(A$1:A$10,A10) + COUNTIF(A$1:A$10,A3)","v":4}," =COUNTIF(A$1:A$10,A10) + COUNTIF(A$1:A$10,A3)"]

{"sheet":"CountIF_with_Conditional_Format","index":34,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["CountIF with Conditional Formatting",null,null,null,null,null,null,null,null,"Return To Index"]
["Fruits"]
["Apple",null,null,null,"Apple"]
["Banana",null,null,null,{"$f":"COUNTIF($A$3:$A$7,E3)","v":3}]
["Apple"]
["Grapes",null,null," =COUNTIF($A$3:$A$7,E3)"]
["Apple"]

{"sheet":"CountIf_With_Single_Criteria","index":35,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["CountIf  Function with Single Criteria",null,null,null,null,null,null,null,null,"Return To Index"]
["Data","Result","Formula"]
["Milk",{"$f":"COUNTIF(A$1:A$10,A3)","v":2}," =COUNTIF(A$1:A$10,A3)"]
["Pens",{"$f":"COUNTIF(A$1:A$10,A4)","v":2}," =COUNTIF(A$1:A$10,A4)"]
["Butter",2," =COUNTIF(A$1:A$10,A5)"]
["Pencils",1," =COUNTIF(A$1:A$10,A6)"]
["Pens",2," =COUNTIF(A$1:A$10,\"Pens\")"]
["Milk",2," =COUNTIF(A$1:A$10,A8)"]
["Curd",1," =COUNTIF(A$1:A$10,A9)"]
["Butter",2," =COUNTIF(A$1:A$10,\"Butter\")"]

{"sheet":"CountIfOnDynamicRng UsingOffset","index":36,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["CountIF Function on Dynamic Range using OFFSET ",null,null,null,null,null,null,null,null,"Return To Index"]
["Fruits","Result","Formula"]
["Apple",{"$f":"COUNTIF(OFFSET(A$3,0,0,COUNTA(A:A),1),A3)","v":3}," =COUNTIF(OFFSET(A$3,0,0,COUNTA(A:A),1),A3)"]
["Banana",{"$f":"COUNTIF(OFFSET(A$3,0,0,COUNTA(A:A),1),A4)","v":1}," =COUNTIF(OFFSET(A$3,0,0,COUNTA(A:A),1),A4)"]
["Apple",3," =COUNTIF(OFFSET(A$3,0,0,COUNTA(A:A),1),A5)"]
["Grapes",1," =COUNTIF(OFFSET(A$3,0,0,COUNTA(A:A),1),A6)"]
["Apple",3," =COUNTIF(OFFSET(A$3,0,0,COUNTA(A:A),1),A7)"]

{"sheet":"CountNonBlankCellsUsing_CountIF","index":37,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Count Non Blank Cells",null,null,null,null,null,null,null,null,"Return To Index"]
["Data","Result","Formula"]
[55,{"$f":"COUNTIF(A3:A$7,\"<>\"&\"\")","v":3}," =COUNTIF(A3:A$7,\"<>\"&\"\")"]
[null,{"$f":"COUNTIF(A4:A$7,\"<>\"&\"\")","v":2}," =COUNTIF(A4:A$7,\"<>\"&\"\")"]
["Apple",{"$f":"COUNTIF(A5:A$7,\"<>\"&\"\")","v":2}," =COUNTIF(A5:A$7,\"<>\"&\"\")"]
[null,{"$f":"COUNTIF(A6:A$7,\"<>\"&\"\")","v":1}," =COUNTIF(A6:A$7,\"<>\"&\"\")"]
["Orange",{"$f":"COUNTIF(A7:A$7,\"<>\"&\"\")","v":1},"  =COUNTIF(A7:A$7,\"<>\"&\"\")"]

{"sheet":"Date","index":38,"n_rows":5,"n_cols":10,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Date Function",null,null,null,null,null,null,null,null,"Return To Index"]
["Year","Month","Day","Date","Formula"]
[2021,1,20,{"$f":"DATE(A3,B3,C3)","v":"2021-01-20"}," =DATE(A3,B3,C3)"]
[1978,1,27,{"$f":"DATE(A4,B4,C4)","v":"1978-01-27"}," =DATE(A4,B4,C4)"]
[2021,1,25,{"$f":"DATE(A5,B5,C5)","v":"2021-01-25"}," =DATE(A5,B5,C5)"]

{"sheet":"Day","index":39,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Day Function",null,null,null,null,null,null,null,null,"Return To Index"]
["Date","Day Function Result","Formula"]
["2021-01-20",{"$f":"DAY(A3)","v":20}," =DAY(A3)"]
["2020-01-11",{"$f":"DAY(A4)","v":11}," =DAY(A4)"]
["2021-01-27",27," =DAY(A5)"]
["2021-05-22",22," =DAY(A6)"]
["2021-04-28",28," =DAY(A7)"]

{"sheet":"Days360","index":40,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,0,1,3]]}
["Days360 Function",null,null,null,null,null,null,null,null,"Return To Index"]
[]
["Start Date","End Date","Date Diff","Formula"]
["2020-01-25","2021-01-25",{"$f":"DAYS360(A4,B4)","v":360}," =DAYS360(A4,B4)"]
["2019-01-25","2021-01-25",{"$f":"DAYS360(A5,B5,FALSE)","v":720}," =DAYS360(A5,B5,FALSE)"]
["2019-01-25","2021-01-25",{"$f":"DAYS360(A6,B6,TRUE )","v":720}," =DAYS360(A6,B6,TRUE )"]
["2015-01-25","2020-01-25",{"$f":"DAYS360(A7,B7,FALSE )","v":1800}," =DAYS360(A7,B7,FALSE )"]
["2012-01-25","2019-01-25",{"$f":"DAYS360(A8,B8,TRUE)","v":2520}," =DAYS360(A8,B8,TRUE)"]

{"sheet":"Double_VLookup","index":41,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Item","Price",null,null,"Original","Code",null,null,"Double Vlookup","Return To Index"]
["A",35,null,null,"Apple","A",null,null,{"$f":"VLOOKUP(VLOOKUP(E2,$E$2:$F$6,2,0),$A$1:$B$6,2,0)","v":35}," =VLOOKUP(VLOOKUP(E2,$E$2:$F$6,2,0),$A$1:$B$6,2,0)"]
["B",36,null,null,"Banana","B",null,null,{"$f":"VLOOKUP(VLOOKUP(E3,$E$2:$F$6,2,0),$A$1:$B$6,2,0)","v":36}," =VLOOKUP(VLOOKUP(E3,$E$2:$F$6,2,0),$A$1:$B$6,2,0)"]
["C",68,null,null,"Carrot","C",null,null,68," =VLOOKUP(VLOOKUP(E4,$E$2:$F$6,2,0),$A$1:$B$6,2,0)"]
["D",45,null,null,"Dog","D",null,null,45," =VLOOKUP(VLOOKUP(E5,$E$2:$F$6,2,0),$A$1:$B$6,2,0)"]
["E",55,null,null,"Elephant","E",null,null,55," =VLOOKUP(VLOOKUP(E6,$E$2:$F$6,2,0),$A$1:$B$6,2,0)"]
[]
[]
[]
[]
[]
[null,null,null,"Lookup & Reference Function"]
[]
[]
[null,null,null,null,null,null,null,null," "]

{"sheet":"Even","index":42,"n_rows":6,"n_cols":10,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Data","Result","Formula",null,null,null,null,null,null,"Return To Index"]
[7,{"$f":"EVEN(A2)","v":8}," =EVEN(A2)"]
[70,{"$f":"EVEN(A3)","v":70}," =EVEN(A3)"]
[55,56," =EVEN(A4)",null,null,null,"It returns nearest Even Number if the Input number is ODD"]
[74,74," =EVEN(A5)",null,null,null,"There is no change in output if the Input number is Even Number"]
[65,66," =EVEN(A6)"]

{"sheet":"Exact","index":43,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Exact Function",null,null,null,null,null,null,null,null,"Return To Index"]
["First Text","Second Text","Results","Formula"]
["Apple","Apple",{"$f":"EXACT(A3,B3)","v":true}," =EXACT(A3,B3)"]
["Banana","banana",{"$f":"EXACT(A4,B4)","v":false}," =EXACT(A4,B4)"]
["Orange","Orange",true," =EXACT(A5,B5)"]
["Grapes",18,false," =EXACT(A6,B6)"]
["PineApple","PineApple",true," =EXACT(A7,B7)"]

{"sheet":"Filldown_Dates_5_Days_Diff","index":44,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[7,4,12,8]]}
["2016-08-05",null,null,null,null,null,null,null,null,"Return To Index"]
[{"$f":"A1-$F$3","v":"2016-07-31"}]
[{"$f":"A2-$F$3","v":"2016-07-26"},null,null,null,null,5]
["2016-07-21"]
["2016-07-16"]
["2016-07-11"]
["2016-07-06"]
["2016-07-01",null,null,null,"Dates with Gap"]
["2016-06-26"]
["2016-06-21"]
["2016-06-16"]
["2016-06-11"]
["2016-06-06"]
["2016-06-01"]
["2016-05-27"]
["2016-05-22"]

{"sheet":"Find","index":45,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Find Function",null,null,null,null,null,null,null,null,"Return To Index"]
["Date","Result","Formula"]
["Apple",{"$f":"FIND(\"l\",A3,1)","v":4}," =FIND(\"l\",A3,1)"]
["Banana",{"$f":"FIND(\"B\",A4,1)","v":1}," =FIND(\"B\",A4,1)"]
["Orange",{"$f":"FIND(\"a\",A5,1)","v":3}," =FIND(\"a\",A5,1)"]
["Grapes",{"$f":"FIND(\"p\",A6,1)","v":4}," =FIND(\"p\",A6,1)"]
["PineApple",{"$f":"FIND(\"l\",A7,1)","v":8}," =FIND(\"l\",A7,1)"]

{"sheet":"Find_Function_Extract_TextNumb","index":46,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Find Function - Extract Character Number",null,null,null,null,null,null,null,null,"Return To Index"]
["Original Text","Required Text","Position","Formula"]
["Apple","p",{"$f":"FIND(B3,A3)","v":2}," =FIND(B3,A3)"]
["Banana","n",{"$f":"FIND(B4,A4)","v":3}," =FIND(B4,A4)"]
["PineApple","A",5," =FIND(B5,A5)"]
["Orange","g",5," =FIND(B6,A6)"]
["Grapes","p",4," =FIND(B7,A7)"]

{"sheet":"Find_Function_Split_Left_Part","index":47,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Find Function: Split the text based on Space and retreve Left part ",null,null,null,null,null,null,null,null,"Return To Index"]
["Text","Find Space Position","left","Final","Formula"]
["App le",{"$f":"FIND(\" \",A3)","v":4},{"$f":"LEFT(A3,B3-1)","v":"App"},{"$f":"LEFT(A3,FIND(\" \",A3)-1)","v":"App"}," =LEFT(A3,FIND(\" \",A3)-1)"]
["Ban ana",4,"Ban","Ban"," =LEFT(A4,FIND(\" \",A4)-1)"]
["Ora nge",4,"Ora","Ora"," =LEFT(A5,FIND(\" \",A5)-1)"]
["Pen Pencil",4,"Pen","Pen"," =LEFT(A6,FIND(\" \",A6)-1)"]
["Gra pes",4,"Gra","Gra"," =LEFT(A7,FIND(\" \",A7)-1)"]
["Dosa Masala",5,"Dosa","Dosa"," =LEFT(A8,FIND(\" \",A8)-1)"]
["Fruit Salad",6,"Fruit","Fruit"," =LEFT(A9,FIND(\" \",A9)-1)"]
["Input","Step 1","Step 2","Final Step","Final Formula"]

{"sheet":"Find_Function_Split_Right_Part","index":48,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["Find Function: Split the text based on Space and retrieve Right part ",null,null,null,null,null,null,null,null,"Return To Index"]
["Text","Blank Position","Lengh","Right","Final Result","Output"]
["App le",{"$f":"FIND(\" \",A3)","v":4},{"$f":"LEN(A3)","v":6},{"$f":"RIGHT(A3,C3-B3)","v":"le"},{"$f":"RIGHT(A3, LEN(A3)-FIND(\" \",A3))","v":"le"}," =RIGHT(A3, LEN(A3)-FIND(\" \",A3))"]
["Ban ana",{"$f":"FIND(\" \",A4)","v":4},{"$f":"LEN(A4)","v":7},{"$f":"RIGHT(A4,C4-B4)","v":"ana"},{"$f":"RIGHT(A4, LEN(A4)-FIND(\" \",A4))","v":"ana"}," =RIGHT(A4, LEN(A4)-FIND(\" \",A4))"]
["Ora nge",4,7,"nge","nge"," =RIGHT(A5, LEN(A5)-FIND(\" \",A5))"]
["Pen Pencil",4,10,"Pencil","Pencil"," =RIGHT(A6, LEN(A6)-FIND(\" \",A6))"]
["Gra pes",4,7,"pes","pes"," =RIGHT(A7, LEN(A7)-FIND(\" \",A7))"]
["Dosa Masala",5,11,"Masala","Masala"," =RIGHT(A8, LEN(A8)-FIND(\" \",A8))"]
["Fruit Salad",6,11,"Salad","Salad"," =RIGHT(A9, LEN(A9)-FIND(\" \",A9))"]
[null,"Step 1","Step 2","Result","Total Formula","Total Formula"]

{"sheet":"HLookup","index":49,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Roll No",1,2,3,4,5,6,null,null,"Return To Index"]
["Class","V","V","V","V","V","V"]
["Science",70,80,40,50,65,55]
["Maths",55,65,75,65,57,35]
["Social",74,73,74,76,75,95]
["English",65,63,64,67,62,63]
[]
[]
[null,"Roll No",4,"Change the Roll Number In C9 Cell"]
[null,"Name",{"$f":"HLOOKUP(C9,$A$1:$G$6,2,0)","v":"V"}," =HLOOKUP(C9,$A$1:$G$6,2,0)"]
[null,"Science",{"$f":"HLOOKUP(C9,$A$1:$G$6,3,0)","v":50}," =HLOOKUP(C9,$A$1:$G$6,3,0)"]
[null,"Maths",{"$f":"HLOOKUP(C9,$A$1:$G$6,4,0)","v":65}," =HLOOKUP(C9,$A$1:$G$6,4,0)"]
[null,"Social",{"$f":"HLOOKUP(C9,$A$1:$G$6,5,0)","v":76}," =HLOOKUP(C9,$A$1:$G$6,5,0)"]
[null,"English",{"$f":"HLOOKUP(C9,$A$1:$G$6,6,0)","v":67}," =HLOOKUP(C9,$A$1:$G$6,6,0)"]

{"sheet":"Hour","index":50,"n_rows":2,"n_cols":10,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Starting Time","Hour","Formula",null,null,null,null,null,null,"Return To Index"]
[{"$f":"NOW()","v":"2021-02-13T11:14:08.550"},{"$f":"HOUR(A2)","v":11}," =HOUR(A2)"]

{"sheet":"Identify_Dupes_On_Multi_Columns","index":51,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,5,13,5],[14,0,15,5]]}
["Roll No","Section","Marks","Subject","Result","Formula",null,null,null,"Return To Index"]
[11,"A",85,"Science",{"$f":"IF(COUNTIFS($A$2:A2,A2,$B$2:B2,B2,$C$2:C2,C2,$D$2:D2,D2)>1,\"Duplicate\",\"Unique\")","v":"Unique"}," =IF(COUNTIFS($A$2:A2,A2,$B$2:B2,B2,$C$2:C2,\nC2,$D$2:D2,D2)>1,\"Duplicate\",\"Unique\")"]
[12,"B",45,"Social",{"$f":"IF(COUNTIFS($A$2:A3,A3,$B$2:B3,B3,$C$2:C3,C3,$D$2:D3,D3)>1,\"Duplicate\",\"Unique\")","v":"Unique"}]
[14,"J",99,"Social",{"$f":"IF(COUNTIFS($A$2:A4,A4,$B$2:B4,B4,$C$2:C4,C4,$D$2:D4,D4)>1,\"Duplicate\",\"Unique\")","v":"Unique"}]
[14,"D",65,"English",{"$f":"IF(COUNTIFS($A$2:A5,A5,$B$2:B5,B5,$C$2:C5,C5,$D$2:D5,D5)>1,\"Duplicate\",\"Unique\")","v":"Unique"}]
[15,"E",84,"Science",{"$f":"IF(COUNTIFS($A$2:A6,A6,$B$2:B6,B6,$C$2:C6,C6,$D$2:D6,D6)>1,\"Duplicate\",\"Unique\")","v":"Unique"}]
[16,"F",48,"Social",{"$f":"IF(COUNTIFS($A$2:A7,A7,$B$2:B7,B7,$C$2:C7,C7,$D$2:D7,D7)>1,\"Duplicate\",\"Unique\")","v":"Unique"}]
[11,"A",85,"Science",{"$f":"IF(COUNTIFS($A$2:A8,A8,$B$2:B8,B8,$C$2:C8,C8,$D$2:D8,D8)>1,\"Duplicate\",\"Unique\")","v":"Duplicate"}]
[12,"B",49,"English",{"$f":"IF(COUNTIFS($A$2:A9,A9,$B$2:B9,B9,$C$2:C9,C9,$D$2:D9,D9)>1,\"Duplicate\",\"Unique\")","v":"Unique"}]
[13,"I",25,"Science",{"$f":"IF(COUNTIFS($A$2:A10,A10,$B$2:B10,B10,$C$2:C10,C10,$D$2:D10,D10)>1,\"Duplicate\",\"Unique\")","v":"Unique"}]
[14,"J",99,"Social",{"$f":"IF(COUNTIFS($A$2:A11,A11,$B$2:B11,B11,$C$2:C11,C11,$D$2:D11,D11)>1,\"Duplicate\",\"Unique\")","v":"Duplicate"}]
[15,"K",100,"Maths",{"$f":"IF(COUNTIFS($A$2:A12,A12,$B$2:B12,B12,$C$2:C12,C12,$D$2:D12,D12)>1,\"Duplicate\",\"Unique\")","v":"Unique"}]
[12,"B",45,"Social",{"$f":"IF(COUNTIFS($A$2:A13,A13,$B$2:B13,B13,$C$2:C13,C13,$D$2:D13,D13)>1,\"Duplicate\",\"Unique\")","v":"Duplicate"}]
[12,"B",48,"English",{"$f":"IF(COUNTIFS($A$2:A14,A14,$B$2:B14,B14,$C$2:C14,C14,$D$2:D14,D14)>1,\"Duplicate\",\"Unique\")","v":"Unique"}]
["Identify Dupes on Multiple columns"]

{"sheet":"IF_Condition_Assign_Grades","index":52,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Student","Price","Grade","Formula",null,null,null,null,null,"Return To Index"]
["Apple",120,{"$f":"IF(B2>150,\"A\",\"B\")","v":"B"}," =IF(B2>150,\"A\",\"B\")"]
["Banana",130,{"$f":"IF(B3>150,\"A\",\"B\")","v":"B"}," =IF(B3>150,\"A\",\"B\")"]
["Orange",160,{"$f":"IF(B4>150,\"A\",\"B\")","v":"A"}," =IF(B4>150,\"A\",\"B\")"]
["Grapes",140,{"$f":"IF(B5>150,\"A\",\"B\")","v":"B"}," =IF(B5>150,\"A\",\"B\")"]
["PineApple",170,{"$f":"IF(B6>150,\"A\",\"B\")","v":"A"}," =IF(B6>150,\"A\",\"B\")"]
[]
["If the Price is Greater than 150 assign A Grade else B Grade"]

{"sheet":"If_Condition_Pass_Or_Fail","index":53,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Student","Marks","Result","Formula",null,null,null,null,null,"Return To Index"]
["Apple",100,{"$f":"IF(B2>=35,\"Pass\",\"Fail\")","v":"Pass"}," =IF(B2>=35,\"Pass\",\"Fail\")"]
["Banana",34,"Fail"," =IF(B3>=35,\"Pass\",\"Fail\")"]
["Orange",25,"Fail"," =IF(B4>=35,\"Pass\",\"Fail\")"]
["Grapes",70,"Pass"," =IF(B5>=35,\"Pass\",\"Fail\")"]
["PineApple",80,"Pass"," =IF(B6>=35,\"Pass\",\"Fail\")"]
["Papaya",40,"Pass"," =IF(B7>=35,\"Pass\",\"Fail\")"]
[]
["By using IF function we can conclude \"Pass\" or \"Fail\" students."]
["Student who secures more than 35 marks falls under the category of PASS else FAIL"]

{"sheet":"IF_Condition_Using_Min_And_Max","index":54,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Item","Price","Top Price","Lowest Price",null,null,null,null,null,"Return To Index"]
["Apple",25,{"$f":"IF(B2=MAX($B$2:$B$9),\"First\",\"\")","v":""},{"$f":"IF(B2=MIN($B$2:$B$9),\"Last\",\"\")","v":""}]
["Banana",36,{"$f":"IF(B3=MAX($B$2:$B$9),\"First\",\"\")","v":""},{"$f":"IF(B3=MIN($B$2:$B$9),\"Last\",\"\")","v":""}]
["Orange",15,"","Last"]
["Papaya",48,"",""]
["Grapes",75,"",""]
["Eraser",92,"First",""]
["Key",35,"",""]
["Lock",24,"",""]
["Identify Min and Max Prices of the Items"]
[" =IF(B2=MAX($B$2:$B$9),\"First\",\"\")"]
[" =IF(B2=MIN($B$2:$B$9),\"Last\",\"\")"]

{"sheet":"IF_Function_With_And_Operator","index":55,"n_rows":6,"n_cols":10,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Student","English","Maths","Result","Formula",null,null,null,null,"Return To Index"]
["Manoj",45,35,{"$f":"IF(AND(B2>=35,C2>=35),\"PASS\",\"FAIL\")","v":"PASS"}," =IF(AND(B2>=35,C2>=35),\"PASS\",\"FAIL\")"]
["Sri",25,45,{"$f":"IF(AND(B3>=35,C3>=35),\"PASS\",\"FAIL\")","v":"FAIL"}," =IF(AND(B3>=35,C3>=35),\"PASS\",\"FAIL\")"]
["Roopa",35,15,{"$f":"IF(AND(B4>=35,C4>=35),\"PASS\",\"FAIL\")","v":"FAIL"}," =IF(AND(B4>=35,C4>=35),\"PASS\",\"FAIL\")"]
["Rekha",45,35,{"$f":"IF(AND(B5>=35,C5>=35),\"PASS\",\"FAIL\")","v":"PASS"}," =IF(AND(B5>=35,C5>=35),\"PASS\",\"FAIL\")"]
["Sindhur",35,35,{"$f":"IF(AND(B6>=35,C6>=35),\"PASS\",\"FAIL\")","v":"PASS"}," =IF(AND(B6>=35,C6>=35),\"PASS\",\"FAIL\")"]

{"sheet":"Index","index":56,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[7,5,7,6],[7,7,9,9],[8,5,8,6],[9,5,9,6]]}
["Item","Price","Result","Formula",null,null,null,null,null,"Return To Index"]
["Apple",45,{"$f":"INDEX($A$1:$B$6,2,2)","v":45}," =INDEX($A$1:$B$6,2,2)"]
["Banana",87,{"$f":"INDEX($A$1:$B$6,3,2)","v":87}," =INDEX($A$1:$B$6,3,2)"]
["Orange",39,{"$f":"INDEX($A$1:$B$6,4,2)","v":39}," =INDEX($A$1:$B$6,4,2)"]
["Grapes",77,{"$f":"INDEX($A$1:$B$6,5,2)","v":77}," =INDEX($A$1:$B$6,5,2)"]
["PineApple",17,{"$f":"INDEX($A$1:$B$6,6,2)","v":17}," =INDEX($A$1:$B$6,6,2)"]
[]
[null,null,null,null,null,"Array = A2:D7",null,"Index = \nIntersection of \nROW and COLUMN"]
[null,null,null,null,null,"3 = 3rd row"]
[null,null,null,null,null,"4 = 4th Column"]

{"sheet":"Index_Function","index":57,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[9,1,9,2],[9,3,11,5],[10,1,10,2],[11,1,11,2],[3,5,3,6]]}
["Student","Item","Price","Location",null,null,null,null,null,"Return To Index"]
["Apple","Pen",15,"Delhi"]
["Orange","Pencil",14,"Andhra",null,{"$f":"INDEX(A2:D7,3,4)","v":"Kerala"}]
["Banana","Duster",12,"Kerala",null," =INDEX(A2:D7,3,4)"]
["Grapes","Eraser",11,"Tamil"]
["PineApple","Marker",18,"Punjab"]
["Papaya","Bag",19,"Jammu"]
[]
[]
[null,"Array = A2:D7",null,"Index = \nIntersection of \nROW and COLUMN"]
[null,"3 = 3rd row"]
[null,"4 = 4th Column"]

{"sheet":"Indirect","index":58,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Fruits","Stationary","Zones",null,null,"Item Name","Drop Down",null,null,"Return To Index"]
["Apple","Pen","East",null,null,"Fruits","Orange"]
["Banana","Pencil","West"]
["Orange","Eraser","North"]
["Grapes","Salte","South"]
["PineApple","Book"]
[null,null,null,null,null,"Create The Names"]
[null,null,null,null,null,"Create data validation with Indirect function"]

{"sheet":"Indirect_Dependant_Dropdown","index":59,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,"Return To Index"]
[]
[null,null,"Items","Students","Vegetables",null,"Name","Dependent Dropdown"]
[null,null,"Pen","A","Potato",null,"Vegetables","Potato"]
[null,null,"Pencil","B","Cabege",null,"Items","Eraser"]
[null,null,"Eraser","C","Ladyfingure",null,"Students","C"]
[null,null,"Duster","D","Beans",null,"Vegetables","Ladyfingure"]
[null,null,"Bag","E","Tamato",null,"Items","Pen"]
[null,null,"Books","F"]

{"sheet":"ISBLANK","index":60,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["ISBLANK Function",null,null,null,null,null,null,null,null,"Return To Index"]
["Data","Result","Function"]
["Apple",{"$f":"ISBLANK(A3)","v":false}," =ISBLANK(A3)"]
[45,{"$f":"ISBLANK(A4)","v":false}," =ISBLANK(A4)"]
[null,true," =ISBLANK(A5)"]
["Banana",false," =ISBLANK(A6)"]
["Orange",false," =ISBLANK(A7)"]

{"sheet":"ISError_With_VLookup","index":61,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Compare Two Lists - Data Exists in  Second List Only - Remove the Errors",null,null,null,null,null,null,null,null,"Return To Index"]
["First List","Second List","Result","Formula"]
["Apple","Pen",{"$f":"IF(ISERROR(VLOOKUP(A3,$B$3:$B$7,1,FALSE)),B3, \"\")","v":"Pen"}," =IF(ISERROR(VLOOKUP(A3,$B$3:$B$7,1,FALSE)),B3, \"\")"]
["Banana","Pencil",{"$f":"IF(ISERROR(VLOOKUP(A4,$B$3:$B$7,1,FALSE)),B4, \"\")","v":"Pencil"}," =IF(ISERROR(VLOOKUP(A4,$B$3:$B$7,1,FALSE)),B4, \"\")"]
["Orange","Orange",""," =IF(ISERROR(VLOOKUP(A5,$B$3:$B$7,1,FALSE)),B5, \"\")"]
["Grapes","Board","Board"," =IF(ISERROR(VLOOKUP(A6,$B$3:$B$7,1,FALSE)),B6, \"\")"]
["Papaya","Eraser","Eraser"," =IF(ISERROR(VLOOKUP(A7,$B$3:$B$7,1,FALSE)),B7, \"\")"]

{"sheet":"ISEven","index":62,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["ISEVEN Function",null,null,null,null,null,null,null,null,"Return To Index"]
["Data","Result","Formula"]
[15,{"$f":"ISEVEN(A3)","v":false}," =ISEVEN(A3)"]
[20,{"$f":"ISEVEN(A4)","v":true}," =ISEVEN(A4)"]
[29,false," =ISEVEN(A5)"]
[20,true," =ISEVEN(A6)"]
[44,true," =ISEVEN(A7)"]

{"sheet":"ISFORMULA","index":63,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["ISFORMULA Function",null,null,null,null,null,null,null,null,"Return To Index"]
["Data","Result","Formula"]
[15,{"$f":"_xlfn.ISFORMULA(A3)","v":false}," =ISFORMULA(A3)"]
[{"$f":"A3+A5","v":44},{"$f":"_xlfn.ISFORMULA(A4)","v":true}," =ISFORMULA(A4)"]
[29,false," =ISFORMULA(A5)"]
[{"$f":"A5+A4","v":73},true," =ISFORMULA(A6)"]
[44,false," =ISFORMULA(A7)"]
[]
[]
[]
[]
[]
[]
[null,null,null,null," "]

{"sheet":"ISNA_With_VLookup","index":64,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Compare Two Lists - Using ISNA - Data Exists in Second Not In First",null,null,null,null,null,null,null,null,"Return To Index"]
["First List","Second List","Result","Formula"]
["Apple","Pen",{"$f":"IF(ISNA(VLOOKUP(A3,$B$3:$B$6,1,0)), B3, \"\")","v":""}," =IF(ISNA(VLOOKUP(A3,$B$3:$B$6,1,0)), B3, \"\")"]
["Banana","Pencil",{"$f":"IF(ISNA(VLOOKUP(A4,$B$3:$B$6,1,0)), B4, \"\")","v":"Pencil"}," =IF(ISNA(VLOOKUP(A4,$B$3:$B$6,1,0)), B4, \"\")"]
["Orange","Orange",""," =IF(ISNA(VLOOKUP(A5,$B$3:$B$6,1,0)), B5, \"\")"]
["Grapes","Apple","Apple"," =IF(ISNA(VLOOKUP(A6,$B$3:$B$6,1,0)), B6, \"\")"]
["Papaya","Eraser","Eraser"," =IF(ISNA(VLOOKUP(A7,$B$3:$B$6,1,0)), B7, \"\")"]

{"sheet":"ISNONTEXT","index":65,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["ISNONTEXT Function",null,null,null,null,null,null,null,null,"Return To Index"]
["Data","Result","Function"]
["Apple",{"$f":"ISNONTEXT(A3)","v":false}," =ISNONTEXT(A3)"]
["Banana",{"$f":"ISNONTEXT(A4)","v":false}," =ISNONTEXT(A4)"]
["Orange",false," =ISNONTEXT(A5)"]
["Grapes",false," =ISNONTEXT(A6)"]
[12345,true," =ISNONTEXT(A7)"]

{"sheet":"IsNumber","index":66,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["IsNumber Function",null,null,null,null,null,null,null,null,"Return To Index"]
["Data","Result","Formula"]
[58,{"$f":"ISNUMBER(A3)","v":true}," =ISNUMBER(A3)"]
[39,{"$f":"ISNUMBER(A4)","v":true}," =ISNUMBER(A4)"]
["Apple",false," =ISNUMBER(A5)"]
[25.3,true," =ISNUMBER(A6)"]
["Banana123",false," =ISNUMBER(A7)"]

{"sheet":"ISODD","index":67,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["ISODD Function",null,null,null,null,null,null,null,null,"Return To Index"]
["Number","Result","Formula"]
[15,{"$f":"ISODD(A3)","v":true}," =ISODD(A3)"]
[20,{"$f":"ISODD(A4)","v":false}," =ISODD(A4)"]
[29,true," =ISODD(A5)",null,"Returns TRUE if the provided number is ODD, else returns FALSE"]
[20,false," =ISODD(A6)"]
[44,false," =ISODD(A7)"]

{"sheet":"ISText","index":68,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["ISText Function",null,null,null,null,null,null,null,null,"Return To Index"]
["Text","Result","Formula"]
["Apple",{"$f":"ISTEXT(A3)","v":true}," =ISTEXT(A3)"]
["Banana",{"$f":"ISTEXT(A4)","v":true}," =ISTEXT(A4)"]
[45,false," =ISTEXT(A5)"]
["Grapes",true," =ISTEXT(A6)"]
[55,{"$f":"ISTEXT(A7)","v":false}," =ISTEXT(A7)"]
["Papaya",true," =ISTEXT(A8)"]

{"sheet":"Large","index":69,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Large  Function",null,null,null,null,null,null,null,null,"Return To Index"]
["Data","Result","Formula"]
[55,{"$f":"LARGE($A$3:$A$7, 1)","v":77}," =LARGE($A$3:$A$7, 1)"]
[48,{"$f":"LARGE($A$3:$A$7, 2)","v":55}," =LARGE($A$3:$A$7, 2)"]
[77,{"$f":"LARGE($A$3:$A$7, 3)","v":48}," =LARGE($A$3:$A$7, 3)"]
[38,{"$f":"LARGE($A$3:$A$7, 4)","v":38}," =LARGE($A$3:$A$7, 4)"]
[28,{"$f":"LARGE($A$3:$A$7, 5)","v":28}," =LARGE($A$3:$A$7, 5)"]

{"sheet":"Left","index":70,"n_rows":5,"n_cols":10,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Left  Function",null,null,null,null,null,null,null,null,"Return To Index"]
["Text","Result","Formula"]
["Left One",{"$f":"LEFT(A3,1)","v":"L"}," =LEFT(A3,1)"]
["Left Two",{"$f":"LEFT(A4,2)","v":"Le"}," =LEFT(A4,2)"]
["Left Zero",{"$f":"LEFT(A5,0)","v":""}," =LEFT(A5,0)"]

{"sheet":"Len","index":71,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Len Function",null,null,null,null,null,null,null,null,"Return To Index"]
["Text","Result","Formula"]
["Apple",{"$f":"LEN(A3)","v":5}," =LEN(A3)"]
["Banana",{"$f":"LEN(A4)","v":6}," =LEN(A4)"]
["Orange",6," =LEN(A5)"]
["Grapes",6," =LEN(A6)"]
["PineApple",9," =LEN(A7)"]
["Papaya",6," =LEN(A8)"]

{"sheet":"Lookup_RightToLeft_IndexMatch","index":72,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Company Name","SECTOR","LOCATION",null,null,null,null,null,null,"Return To Index"]
["A","CEMENT","HYD"]
["B","METAL","DELHI",null,"Location","Company Name"]
["C","STEEL","CHENNAI",null,"HOWRA",{"$f":"INDEX(A2:A9,MATCH(E4,C2:C9,0))","v":"G"}]
["D","PLASTIC","CALICUT"]
["E","IRON","CALCUTTA"," =INDEX(A2:A9,MATCH(E4,C2:C9,0))"]
["G","COPPOR","HOWRA"]
["G","INFRA","SECBAD"]
["H","PARA","GOA"]

{"sheet":"Lower","index":73,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Lower Function",null,null,null,null,null,null,null,null,"Return To Index"]
["Text","Result","Formula",null,null,null,null,null,null,"Return To Index"]
["Apple",{"$f":"LOWER(A3)","v":"apple"}," =LOWER(A3)"]
["Banana",{"$f":"LOWER(A4)","v":"banana"}," =LOWER(A4)"]
["Orange","orange"," =LOWER(A5)"]
["Grapes","grapes"," =LOWER(A6)"]
["PineApple","pineapple"," =LOWER(A7)"]

{"sheet":"Match","index":74,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["MATCH Function",null,null,null,null,null,null,null,null,"Return To Index"]
["Item","Price","Result","Formula"]
["Apple",45,{"$f":"MATCH(A3,$A$3:$A$7,0)","v":1}," =MATCH(A3,$A$3:$A$7,0)"]
["Banana",87,{"$f":"MATCH(A4,$A$3:$A$7,0)","v":2}," =MATCH(A4,$A$3:$A$7,0)"]
["Orange",39,3," =MATCH(A5,$A$3:$A$7,0)"]
["Grapes",77,4," =MATCH(A6,$A$3:$A$7,0)"]
["PineApple",17,5," =MATCH(A7,$A$3:$A$7,0)"]

{"sheet":"Max","index":75,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Max Function",null,null,null,null,null,null,null,null,"Return To Index"]
["Data","Result","Formula"]
[98,{"$f":"MAX(A3:A$9)","v":98}," =MAX(A3:A$9)"]
[59,{"$f":"MAX(A4:A$9)","v":86}," =MAX(A4:A$9)"]
[86,{"$f":"MAX(A5:A$9)","v":86}," =MAX(A5:A$9)"]
[78,{"$f":"MAX(A6:A$9)","v":78}," =MAX(A6:A$9)"]
[67,{"$f":"MAX(A7:A$9)","v":67}," =MAX(A7:A$9)"]
[55,{"$f":"MAX(A8:A$9)","v":55}," =MAX(A8:A$9)"]
[44,{"$f":"MAX(A9:A$9)","v":44}," =MAX(A9:A$9)"]

{"sheet":"MID","index":76,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["MID Function",null,null,null,null,null,null,null,null,"Return To Index"]
["Data","Result","Formula"]
["Pen",{"$f":"MID(A3,1,2)","v":"Pe"}," =MID(A3,1,2)"]
["Pencil",{"$f":"MID(A4,1,3)","v":"Pen"}," =MID(A4,1,3)"]
["Eraser",{"$f":"MID(A5,1,4)","v":"Eras"}," =MID(A5,1,4)"]
["Duster",{"$f":"MID(A6,1,5)","v":"Duste"}," =MID(A6,1,5)"]
["Marker",{"$f":"MID(A7,1,6)","v":"Marker"}," =MID(A7,1,6)"]

{"sheet":"MID_Function_Extract_GmailIDs","index":77,"n_rows":99,"n_cols":10,"rows_kept":99,"cut":false,"hidden":false,"merged":[]}
["Mail IDs","STEP 1 - Mid Function","STEP 2 - IF function","Final Output","Formula",null,null,null,null,"Return To Index"]
["abcd@gmail.com",{"$f":"MID(RIGHT(A2,9),1,5)","v":"gmail"},{"$f":"IF(MID(RIGHT(A2,9),1,5)=\"gmail\",A2,\"\")","v":"abcd@gmail.com"},"abcd@gmail.com"," =IF(MID(RIGHT(A2,9),1,5)=\"gmail\",A2,\"\")"]
["mnop@yahoomail.com",{"$f":"MID(RIGHT(A3,9),1,5)","v":"omail"},{"$f":"IF(MID(RIGHT(A3,9),1,5)=\"gmail\",A3,\"\")","v":""},"abc123@gmail.com"]
["abc123@gmail.com","gmail","abc123@gmail.com","jkl@gmail.com"]
["Yahoo1234@yahoomail.com","omail","","abcd@gmail.com"]
["abc@rediffmail.com","fmail","","abc123@gmail.com"]
["jkl@gmail.com","gmail","jkl@gmail.com","jkl@gmail.com"]
["rstuv@yahoomail.com","omail","","abcd@gmail.com"]
["abcd@gmail.com","gmail","abcd@gmail.com","abc123@gmail.com"]
["mnop@yahoomail.com","omail","","jkl@gmail.com"]
["abc123@gmail.com","gmail","abc123@gmail.com","abcd@gmail.com"]
["Yahoo1234@yahoomail.com","omail","","abc123@gmail.com"]
["abc@rediffmail.com","fmail","","jkl@gmail.com"]
["jkl@gmail.com","gmail","jkl@gmail.com","abcd@gmail.com"]
["rstuv@yahoomail.com","omail","","abc123@gmail.com"]
["abcd@gmail.com","gmail","abcd@gmail.com","jkl@gmail.com"]
["mnop@yahoomail.com","omail","","abcd@gmail.com"]
["abc123@gmail.com","gmail","abc123@gmail.com","abc123@gmail.com"]
["Yahoo1234@yahoomail.com","omail","","jkl@gmail.com"]
["abc@rediffmail.com","fmail","","abcd@gmail.com"]
["jkl@gmail.com","gmail","jkl@gmail.com","abc123@gmail.com"]
["rstuv@yahoomail.com","omail","","jkl@gmail.com"]
["abcd@gmail.com","gmail","abcd@gmail.com","abcd@gmail.com"]
["mnop@yahoomail.com","omail","","abc123@gmail.com"]
["abc123@gmail.com","gmail","abc123@gmail.com","jkl@gmail.com"]
["Yahoo1234@yahoomail.com","omail","","abcd@gmail.com"]
["abc@rediffmail.com","fmail","","abc123@gmail.com"]
["jkl@gmail.com","gmail","jkl@gmail.com","jkl@gmail.com"]
["rstuv@yahoomail.com","omail","","abcd@gmail.com"]
["abcd@gmail.com","gmail","abcd@gmail.com","abc123@gmail.com"]
["mnop@yahoomail.com","omail","","jkl@gmail.com"]
["abc123@gmail.com","gmail","abc123@gmail.com","abcd@gmail.com"]
["Yahoo1234@yahoomail.com","omail","","abc123@gmail.com"]
["abc@rediffmail.com","fmail","","jkl@gmail.com"]
["jkl@gmail.com","gmail","jkl@gmail.com","abcd@gmail.com"]
["rstuv@yahoomail.com","omail","","abc123@gmail.com"]
["abcd@gmail.com","gmail","abcd@gmail.com","jkl@gmail.com"]
["mnop@yahoomail.com","omail","","abcd@gmail.com"]
["abc123@gmail.com","gmail","abc123@gmail.com","abc123@gmail.com"]
["Yahoo1234@yahoomail.com","omail","","jkl@gmail.com"]
["abc@rediffmail.com","fmail","","abcd@gmail.com"]
["jkl@gmail.com","gmail","jkl@gmail.com","abc123@gmail.com"]
["rstuv@yahoomail.com","omail","","jkl@gmail.com"]
["abcd@gmail.com","gmail","abcd@gmail.com"]
["mnop@yahoomail.com","omail",""]
["abc123@gmail.com","gmail","abc123@gmail.com"]
["Yahoo1234@yahoomail.com","omail",""]
["abc@rediffmail.com","fmail",""]
["jkl@gmail.com","gmail","jkl@gmail.com"]
["rstuv@yahoomail.com","omail",""]
["abcd@gmail.com","gmail","abcd@gmail.com"]
["mnop@yahoomail.com","omail",""]
["abc123@gmail.com","gmail","abc123@gmail.com"]
["Yahoo1234@yahoomail.com","omail",""]
["abc@rediffmail.com","fmail",""]
["jkl@gmail.com","gmail","jkl@gmail.com"]
["rstuv@yahoomail.com","omail",""]
["abcd@gmail.com","gmail","abcd@gmail.com"]
["mnop@yahoomail.com","omail",""]
["abc123@gmail.com","gmail","abc123@gmail.com"]
["Yahoo1234@yahoomail.com","omail",""]
["abc@rediffmail.com","fmail",""]
["jkl@gmail.com","gmail","jkl@gmail.com"]
["rstuv@yahoomail.com","omail",""]
["abcd@gmail.com","gmail","abcd@gmail.com"]
["mnop@yahoomail.com","omail",""]
["abc123@gmail.com",{"$f":"MID(RIGHT(A67,9),1,5)","v":"gmail"},{"$f":"IF(MID(RIGHT(A67,9),1,5)=\"gmail\",A67,\"\")","v":"abc123@gmail.com"}]
["Yahoo1234@yahoomail.com","omail",""]
["abc@rediffmail.com","fmail",""]
["jkl@gmail.com","gmail","jkl@gmail.com"]
["rstuv@yahoomail.com","omail",""]
["abcd@gmail.com","gmail","abcd@gmail.com"]
["mnop@yahoomail.com","omail",""]
["abc123@gmail.com","gmail","abc123@gmail.com"]
["Yahoo1234@yahoomail.com","omail",""]
["abc@rediffmail.com","fmail",""]
["jkl@gmail.com","gmail","jkl@gmail.com"]
["rstuv@yahoomail.com","omail",""]
["abcd@gmail.com","gmail","abcd@gmail.com"]
["mnop@yahoomail.com","omail",""]
["abc123@gmail.com","gmail","abc123@gmail.com"]
["Yahoo1234@yahoomail.com","omail",""]
["abc@rediffmail.com","fmail",""]
["jkl@gmail.com","gmail","jkl@gmail.com"]
["rstuv@yahoomail.com","omail",""]
["abcd@gmail.com","gmail","abcd@gmail.com"]
["mnop@yahoomail.com","omail",""]
["abc123@gmail.com","gmail","abc123@gmail.com"]
["Yahoo1234@yahoomail.com","omail",""]
["abc@rediffmail.com","fmail",""]
["jkl@gmail.com","gmail","jkl@gmail.com"]
["rstuv@yahoomail.com","omail",""]
["abcd@gmail.com","gmail","abcd@gmail.com"]
["mnop@yahoomail.com","omail",""]
["abc123@gmail.com","gmail","abc123@gmail.com"]
["Yahoo1234@yahoomail.com","omail",""]
["abc@rediffmail.com","fmail",""]
["jkl@gmail.com","gmail","jkl@gmail.com"]
["rstuv@yahoomail.com","omail",""]

{"sheet":"Min","index":78,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["MIN Function",null,null,null,null,null,null,null,null,"Return To Index"]
["Data","Result","Formula"]
[32,{"$f":"MIN(A3:A$9)","v":32}," =MIN(A3:A$9)"]
[59,{"$f":"MIN(A4:A$9)","v":59}," =MIN(A4:A$9)"]
[86,{"$f":"MIN(A5:A$9)","v":66}," =MIN(A5:A$9)"]
[66,{"$f":"MIN(A6:A$9)","v":66}," =MIN(A6:A$9)"]
[67,{"$f":"MIN(A7:A$9)","v":67}," =MIN(A7:A$9)"]
[78,{"$f":"MIN(A8:A$9)","v":78}," =MIN(A8:A$9)"]
[84,{"$f":"MIN(A9:A$9)","v":84}," =MIN(A9:A$9)"]

{"sheet":"Mod","index":79,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["MOD Function",null,null,null,null,null,null,null,null,"Return To Index"]
["DIVIDEND","DIVISOR","REMAINDER","FORMULA"]
[25,5,{"$f":"MOD(A3,B3)","v":0}," =MOD(A3,B3)"]
[24,5,4," =MOD(A4,B4)"]
[18,5,3," =MOD(A5,B5)"]
[16,4,0," =MOD(A6,B6)"]
[26,6,2," =MOD(A7,B7)"]
[24,9,6," =MOD(A8,B8)"]
[14,4,2," =MOD(A9,B9)"]

{"sheet":"Month","index":80,"n_rows":6,"n_cols":10,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Month Function",null,null,null,null,null,null,null,null,"Return To Index"]
["Date","Result","Formula"]
["2020-03-20",{"$f":"MONTH(A3)","v":3}," =MONTH(A3)"]
["1978-01-27",{"$f":"MONTH(A4)","v":1}," =MONTH(A4)"]
[]
[null,null,null,null," "]

{"sheet":"Multiple_Condns_to_OR_with_IF","index":81,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Apply OR Operator with IF Condition",null,null,null,null,null,null,null,null,"Return To Index"]
["Data","Price","Result","Formula"]
["Apple",25,{"$f":"IF(OR(B3>70,B4>70,B5>70,B6>70,B7>70), \"Target Reached\", \"Target Not Reached\")","v":"Target Not Reached"}," =IF(OR(B3>70,B4>70,B5>70,B6>70,B7>70), \"Target Reached\", \"Target Not Reached\")"]
["Banana",36,{"$f":"IF(OR(B4>70,B5>70,B6>70,B7>70,B8>70), \"Target Reached\", \"Target Not Reached\")","v":"Target Not Reached"}," =IF(OR(B4>70,B5>70,B6>70,B7>70,B8>70), \"Target Reached\", \"Target Not Reached\")"]
["Orange",14,"Target Not Reached"," =IF(OR(B5>70,B6>70,B7>70,B8>70,B9>70), \"Target Reached\", \"Target Not Reached\")"]
["Grapes",28,"Target Not Reached"," =IF(OR(B6>70,B7>70,B8>70,B9>70,B10>70), \"Target Reached\", \"Target Not Reached\")"]
["PineApple",45,"Target Not Reached"," =IF(OR(B7>70,B8>70,B9>70,B10>70,B11>70), \"Target Reached\", \"Target Not Reached\")"]

{"sheet":"NestedIF_Function_Grading_Price","index":82,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Proivde  Grades To  Price Using Nested IF Conditions",null,null,null,null,null,null,null,null,"Return To Index"]
["Data","Price","Grades","Formula"]
["Pen",80,{"$f":"IF(B3 >=80, \"A\",IF(B3 >=60, \"B\", IF(B3<60, \"C\")))","v":"A"}," =IF(B3 >=80, \"A\",IF(B3 >=60, \"B\", IF(B3<60, \"C\")))"]
["Pencil",45,{"$f":"IF(B4 >=80, \"A\",IF(B4 >=60, \"B\", IF(B4<60, \"C\")))","v":"C"}," =IF(B4 >=80, \"A\",IF(B4 >=60, \"B\", IF(B4<60, \"C\")))"]
["Eraser",78,"B"," =IF(B5 >=80, \"A\",IF(B5 >=60, \"B\", IF(B5<60, \"C\")))"]
["Duster",81,"A"," =IF(B6 >=80, \"A\",IF(B6 >=60, \"B\", IF(B6<60, \"C\")))"]
["Marker",59,"C"," =IF(B7 >=80, \"A\",IF(B7 >=60, \"B\", IF(B7<60, \"C\")))"]

{"sheet":"NetWorkingDays","index":83,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,0,2,4]]}
[null,null,null,null,null,null,null,null,null,"Return To Index"]
[" NetWorkingDays Function"]
[]
["Start Date","End Date","Holidays","NetWorkingDays","Formula"]
["2020-01-25","2021-01-25",0,{"$f":"NETWORKDAYS(A5,B5,0)","v":261}," =NETWORKDAYS(A5,B5,0)"]
["2020-01-25","2021-01-25","2020-02-25",{"$f":"NETWORKDAYS(A6,B6,C6)","v":260}," =NETWORKDAYS(A6,B6,C6)"]
["2020-01-25","2021-01-25","2020-05-11",{"$f":"NETWORKDAYS(A7,B7,C6:C7)","v":259}," =NETWORKDAYS(A7,B7,C6:C7)"]
["2020-01-25","2021-01-25","2020-05-18",{"$f":"NETWORKDAYS(A8,B8,C6:C8)","v":258}," =NETWORKDAYS(A8,B8,C6:C8)"]
["2020-01-25","2021-01-25","2020-06-20",{"$f":"NETWORKDAYS(A9,B9,C6:C9)","v":258}," =NETWORKDAYS(A9,B9,C6:C9)"]

{"sheet":"Now","index":84,"n_rows":3,"n_cols":10,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Now Function",null,null,null,null,null,null,null,null,"Return To Index"]
["Now Formula Result","Formula"]
[{"$f":"NOW()","v":"2021-02-13T11:14:08.550"}," =NOW()"]

{"sheet":"ODD","index":85,"n_rows":6,"n_cols":10,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Data","Result","Formula",null,null,null,null,null,null,"Return To Index"]
[80,{"$f":"ODD(A2)","v":81}," =ODD(A2)"]
[70,{"$f":"ODD(A3)","v":71}," =ODD(A3)"]
[55,55," =ODD(A4)",null,null,"It returns nearest ODD Number if Input number is EVEN"]
[74,75," =ODD(A5)",null,null,"There is no change if the Input number is ODD"]
[65,65," =ODD(A6)"]

{"sheet":"OR_Operator","index":86,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["OR Operator",null,null,null,null,null,null,null,null,"Return To Index"]
["Number","Result","Formula"]
[15,{"$f":"OR(A3>11,A3<18)","v":true}," =OR(A3>11,A3<18)"]
[20,{"$f":"OR(A4>11,A4<18)","v":true}," =OR(A4>11,A4<18)"]
[29,true," =OR(A5>11,A5<18)"]
[20,true," =OR(A6>11,A6<18)"]
[44,true," =OR(A7>11,A7<18)"]

{"sheet":"OR_Operator_with_IF_Condition","index":87,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["OR Operator with IF Condition",null,null,null,null,null,null,null,null,"Return To Index"]
["Science","Social","Result","Formula"]
[15,22,{"$f":"IF(OR(A3>=35,B3>=35),\"PASS\",\"FAIL\")","v":"FAIL"}," =IF(OR(A3>=35,B3>=35),\"PASS\",\"FAIL\")"]
[20,38,{"$f":"IF(OR(A4>=35,B4>=35),\"PASS\",\"FAIL\")","v":"PASS"}," =IF(OR(A4>=35,B4>=35),\"PASS\",\"FAIL\")"]
[29,17,"FAIL"," =IF(OR(A5>=35,B5>=35),\"PASS\",\"FAIL\")"]
[78,47,"PASS"," =IF(OR(A6>=35,B6>=35),\"PASS\",\"FAIL\")"]
[34,22,"FAIL"," =IF(OR(A7>=35,B7>=35),\"PASS\",\"FAIL\")"]

{"sheet":"Proper","index":88,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Proper Function",null,null,null,null,null,null,null,null,"Return To Index"]
["Fruits","Result","Formula"]
["Apple",{"$f":"PROPER(A3)","v":"Apple"}," =PROPER(A3)"]
["Banana",{"$f":"PROPER(A4)","v":"Banana"}," =PROPER(A4)"]
["Orange","Orange"," =PROPER(A5)"]
["Grapes","Grapes"," =PROPER(A6)"]
["PineApple","Pineapple"," =PROPER(A7)"]

{"sheet":"Quotient","index":89,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":false,"merged":[[7,1,13,4]]}
["Subject","Amount","Books","Per Book Price","Formula",null,null,null,null,"Return To Index"]
["Science",100,3,{"$f":"QUOTIENT(B2,C2)","v":33}," =QUOTIENT(B2,C2)"]
["Maths",130,7,18," =QUOTIENT(B3,C3)"]
["English",145,8,18," =QUOTIENT(B4,C4)"]
["Social",360,9,40," =QUOTIENT(B5,C5)"]
["Hindi",210,11,19," =QUOTIENT(B6,C6)"]
[]
[null,"Quotient Function gives\n whole number as answer, ignores the decimals"]

{"sheet":"Rank","index":90,"n_rows":6,"n_cols":10,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["STUDENT","MARKS","RANK","FORMULA",null,null,null,null,null,"Return To Index"]
["A",4,{"$f":"RANK(B2,$B$2:$B$6,0)","v":4}," =RANK(B2,$B$2:$B$6,0)"]
["B",6,{"$f":"RANK(B3,$B$2:$B$6,0)","v":3}," =RANK(B3,$B$2:$B$6,0)"]
["C",3,{"$f":"RANK(B4,$B$2:$B$6,0)","v":5}," =RANK(B4,$B$2:$B$6,0)"]
["D",12,{"$f":"RANK(B5,$B$2:$B$6,0)","v":2}," =RANK(B5,$B$2:$B$6,0)"]
["E",24,{"$f":"RANK(B6,$B$2:$B$6,0)","v":1}," =RANK(B6,$B$2:$B$6,0)"]

{"sheet":"Rank_when_Duplicates_Exists","index":91,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,"Return To Index"]
[null,"Fruit","PRICE","Rank","More\n than\n once","Ranking","Final","Formula"]
[null,"Apple",145,{"$f":"RANK(C3,$C$3:$C$12,0)","v":2},{"$f":"COUNTIF($C3:$C$12,C3)-1","v":1},{"$f":"D3+E3","v":3},{"$f":"RANK(C3,$C$3:$C$12,0)+COUNTIF($C3:$C$12,C3)-1","v":3}," =RANK(C3,$C$3:$C$12,0)+COUNTIF($C3:$C$12,C3)-1"]
[null,"Banana",145,{"$f":"RANK(C4,$C$3:$C$12,0)","v":2},{"$f":"COUNTIF($C4:$C$12,C4)-1","v":0},{"$f":"D4+E4","v":2},{"$f":"RANK(C4,$C$3:$C$12,0)+COUNTIF($C4:$C$12,C4)-1","v":2}," =RANK(C4,$C$3:$C$12,0)+COUNTIF($C4:$C$12,C4)-1"]
[null,"Grapes",125,6,{"$f":"COUNTIF($C5:$C$12,C5)-1","v":0},6,{"$f":"RANK(C5,$C$3:$C$12,0)+COUNTIF($C5:$C$12,C5)-1","v":6}," =RANK(C5,$C$3:$C$12,0)+COUNTIF($C5:$C$12,C5)-1"]
[null,"PineApple",115,7,{"$f":"COUNTIF($C6:$C$12,C6)-1","v":0},7,{"$f":"RANK(C6,$C$3:$C$12,0)+COUNTIF($C6:$C$12,C6)-1","v":7}," =RANK(C6,$C$3:$C$12,0)+COUNTIF($C6:$C$12,C6)-1"]
[null,"Orange",195,1,{"$f":"COUNTIF($C7:$C$12,C7)-1","v":0},1,{"$f":"RANK(C7,$C$3:$C$12,0)+COUNTIF($C7:$C$12,C7)-1","v":1}," =RANK(C7,$C$3:$C$12,0)+COUNTIF($C7:$C$12,C7)-1"]
[null,"Papaya",96,8,{"$f":"COUNTIF($C8:$C$12,C8)-1","v":1},9,{"$f":"RANK(C8,$C$3:$C$12,0)+COUNTIF($C8:$C$12,C8)-1","v":9}," =RANK(C8,$C$3:$C$12,0)+COUNTIF($C8:$C$12,C8)-1"]
[null,"WaterMelon",96,8,{"$f":"COUNTIF($C9:$C$12,C9)-1","v":0},8,{"$f":"RANK(C9,$C$3:$C$12,0)+COUNTIF($C9:$C$12,C9)-1","v":8}," =RANK(C9,$C$3:$C$12,0)+COUNTIF($C9:$C$12,C9)-1"]
[null,"Mango",63,10,{"$f":"COUNTIF($C10:$C$12,C10)-1","v":0},10,{"$f":"RANK(C10,$C$3:$C$12,0)+COUNTIF($C10:$C$12,C10)-1","v":10}," =RANK(C10,$C$3:$C$12,0)+COUNTIF($C10:$C$12,C10)-1"]
[null,"Strawberry",135,4,{"$f":"COUNTIF($C11:$C$12,C11)-1","v":1},5,{"$f":"RANK(C11,$C$3:$C$12,0)+COUNTIF($C11:$C$12,C11)-1","v":5}," =RANK(C11,$C$3:$C$12,0)+COUNTIF($C11:$C$12,C11)-1"]
[null,"Grauva",135,4,{"$f":"COUNTIF($C12:$C$12,C12)-1","v":0},4,{"$f":"RANK(C12,$C$3:$C$12,0)+COUNTIF($C12:$C$12,C12)-1","v":4}," =RANK(C12,$C$3:$C$12,0)+COUNTIF($C12:$C$12,C12)-1"]

{"sheet":"Remove_Dupes_IndexMatchIfError","index":92,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,2,9,2]]}
["Item","Unique ","Formula",null,null,null,null,null,null,"Return To Index"]
["Apple",{"$f":"IFERROR(INDEX($A$2:$A$10, MATCH(0, COUNTIF($B$1:B1, $A$2:$A$10), 0)),\"\")","v":"Apple"}," =IFERROR(INDEX\n($A$2:$A$10, \nMATCH(0, COUNTIF\n($B$1:B1, $A$2:$A$10), 0)),\"\")"]
[99,{"$f":"IFERROR(INDEX($A$2:$A$10, MATCH(0, COUNTIF($B$1:B2, $A$2:$A$10), 0)),\"\")","v":99}]
["Pencil",{"$f":"IFERROR(INDEX($A$2:$A$10, MATCH(0, COUNTIF($B$1:B3, $A$2:$A$10), 0)),\"\")","v":"Pencil"}]
["Orange",{"$f":"IFERROR(INDEX($A$2:$A$10, MATCH(0, COUNTIF($B$1:B4, $A$2:$A$10), 0)),\"\")","v":"Orange"}]
[99,{"$f":"IFERROR(INDEX($A$2:$A$10, MATCH(0, COUNTIF($B$1:B5, $A$2:$A$10), 0)),\"\")","v":16}]
[16,{"$f":"IFERROR(INDEX($A$2:$A$10, MATCH(0, COUNTIF($B$1:B6, $A$2:$A$10), 0)),\"\")","v":"Grapes"}]
["Grapes",{"$f":"IFERROR(INDEX($A$2:$A$10, MATCH(0, COUNTIF($B$1:B7, $A$2:$A$10), 0)),\"\")","v":18}]
[18,{"$f":"IFERROR(INDEX($A$2:$A$10, MATCH(0, COUNTIF($B$1:B8, $A$2:$A$10), 0)),\"\")","v":""}]
["Apple",{"$f":"IFERROR(INDEX($A$2:$A$10, MATCH(0, COUNTIF($B$1:B9, $A$2:$A$10), 0)),\"\")","v":""}]

{"sheet":"Remove_Dupes_VLookupIFError_Row","index":93,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Remove Duplicates Using Vlookup,IFError and Row Functions",null,null,null,null,null,null,null,null,"Return To Index"]
["Numbering","Item","Unique ","IFError","Formula"]
[1,"Apple",{"$f":"VLOOKUP(ROW()-1,$A$3:$B$11,2,0)","v":99},{"$f":"IFERROR(VLOOKUP(ROW()-1,$A$3:$B$11,2,0),\"\")","v":99}," =IFERROR(VLOOKUP(ROW()-1,$A$3:$B$11,2,0),\"\")"]
[{"$f":"IF(COUNTIF(B$2:B4,B4)=1,A3+1,A3)","v":2},99,{"$f":"VLOOKUP(ROW()-1,$A$3:$B$11,2,0)","v":"Pencil"},{"$f":"IFERROR(VLOOKUP(ROW()-1,$A$3:$B$11,2,0),\"\")","v":"Pencil"}," =IFERROR(VLOOKUP(ROW()-1,$A$3:$B$11,2,0),\"\")"]
[{"$f":"IF(COUNTIF(B$2:B5,B5)=1,A4+1,A4)","v":3},"Pencil","Pen","Pen"," =IFERROR(VLOOKUP(ROW()-1,$A$3:$B$11,2,0),\"\")"]
[{"$f":"IF(COUNTIF(B$2:B6,B6)=1,A5+1,A5)","v":4},"Pen",16,16," =IFERROR(VLOOKUP(ROW()-1,$A$3:$B$11,2,0),\"\")"]
[{"$f":"IF(COUNTIF(B$2:B7,B7)=1,A6+1,A6)","v":4},99,"Orange","Orange"," =IFERROR(VLOOKUP(ROW()-1,$A$3:$B$11,2,0),\"\")"]
[{"$f":"IF(COUNTIF(B$2:B8,B8)=1,A7+1,A7)","v":5},16,{"$error":"#N/A"},""," =IFERROR(VLOOKUP(ROW()-1,$A$3:$B$11,2,0),\"\")"]
[{"$f":"IF(COUNTIF(B$2:B9,B9)=1,A8+1,A8)","v":5},"Apple",{"$error":"#N/A"},""," =IFERROR(VLOOKUP(ROW()-1,$A$3:$B$11,2,0),\"\")"]
[{"$f":"IF(COUNTIF(B$2:B10,B10)=1,A9+1,A9)","v":5},99,{"$error":"#N/A"},""," =IFERROR(VLOOKUP(ROW()-1,$A$3:$B$11,2,0),\"\")"]
[{"$f":"IF(COUNTIF(B$2:B11,B11)=1,A10+1,A10)","v":6},"Orange",{"$error":"#N/A"},""," =IFERROR(VLOOKUP(ROW()-1,$A$3:$B$11,2,0),\"\")"]
["STEP #1",null,"STEP #2","STEP #3"]

{"sheet":"Remove_Duplicates_IF_CountIF","index":94,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Remove Duplicates Using IF and CountIF Function",null,null,null,null,null,null,null,null,"Return To Index"]
["Item","Unique ","Formula"]
["Apple",{"$f":"IF(COUNTIF($A$3:A3,A3)=1,A3,\"\")","v":"Apple"}," =IF(COUNTIF($A$3:A3,A3)=1,A3,\"\")"]
[99,{"$f":"IF(COUNTIF($A$3:A4,A4)=1,A4,\"\")","v":99}," =IF(COUNTIF($A$3:A4,A4)=1,A4,\"\")"]
["Pencil",{"$f":"IF(COUNTIF($A$3:A5,A5)=1,A5,\"\")","v":"Pencil"}," =IF(COUNTIF($A$3:A5,A5)=1,A5,\"\")"]
["Pen",{"$f":"IF(COUNTIF($A$3:A6,A6)=1,A6,\"\")","v":"Pen"}," =IF(COUNTIF($A$3:A6,A6)=1,A6,\"\")"]
[99,{"$f":"IF(COUNTIF($A$3:A7,A7)=1,A7,\"\")","v":""}," =IF(COUNTIF($A$3:A7,A7)=1,A7,\"\")"]
[16,{"$f":"IF(COUNTIF($A$3:A8,A8)=1,A8,\"\")","v":16}," =IF(COUNTIF($A$3:A8,A8)=1,A8,\"\")"]
["Apple",{"$f":"IF(COUNTIF($A$3:A9,A9)=1,A9,\"\")","v":""}," =IF(COUNTIF($A$3:A9,A9)=1,A9,\"\")"]
[99,{"$f":"IF(COUNTIF($A$3:A10,A10)=1,A10,\"\")","v":""}," =IF(COUNTIF($A$3:A10,A10)=1,A10,\"\")"]
["Orange",{"$f":"IF(COUNTIF($A$3:A11,A11)=1,A11,\"\")","v":"Orange"}," =IF(COUNTIF($A$3:A11,A11)=1,A11,\"\")"]

{"sheet":"Remove_Last_Two_Chars_Left_Len","index":95,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Remove Last Two Characters From String",null,null,null,null,null,null,null,null,"Return To Index"]
["Original Text","Result","Formula"]
["Apple",{"$f":"LEFT(A3,LEN(A3)-2)","v":"App"}," =LEFT(A3,LEN(A3)-2)"]
["Banana",{"$f":"LEFT(A4,LEN(A4)-2)","v":"Bana"}," =LEFT(A4,LEN(A4)-2)"]
["PineApple","PineApp"," =LEFT(A5,LEN(A5)-2)"]
["Orange","Oran"," =LEFT(A6,LEN(A6)-2)"]
["Grapes","Grap"," =LEFT(A7,LEN(A7)-2)"]

{"sheet":"Replace","index":96,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Replace Function",null,null,null,null,null,null,null,null,"Return To Index"]
["Old Text","New Text","Formula"]
["Old Text",{"$f":"REPLACE(A3,1,3,\"New\")","v":"New Text"}," =REPLACE(A2,1,3,\"New\")"]
["Apple",{"$f":"REPLACE(A4,4,2,\"\")","v":"App"}," =REPLACE(A3,4,2,\"\")"]
["Banana",{"$f":"REPLACE(A5,4,3,\"ner\")","v":"Banner"}," =REPLACE(A4,4,3,\"ner\")"]
["Orange",{"$f":"REPLACE(A6,1,1,\"Ar\")","v":"Arrange"}," =REPLACE(A5,1,1,\"Ar\")"]
["Ascending",{"$f":"REPLACE(A7,1,1,\"De\")","v":"Descending"}," =REPLACE(A6,1,1,\"De\")"]
["Increase",{"$f":"REPLACE(A8,1,2,\"De\")","v":"Decrease"}," =REPLACE(A7,1,2,\"De\")"]

{"sheet":"Replace_Using_IF_And_Left_Func","index":97,"n_rows":6,"n_cols":10,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Fruit","Result","Formula",null,null,null,null,null,null,"Return To Index"]
["Apple",{"$f":"IF(LEFT(A2,1)=\"A\",REPLACE(A2,1,5,\"App\"),\"Not Replaced\")","v":"App"}," =IF(LEFT(A2,1)=\"A\",REPLACE(A2,1,5,\"App\"),\"Not Replaced\")"]
["Banana",{"$f":"IF(LEFT(A3,1)=\"A\",REPLACE(A3,1,5,\"App\"),\"Not Replaced\")","v":"Not Replaced"}," =IF(LEFT(A3,1)=\"A\",REPLACE(A3,1,5,\"App\"),\"Not Replaced\")"]
["Apple","App"," =IF(LEFT(A4,1)=\"A\",REPLACE(A4,1,5,\"App\"),\"Not Replaced\")"]
["Grapes","Not Replaced"," =IF(LEFT(A5,1)=\"A\",REPLACE(A5,1,5,\"App\"),\"Not Replaced\")"]
["Pineapple","Not Replaced"," =IF(LEFT(A6,1)=\"A\",REPLACE(A6,1,5,\"App\"),\"Not Replaced\")"]

{"sheet":"Rept","index":98,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["REPT Function",null,null,null,null,null,null,null,null,"Return To Index"]
["Fruits","Result","Formula"]
["Apple",{"$f":"REPT(A3,2)","v":"AppleApple"}," =REPT(A3,2)"]
["Banana",{"$f":"REPT(A4,3)","v":"BananaBananaBanana"}," =REPT(A4,3)"]
["Orange",{"$f":"REPT(A5,1)","v":"Orange"}," =REPT(A5,1)"]
["Grapes",{"$f":"REPT(A6, 2)","v":"GrapesGrapes"}," =REPT(A6, 2)"]
["PineApple",{"$f":"REPT(A7,2)","v":"PineApplePineApple"}," =REPT(A7,2)"]

{"sheet":"Retrieve_Dupes_Using_CountIF_IF","index":99,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[[10,0,14,2]]}
["Item","Duplicates","Formula",null,null,null,null,null,null,"Return To Index"]
["Apple",{"$f":"IF(COUNTIF($A$2:$A$10,A2)>1,A2,\"\")","v":"Apple"}," =IF(COUNTIF($A$2:$A$10,A2)>1,A2,\"\")"]
[99,99," =IF(COUNTIF($A$2:$A$10,A3)>1,A3,\"\")"]
["Pencil","Pencil"," =IF(COUNTIF($A$2:$A$10,A4)>1,A4,\"\")"]
["Pen",""," =IF(COUNTIF($A$2:$A$10,A5)>1,A5,\"\")"]
[99,99," =IF(COUNTIF($A$2:$A$10,A6)>1,A6,\"\")"]
[16,""," =IF(COUNTIF($A$2:$A$10,A7)>1,A7,\"\")"]
["Apple","Apple"," =IF(COUNTIF($A$2:$A$10,A8)>1,A8,\"\")"]
[99,99," =IF(COUNTIF($A$2:$A$10,A9)>1,A9,\"\")"]
["Pencil","Pencil"," =IF(COUNTIF($A$2:$A$10,A10)>1,A10,\"\")"]
[" Retrieve duplicate values, \nignore unique values"]

{"sheet":"Right","index":100,"n_rows":5,"n_cols":10,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Right Function",null,null,null,null,null,null,null,null,"Return To Index"]
["Text","Result","Formula"]
["Right Zero",{"$f":"RIGHT(A3, 0)","v":""}," =RIGHT(A3, 0)"]
["Right One",{"$f":"RIGHT(A4, 1)","v":"e"}," =RIGHT(A4, 1)"]
["Right Two",{"$f":"RIGHT(A5, 2)","v":"wo"},"  =RIGHT(A5, 2)"]

{"sheet":"ROMAN","index":101,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["ROMAN Function",null,null,null,null,null,null,null,null,"Return To Index"]
["Data","Roman Number","Formula"]
[55,{"$f":"ROMAN(A3,4)","v":"LV"}," =ROMAN(A3,4)"]
[48,{"$f":"ROMAN(A4,4)","v":"VLIII"}," =ROMAN(A4,4)"]
[77,"LXXVII"," =ROMAN(A5,4)"]
[38,{"$f":"ROMAN(A6,3)","v":"XXXVIII"}," =ROMAN(A6,3)"]
[28,{"$f":"ROMAN(A7,1)","v":"XXVIII"}," =ROMAN(A7,1)"]

{"sheet":"Round","index":102,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["ROUND Function",null,null,null,null,null,null,null,null,"Return To Index"]
["Data","Result","Formula"]
[45.22,{"$f":"ROUND(A3,0)","v":45}," =ROUND(A3,0)"]
[78.650000000000006,{"$f":"ROUND(A4,1)","v":78.7}," =ROUND(A4,1)"]
[254.25700000000001,{"$f":"ROUND(A5,1)","v":254.3}," =ROUND(A5,1)"]
[47.369,{"$f":"ROUND(A6,3)","v":47.369}," =ROUND(A6,3)"]
[22.45,{"$f":"ROUND(A7,0)","v":22}," =ROUND(A7,0)"]

{"sheet":"RoundDown","index":103,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["ROUNDDOWN Function",null,null,null,null,null,null,null,null,"Return To Index"]
["Data","Result","Formula"]
[45.22,{"$f":"ROUNDDOWN(A3,0)","v":45}," =ROUNDDOWN(A3,0)"]
[78.650000000000006,{"$f":"ROUNDDOWN(A4,1)","v":78.599999999999994}," =ROUNDDOWN(A4,1)"]
[254.25700000000001,{"$f":"ROUNDDOWN(A5,2)","v":254.25}," =ROUNDDOWN(A5,2)"]
[47.369,{"$f":"ROUNDDOWN(A6,2)","v":47.36}," =ROUNDDOWN(A6,2)"]
[22.45,{"$f":"ROUNDDOWN(A7,1)","v":22.4}," =ROUNDDOWN(A7,1)"]

{"sheet":"RoundUp","index":104,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["ROUNDUP Function",null,null,null,null,null,null,null,null,"Return To Index"]
["Data","Result","Formula"]
[45.22,{"$f":"ROUNDUP(A3,0)","v":46}," =ROUNDUP(A3,0)"]
[78.650000000000006,{"$f":"ROUNDUP(A4,1)","v":78.699999999999989}," =ROUNDUP(A4,1)"]
[254.25700000000001,{"$f":"ROUNDUP(A5,2)","v":254.26}," =ROUNDUP(A5,2)"]
[47.369,{"$f":"ROUNDUP(A6,2)","v":47.37}," =ROUNDUP(A6,2)"]
[22.45,{"$f":"ROUNDUP(A7,1)","v":22.5}," =ROUNDUP(A7,1)"]

{"sheet":"Row","index":105,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Reference Provided","Reference Omitted","Formula",null,null,null,null,null,null,"Return To Index"]
[{"$f":"ROW(D3)","v":3},{"$f":"ROW()","v":2}," =ROW()"]
[{"$f":"ROW(A6)","v":6},{"$f":"ROW()","v":3}," =ROW()"]
[null,{"$f":"ROW()","v":4}," =ROW()"," "]
[null,{"$f":"ROW()","v":5}," =ROW()"]
[null,{"$f":"ROW()","v":6}," =ROW()"]
[null,{"$f":"ROW()","v":7}," =ROW()"]
[null,{"$f":"ROW()","v":8}," =ROW()"]
[null,{"$f":"ROW()","v":9}," =ROW()"]
[null,{"$f":"ROW()","v":10}," =ROW()"]
[null,{"$f":"ROW()","v":11}," =ROW()"]

{"sheet":"Search","index":106,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Search Function",null,null,null,null,null,null,null,null,"Return To Index"]
["Fruits","Result","Formula"]
["Apple Banana",{"$f":"SEARCH(\"Apple\",A3,1)","v":1}," =SEARCH(\"Apple\",A3,1)"]
["Banana Apple",{"$f":"SEARCH(\"Apple\",A4,1)","v":8}," =SEARCH(\"Apple\",A4,1)"]
["Orange Apple",8," =SEARCH(\"Apple\",A5,1)"]
["Apple Grapes",1," =SEARCH(\"Apple\",A6,1)"]
["PineApple Apple",5," =SEARCH(\"Apple\",A7,1)"]

{"sheet":"SHEET","index":107,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["SHEET Function",null,null,null,null,null,null,null,null,"Return To Index"]
["Data","Result","Function",null,null,null,null,"Returns the Sheet Number"]
["Apple",{"$f":"_xlfn.SHEET(A3)","v":108}," =SHEET(A3)"]
["Banana",{"$f":"_xlfn.SHEET(A4)","v":108}," =SHEET(A4)"]
["Orange",108," =SHEET(A5)"]
["Grapes",108," =SHEET(A6)"]
[12345,108," =SHEET(A7)"]

{"sheet":"Small","index":108,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Small Function",null,null,null,null,null,null,null,null,"Return To Index"]
["Data","Result","Formula"]
[55,{"$f":"SMALL($A$3:$A$7, 1)","v":28}," =SMALL($A$3:$A$7, 1)"]
[48,{"$f":"SMALL($A$3:$A$7, 2)","v":38}," =SMALL($A$3:$A$7, 2)"]
[77,{"$f":"SMALL($A$3:$A$7, 3)","v":48}," =SMALL($A$3:$A$7, 3)"]
[38,{"$f":"SMALL($A$3:$A$7, 4)","v":55}," =SMALL($A$3:$A$7, 4)"]
[28,{"$f":"SMALL($A$3:$A$7, 5)","v":77}," =SMALL($A$3:$A$7, 5)"]

{"sheet":"Split_The_Text_Using_FIND_func","index":109,"n_rows":5,"n_cols":10,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Split The Text Using FIND Function",null,null,null,null,null,null,null,null,"Return To Index"]
["Original Text",", Position","Left Text","Right Text","Right Text - Formula"]
["Apple, Banana",{"$f":"FIND(\",\",A3)","v":6},{"$f":"LEFT(A3,B3-1)","v":"Apple"},{"$f":"RIGHT(A3,LEN(A3)-B3-1)","v":"Banana"}," =RIGHT(A3,LEN(A3)-B3-1)"]
["Orange, Grapes",{"$f":"FIND(\",\",A4)","v":7},{"$f":"LEFT(A4,B4-1)","v":"Orange"},{"$f":"RIGHT(A4,LEN(A4)-B4-1)","v":"Grapes"}," =RIGHT(A4,LEN(A4)-B4-1)"]
["Pen, Pencil",4,"Pen","Pencil"," =RIGHT(A5,LEN(A5)-B5-1)"]

{"sheet":"Substitute","index":110,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Substitue Function",null,null,null,null,null,null,null,null,"Return To Index"]
["Old Text","New Text","Formula"]
["Old Text",{"$f":"SUBSTITUTE(A3,\"Old\",\"My\",1)","v":"My Text"}," =SUBSTITUTE(A3,\"Old\",\"My\",1)"]
["Apple",{"$f":"SUBSTITUTE(A4,\"p\",\"e\",2)","v":"Apele"}," =SUBSTITUTE(A4,\"p\",\"e\",2)"]
["Banana",{"$f":"SUBSTITUTE(A5,\"a\",\" \")","v":"B n n "}," =SUBSTITUTE(A5,\"a\",\" \")"]
["ProvideSpace",{"$f":"SUBSTITUTE(A6,\"e\",\"e \",1)","v":"Provide Space"}," =SUBSTITUTE(A6,\"e\",\"e \",1)"]
["Remove Space",{"$f":"SUBSTITUTE(A7,\" \",\"\",1)","v":"RemoveSpace"}," =SUBSTITUTE(A7,\" \",\"\",1)"]

{"sheet":"Sum","index":111,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Sum Function",null,null,null,null,null,null,null,null,"Return To Index"]
["Data","Result","Formula"]
[55,{"$f":"SUM(A3:A$7)","v":269}," =SUM(A3:A$7)"]
[45,{"$f":"SUM(A4:A$7)","v":214}," =SUM(A4:A$7)"]
[36,{"$f":"SUM(A5:A$7)","v":169}," =SUM(A5:A$7)"]
[78,{"$f":"SUM(A6:A$7)","v":133}," =SUM(A6:A$7)"]
[55,{"$f":"SUM(A7:A$7)","v":55}," =SUM(A7:A$7)"]

{"sheet":"Sum_Based_On_Incremental_Range","index":112,"n_rows":21,"n_cols":12,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,1,8],[2,3,2,4],[2,5,2,11]]}
["Sum based on Incremental Range",null,null,null,null,null,null,null,null,"Return To Index"]
[]
["Weekday","Sales",null,"Weekly Sum",null,"Formula"]
["Monday",1500,null,"1st Week",{"$f":"SUM(OFFSET($B$4,(ROW()-ROW($B$4))*6,0,6,1))","v":8454}," =SUM(OFFSET($B$4,(ROW()-ROW($B$4))*6,0,6,1))"]
["Tuesday",1600,null,"2nd Week",{"$f":"SUM(OFFSET($B$4,(ROW()-ROW($B$4))*6,0,6,1))","v":57802}," =SUM(OFFSET($B$4,(ROW()-ROW($B$4))*6,0,6,1))"]
["Wednesday",1300,null,"3rd Week",{"$f":"SUM(OFFSET($B$4,(ROW()-ROW($B$4))*6,0,6,1))","v":113851}," =SUM(OFFSET($B$4,(ROW()-ROW($B$4))*6,0,6,1))"]
["Thursday",1400,null,null,null,null,null,null,null,null,null," "]
["Friday",1300]
["Saturday",1354,null,"Monday to Saturday = 1 week"]
["Monday",6574]
["Tuesday",35925]
["Wednesday",954]
["Thursday",1254]
["Friday",9571]
["Saturday",3524]
["Monday",31458]
["Tuesday",8564]
["Wednesday",2547]
["Thursday",2514]
["Friday",36254]
["Saturday",32514]

{"sheet":"Sum_Large_Three_Values","index":113,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,5,1,7]]}
["Item","Price","Position","Result",null,null,null,null,null,"Return To Index"]
["Pen",125,1,{"$f":"LARGE($B$2:$B$9,C2)","v":157},null,"ADD BASED ON POSITION"]
["Pencil",145,2,145,null,5,2,7]
["Eraser",95,3,125,null,{"$f":"LARGE(B2:B9,F3)+LARGE(B2:B9,G3)+LARGE(B2:B9,H3)","v":306},"RESULT"]
["Marker",68,4,98,null," =LARGE(B2:B9,F3)+LARGE(B2:B9,G3)+LARGE(B2:B9,H3)"]
["Board",157,5,95,null,null,"(OR)"]
["Slate",66,6,68,null,{"$f":"SUM(LARGE(B2:B9,{5,2,7}))","v":306}," =SUM(LARGE(B2:B9,{5,2,7}))"]
["Books",98,7,66]
["Charts",35,8,35]

{"sheet":"Sum_The_Named_Range","index":114,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,3],[2,3,6,3],[3,2,6,2]]}
["Sum The Named Range",null,null,null,null,null,null,null,null,"Return To Index"]
["Data","Price","Result","Formula"]
["Apple",48,{"$f":"SUM(FruitsCost)","v":232}," =SUM(FruitsCost)"]
["Banana",35]
["Orange",47]
["Banana",55]
["Grapes",47]

{"sheet":"SumIF_Based_On_Len_Of_Text","index":115,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,3],[3,2,6,3]]}
["SumIF Function - Based On Length Of Text",null,null,null,null,null,null,null,null,"Return To Index"]
["Data","Price","Result","Formula"]
["Apple",48,{"$f":"SUMIF($A$3:$A$7,\"????*\",$B$3:$B$7)","v":197}," =SUMIF($A$3:$A$7,\"????*\",$B$3:$B$7)"]
["Pen",35,"Sum when Length consists \nof Minimum 4 Characters"]
["Pencil",47]
["Apple",55]
["Grapes",47]

{"sheet":"SumIF_Based_On_WildCard_Chactr","index":116,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["SumIF Function - Criteria with WILDCARD",null,null,null,null,null,null,null,null,"Return To Index"]
["Data","Price","Result","Formula","Criteria"]
["Apple",48,{"$f":"SUMIF($A$3:$A$7,\"???l*\",$B$3:$B$7)","v":48}," =SUMIF($A$3:$A$7,\"???l*\",$B$3:$B$7)","4th Letter is L"]
["Banana",35,{"$f":"SUMIF($A$3:$A$7,\"Banana\",$B$3:$B$7)","v":82}," =SUMIF($A$3:$A$7,\"??n*\",$B$3:$B$7)","3rd Letter is N"]
["Pencil",47,{"$f":"SUMIF($A$3:$A$7,\"?e*\",$B$3:$B$7)","v":47}," =SUMIF($A$3:$A$7,\"?e*\",$B$3:$B$7)","2nd Letter is E"]
["Grapes",55,{"$f":"SUMIF($A$3:$A$7,\"??a*\",$B$3:$B$7)","v":55}," =SUMIF($A$3:$A$7,\"??a*\",$B$3:$B$7)","3rd Letter is A"]
["Banana",47,{"$f":"SUMIF($A$3:$A$7,\"Banana\",$B$3:$B$7)","v":82}," =SUMIF($A$3:$A$7,\"??n*\",$B$3:$B$7)","3rd Letter is N"]
[]
[]
[null,null,null," "]

{"sheet":"SumIF_Dates","index":117,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["SumIF Function",null,null,null,null,null,null,null,null,"Return To Index"]
["Date","Price","Result","Formula"]
["2021-01-26",48,{"$f":"SUMIF($A$3:$A$7,\">=\" & \"1/28/2021\",$B$3:$B$7)","v":184}," =SUMIF($A$3:$A$7,\">=\" & \"1/28/2021\",$B$3:$B$7)"]
["2021-01-29",35,{"$f":"SUMIF($A$3:$A$7,\"<=\" & \"1/28/2021\",$B$3:$B$7)","v":95}," =SUMIF($A$3:$A$7,\"<=\" & \"1/28/2021\",$B$3:$B$7)"]
["2021-01-30",47,{"$f":"SUMIF($A$3:$A$7,\"=\" & \"1/30/2021\",$B$3:$B$7)","v":47}," =SUMIF($A$3:$A$7,\"=\" & \"1/30/2021\",$B$3:$B$7)"]
["2021-01-31",55,{"$f":"SUMIF($A$3:$A$7,\">=\" & \"1/30/2021\",$B$3:$B$7)","v":102}," =SUMIF($A$3:$A$7,\">=\" & \"1/30/2021\",$B$3:$B$7)"]
["2021-01-28",47,{"$f":"SUMIF($A$3:$A$7,\">=\" & \"1/28/2021\",$B$3:$B$7)","v":184}," =SUMIF($A$3:$A$7,\">=\" & \"1/28/2021\",$B$3:$B$7)"]

{"sheet":"SumIF_Function","index":118,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["SumIF Function",null,null,null,null,null,null,null,null,"Return To Index"]
["Data","Price","Result","Formula"]
["Apple",48,{"$f":"SUMIF($A$3:$A$7,\"Apple\",$B$3:$B$7)","v":48}," =SUMIF($A$3:$A$7,\"Apple\",$B$3:$B$7)"]
["Banana",35,{"$f":"SUMIF($A$3:$A$7,\"Banana\",$B$3:$B$7)","v":90}," =SUMIF($A$3:$A$7,\"Banana\",$B$3:$B$7)"]
["Orange",47,{"$f":"SUMIF($A$3:$A$7,\"Orange\",$B$3:$B$7)","v":47}," =SUMIF($A$3:$A$7,\"Orange\",$B$3:$B$7)"]
["Banana",55,{"$f":"SUMIF($A$3:$A$7,\"Apple\",$B$3:$B$7)","v":48}," =SUMIF($A$3:$A$7,\"Apple\",$B$3:$B$7)"]
["Grapes",47,{"$f":"SUMIF($A$3:$A$7,\"Grapes\",$B$3:$B$7)","v":47}," =SUMIF($A$3:$A$7,\"Grapes\",$B$3:$B$7)"]

{"sheet":"SumIF_Multiple_Criteria_On_Col","index":119,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,3],[3,2,6,3]]}
["SumIF Function - Multiple Coditions on Single Column",null,null,null,null,null,null,null,null,"Return To Index"]
["Data","Price","Result","Formula"]
["Apple",48,{"$f":"SUMIF($A$3:$A$7,\"Apple\",$B$3:$B$7) + SUMIF($A$3:$A$7,\"Orange\",$B$3:$B$7)","v":138}]
["Apple",35," =SUMIF($A$3:$A$7,\"Apple\",$B$3:$B$7) \n+ \nSUMIF($A$3:$A$7,\"Orange\",$B$3:$B$7)"]
["Grapes",47]
["Orange",55]
["Banana",47]

{"sheet":"SumIFs_With_Dates","index":120,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,3],[3,2,6,2],[2,3,6,3]]}
["SumIFs Function with Multiple Criteria",null,null,null,null,null,null,null,null,"Return To Index"]
["Date","Price","Result","Formula"]
["2021-01-26",48,{"$f":"SUMIFS($B$3:$B$7, $A$3:$A$7,\">=\" & \"1/28/2021\", $A$3:$A$7,\"<=\" & \"1/30/2021\")","v":129}," =SUMIFS($B$3:$B$7, $A$3:$A$7,\">=\" & \n\"1/28/2021\", $A$3:$A$7,\"<=\" & \"1/30/2021\")"]
["2021-01-29",35]
["2021-01-30",47]
["2021-01-31",55]
["2021-01-28",47]

{"sheet":"Time_Add_Hrs_Mins_Secs","index":121,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Starting Time","Add - Hrs","Mins","Secs","Total","Formula",null,null,null,"Return To Index"]
["12:25:00",2,25,15,{"$f":"A2+TIME(B2,C2,D2)","v":"14:50:15"}," =A2+TIME(B2,C2,D2)"]
["13:25:00",3,55,25,{"$f":"A3+TIME(B3,C3,D3)","v":"17:20:25"}," =A3+TIME(B3,C3,D3)"]
["14:25:00",5,45,68,"20:11:08"," =A4+TIME(B4,C4,D4)"]
["00:02:00",5,24,25,"05:26:25"," =A5+TIME(B5,C5,D5)"]
["00:25:00",4,35,24,"05:00:24"," =A6+TIME(B6,C6,D6)"]
["14:25:00",2,36,65,"17:02:05"," =A7+TIME(B7,C7,D7)"]
["17:25:00",6,65,24,1.0211111111111113," =A8+TIME(B8,C8,D8)"]

{"sheet":"Trim","index":122,"n_rows":4,"n_cols":10,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Trim Function",null,null,null,null,null,null,null,null,"Return To Index"]
["Text","Result","Formula"]
[" Trim ",{"$f":"TRIM(A3)","v":"Trim"}," =TRIM(A3)"]
[" Both Sides Space ",{"$f":"TRIM(A4)","v":"Both Sides Space"}," =TRIM(A4)"]

{"sheet":"Trim_Remove_Space","index":123,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["TRIM Function",null,null,null,null,null,null,null,null,"Return To Index"]
["Before Trim","After Trim","Formula"]
["This is    Trim       Function",{"$f":"TRIM(A3)","v":"This is Trim Function"}," =TRIM(A3)"]
["This      is    Trim Function",{"$f":"TRIM(A4)","v":"This is Trim Function"}," =TRIM(A4)"]
["      This is    Trim       Function","This is Trim Function"," =TRIM(A5)"]
["This         is    Trim       Function","This is Trim Function"," =TRIM(A6)"]
["This    is    Trim       Fun      ction","This is Trim Fun ction"," =TRIM(A7)"]
["     This     is    Trim         Function","This is Trim Function"," =TRIM(A8)"]
["This         is    Trim       Function","This is Trim Function"," =TRIM(A9)"]

{"sheet":"Upper","index":124,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["UPPER Function",null,null,null,null,null,null,null,null,"Return To Index"]
["Fruits","Result","Formula"]
["Apple",{"$f":"UPPER(A3)","v":"APPLE"}," =UPPER(A3)"]
["Banana",{"$f":"UPPER(A4)","v":"BANANA"}," =UPPER(A4)"]
["Orange","ORANGE"," =UPPER(A5)"]
["Grapes","GRAPES"," =UPPER(A6)"]
["PineApple","PINEAPPLE"," =UPPER(A7)"]

{"sheet":"VLookup_Grades_With_ApproxMatch","index":125,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,4,0,6]]}
["Student","Marks","Grade",null,"Grade Table",null,null,null,null,"Return To Index"]
["A",95,{"$f":"VLOOKUP(B2,$E$3:$G$8,3,1)","v":"A+"},null,"From","To","Grade"]
["B",85,"A",null,0,35,"E"]
["C",70,"C",null,36,50,"D"]
["D",75,"B",null,51,70,"C"]
["E",55,"C",null,71,80,"B"]
["F",51,"C",null,81,90,"A"]
["G",50,"D",null,91,100,"A+"]
["H",18,"E"]
[]
[]
[null,null," =VLOOKUP(B2,$E$3:$G$8,3,1)"]

{"sheet":"VLookup_Match_Function_For_Col","index":126,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,"Return To Index"]
[null,"Company Name","Pens","Pencils","Erasers","Dusters"]
[null,"A",1100,{"$f":"C3+11","v":1111},{"$f":"D3+11","v":1122},1133]
[null,"B",1510,{"$f":"C4+11","v":1521},1532,1543]
[null,"C",1102,1113,1124,1135]
[null,"D",1103,1114,1125,1136]
[null,"E",1104,1115,1126,1137]
[null,"G",1105,1116,1127,1138]
[null,"G",1106,1117,1128,1139]
[null,"H",1107,1118,1129,1140]
[null,"I",1108,1119,1130,1141]
[]
[null,"Company","Product",null,"Output"]
[null,"B","Pencils",null,{"$f":"VLOOKUP(B14,$B$3:$F$11,MATCH(C14,B2:F2,0),FALSE)","v":1521}]
[null," =VLOOKUP(B14,$B$3:$F$11,MATCH(C14,B2:F2,0),FALSE)"]

{"sheet":"VLookup_TotalCost_Calculation","index":127,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,4,0,6]]}
["Fruits","Sales","Total Cost",null,"Salb Rates Table",null,null,null,null,"Return To Index"]
["Apple",100,{"$f":"VLOOKUP(B2,$E$3:$G$7,3)*B2","v":3000},null,"Min Pricing","Max Pricing","Price"]
["Banana",120,{"$f":"VLOOKUP(B3,$E$3:$G$7,3)*B3","v":4200},null,60,"Upto 60",15]
["Orange",125,4375,null,71,80,20]
["Grapes",65,975,null,81,90,25]
["PineApple",75,1500,null,91,100,30]
["Papaya",125,4375,null,101,"Above",35]
[]
[null,null," =VLOOKUP(B2,$E$3:$G$7,3)*B2"]

{"sheet":"Year","index":128,"n_rows":3,"n_cols":10,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["YEAR Function",null,null,null,null,null,null,null,null,"Return To Index"]
["Date","Result","Formula"]
["2021-01-20",{"$f":"YEAR(A3)","v":2021}," =YEAR(A3)"]

{"sheet":"Add_SerialNumbs_UsingIsBlank_IF","index":129,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["S.No","Fruit","Formula",null,null,null,null,null,null,"Return To Index"]
[100,"Apple","Type First serial number"]
[{"$f":"IF(ISBLANK(B3),\"\",A2+1)","v":101},"Banana"," =IF(ISBLANK(B3),\"\",A2+1)"]
[102,"Grapes"," =IF(ISBLANK(B4),\"\",A3+1)"]
[103,"Pineapple"," =IF(ISBLANK(B5),\"\",A4+1)"]
[104,"Orange"," =IF(ISBLANK(B6),\"\",A5+1)"]
[105,"Papaya"," =IF(ISBLANK(B7),\"\",A6+1)"]