{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Home Page","Overview","Row by Row (Numeric)","Row by Row (Text String)","Comparing Dates","Multiple Columns","2 Columns Similarity,Difference","Pulling Matched Data","Highlighting Using CF","Comparing Any Cells","ComparingSheets_1","ComparingSheets_2","ComparingWorkbooks_1","Statistical Compariosn","Comparing Using VBA"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Home Page","index":0,"n_rows":34,"n_cols":3,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"Compare in Excel"]
[]
[null,"Learn how to Compare in Excel with this free workbook. Read the article we provided and practice these in the practice section."]
[]
[]
[null,"Prepared By"," Md Nafis Soumik"]
[null,"Reviewed By","Aung Shine"]
[null,"Last Update","2023-11-27"]
[null,"Article Link","Compare in Excel"]
[]
[null,"Examples"]
[]
[null,"1. Compare Two Columns Row-by-Row in Excel"]
[null,"  1.1 Compare Numeric Values"]
[null,"  1.2 Compare Text Strings (Case Sensitive/Insensitive) "]
[null,"  1.3 Comparing 2 Columns Containing Dates"]
[null,"2. Compare Multiple Columns for Row Matches"]
[null,"3. Compare Two Lists for Similarities and Differences"]
[null,"4. Compare Two Lists and Pulling Matched Data"]
[null,"5. Compare and Highlight Row Similarities and Differences"]
[null,"6. Compare Any 2 Cells and Writing Remarks"]
[null,"7. Comparing 2 Columns in Different Sheets"]
[null,"8. Comparing 2 Different Workbooks"]
[null,"9. Statistical Comparison in Excel"]
[null,"10. Comparing 2 Columns Using VBA"]
[]
[]
[]
[null,"Copyright © 2013-2023 ExcelDemy.com | All rights reserved."]

{"sheet":"Overview","index":1,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Compare in Excel"]
[]
[null,"Available in Store",null,"Ordered Products","Remarks"]
[null,"Smartphone",null,"Laptop",{"$f":"IF(COUNTIF($B:$B, $D5)=0, \"Not Available\", \"Available\")","v":"Available"}]
[null,"Laptop",null,"Smartphone",{"$f":"IF(COUNTIF($B:$B, $D6)=0, \"Not Available\", \"Available\")","v":"Available"}]
[null,"Gaming Console",null,"Smart TV",{"$f":"IF(COUNTIF($B:$B, $D7)=0, \"Not Available\", \"Available\")","v":"Not Available"}]
[null,"Tablet",null,"Digital Camera",{"$f":"IF(COUNTIF($B:$B, $D8)=0, \"Not Available\", \"Available\")","v":"Not Available"}]
[null,"Smartwatch",null,"Gaming Console",{"$f":"IF(COUNTIF($B:$B, $D9)=0, \"Not Available\", \"Available\")","v":"Available"}]
[null,null,null,"Wireless Headphones",{"$f":"IF(COUNTIF($B:$B, $D10)=0, \"Not Available\", \"Available\")","v":"Not Available"}]
[null,null,null,"Fitness Tracker",{"$f":"IF(COUNTIF($B:$B, $D11)=0, \"Not Available\", \"Available\")","v":"Not Available"}]
[null,null,null,"Tablet",{"$f":"IF(COUNTIF($B:$B, $D12)=0, \"Not Available\", \"Available\")","v":"Available"}]
[null,null,null,"Smartwatch",{"$f":"IF(COUNTIF($B:$B, $D13)=0, \"Not Available\", \"Available\")","v":"Available"}]
[null,null,null,"Desktop Computer",{"$f":"IF(COUNTIF($B:$B, $D14)=0, \"Not Available\", \"Available\")","v":"Not Available"}]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Row by Row (Numeric)","index":2,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Compare in Excel",null,null,null,null,null,"Compare in Excel"]
[]
[null,"Comparing Two Columns Row-by-Row (Numeric Values)",null,null,null,null,null,"Do It Yourself"]
[]
[null,"Electronic Product","Previous Price","Current Price","Remarks",null,null,"Electronic Product","Previous Price","Current Price","Remarks"]
[null,"Laptop",800,900,{"$f":"IF(C7=D7,\"No Change\",\"Change\")","v":"Change"},null,null,"Laptop",800,900]
[null,"Smartphone",700,800,{"$f":"IF(C8=D8,\"No Change\",\"Change\")","v":"Change"},null,null,"Smartphone",700,800]
[null,"Smart TV",1200,1200,"No Change",null,null,"Smart TV",1200,1200]
[null,"Digital Camera",400,450,"Change",null,null,"Digital Camera",400,450]
[null,"Gaming Console",300,400,"Change",null,null,"Gaming Console",300,400]
[null,"Wireless Headphones",150,150,"No Change",null,null,"Wireless Headphones",150,150]
[null,"Fitness Tracker",120,120,"No Change",null,null,"Fitness Tracker",120,120]
[null,"Tablet",400,350,"Change",null,null,"Tablet",400,350]
[null,"Smartwatch",250,280,"Change",null,null,"Smartwatch",250,280]
[null,"Desktop Computer",1000,1200,"Change",null,null,"Desktop Computer",1000,1200]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Row by Row (Text String)","index":3,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Compare in Excel",null,null,null,null,null,"Compare in Excel"]
[]
[null,"Comparing Two Columns Row-by-Row (Text Strings)",null,null,null,null,null,"Do It Yourself"]
[]
[null,"Brand","Owner","Case-Insensitive","Case-Sensitive",null,null,"Brand","Owner","Case-Insensitive","Case-Sensitive"]
[null,"FORD","FORD",{"$f":"IF(B7=C7,\"Match\",\"No Match\")","v":"Match"},{"$f":"IF(EXACT(B7,C7),\"Match\",\"No Match\")","v":"Match"},null,null,"FORD","FORD"]
[null,"DISNEY","Disney",{"$f":"IF(B8=C8,\"Match\",\"No Match\")","v":"Match"},{"$f":"IF(EXACT(B8,C8),\"Match\",\"No Match\")","v":"No Match"},null,null,"DISNEY","Disney"]
[null,"FERRARI","Ferari","No Match","No Match",null,null,"FERRARI","Ferari"]
[null,"HONDA","HONDA","Match","Match",null,null,"HONDA","HONDA"]
[null,"BOEING","Boeing","Match","No Match",null,null,"BOEING","Boeing"]
[null,"McDONALD's","mcDonalds","No Match","No Match",null,null,"McDONALD's","mcDonalds"]
[null,"MARCEDES-BENZ","Marcedes-Benz","Match","No Match",null,null,"MARCEDES-BENZ","Marcedes-Benz"]
[null,"PORSCHE","Porshe","No Match","No Match",null,null,"PORSCHE","Porshe"]
[null,"CHANEL","CHANEL","Match","Match",null,null,"CHANEL","CHANEL"]
[null,"DELL","Dell","Match","No Match",null,null,"DELL","Dell"]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Comparing Dates","index":4,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Compare in Excel",null,null,null,null,null,"Compare in Excel"]
[]
[null,"Comparing 2 Columns Containing Dates",null,null,null,null,null,"Do It Yourself"]
[]
[null,"Project Name","Submission Date","Due Date","Remarks",null,null,"Project Name","Submission Date","Due Date","Remarks"]
[null,"QuantumLeap","2023-01-15","2023-02-28",{"$f":"IF(C7>D7,\"Delayed\",\"On Time\")","v":"On Time"},null,null,"QuantumLeap","2023-01-15","2023-02-28"]
[null,"SolarHarmony","2023-04-04","2023-03-15",{"$f":"IF(C8>D8,\"Delayed\",\"On Time\")","v":"Delayed"},null,null,"SolarHarmony","2023-04-04","2023-03-15"]
[null,"CyberVanguard","2023-03-12","2023-04-25","On Time",null,null,"CyberVanguard","2023-03-12","2023-04-25"]
[null,"BioNexus","2023-04-08","2023-05-20","On Time",null,null,"BioNexus","2023-04-08","2023-05-20"]
[null,"AeroSphere","2023-07-22","2023-06-30","Delayed",null,null,"AeroSphere","2023-07-22","2023-06-30"]
[null,"EchoSynergy","2023-08-10","2023-07-18","Delayed",null,null,"EchoSynergy","2023-08-10","2023-07-18"]
[null,"DataPinnacle","2023-07-05","2023-08-12","On Time",null,null,"DataPinnacle","2023-07-05","2023-08-12"]
[null,"RoboCatalyst","2023-08-15","2023-09-28","On Time",null,null,"RoboCatalyst","2023-08-15","2023-09-28"]
[null,"AquaInnovate","2023-11-01","2023-10-15","Delayed",null,null,"AquaInnovate","2023-11-01","2023-10-15"]
[null,"GalacticFrontier","2023-10-18","2023-11-30","On Time",null,null,"GalacticFrontier","2023-10-18","2023-11-30"]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Multiple Columns","index":5,"n_rows":20,"n_cols":13,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Compare in Excel",null,null,null,null,null,null,"Compare in Excel"]
[]
[null,"Comparing Multiple Columns for Row Matches",null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Electronic Product","Price (2021)","Price (2022)","Price (2023)","Remarks",null,null,"Electronic Product","Price (2021)","Price (2022)","Price (2023)","Remarks"]
[null,"Laptop",800,900,950,{"$f":"_xlfn.IFS(AND(C7<>D7,D7<>E7,C7<>E7),\"Unstable\",AND(C7=D7,D7=E7,C7=E7),\"Fully Stable\",OR(C16=D16,D16=E16,C16=E16),\"Almost Stable\")","v":"Unstable"},null,null,"Laptop",800,900,950]
[null,"Smartphone",700,800,800,{"$f":"_xlfn.IFS(AND(C8<>D8,D8<>E8,C8<>E8),\"Unstable\",AND(C8=D8,D8=E8,C8=E8),\"Fully Stable\",OR(C17=D17,D17=E17,C17=E17),\"Almost Stable\")","v":"Almost Stable"},null,null,"Smartphone",700,800,800]
[null,"Smart TV",1200,1200,1250,{"$f":"_xlfn.IFS(AND(C9<>D9,D9<>E9,C9<>E9),\"Unstable\",AND(C9=D9,D9=E9,C9=E9),\"Fully Stable\",OR(C18=D18,D18=E18,C18=E18),\"Almost Stable\")","v":"Almost Stable"},null,null,"Smart TV",1200,1200,1250]
[null,"Digital Camera",400,450,500,{"$f":"_xlfn.IFS(AND(C10<>D10,D10<>E10,C10<>E10),\"Unstable\",AND(C10=D10,D10=E10,C10=E10),\"Fully Stable\",OR(C19=D19,D19=E19,C19=E19),\"Almost Stable\")","v":"Unstable"},null,null,"Digital Camera",400,450,500]
[null,"Gaming Console",300,400,400,{"$f":"_xlfn.IFS(AND(C11<>D11,D11<>E11,C11<>E11),\"Unstable\",AND(C11=D11,D11=E11,C11=E11),\"Fully Stable\",OR(C20=D20,D20=E20,C20=E20),\"Almost Stable\")","v":"Almost Stable"},null,null,"Gaming Console",300,400,400]
[null,"Wireless Headphones",150,150,200,{"$f":"_xlfn.IFS(AND(C12<>D12,D12<>E12,C12<>E12),\"Unstable\",AND(C12=D12,D12=E12,C12=E12),\"Fully Stable\",OR(C21=D21,D21=E21,C21=E21),\"Almost Stable\")","v":"Almost Stable"},null,null,"Wireless Headphones",150,150,200]
[null,"Fitness Tracker",120,120,120,{"$f":"_xlfn.IFS(AND(C13<>D13,D13<>E13,C13<>E13),\"Unstable\",AND(C13=D13,D13=E13,C13=E13),\"Fully Stable\",OR(C22=D22,D22=E22,C22=E22),\"Almost Stable\")","v":"Fully Stable"},null,null,"Fitness Tracker",120,120,120]
[null,"Tablet",400,350,300,{"$f":"_xlfn.IFS(AND(C14<>D14,D14<>E14,C14<>E14),\"Unstable\",AND(C14=D14,D14=E14,C14=E14),\"Fully Stable\",OR(C23=D23,D23=E23,C23=E23),\"Almost Stable\")","v":"Unstable"},null,null,"Tablet",400,350,300]
[null,"Smartwatch",250,280,300,{"$f":"_xlfn.IFS(AND(C15<>D15,D15<>E15,C15<>E15),\"Unstable\",AND(C15=D15,D15=E15,C15=E15),\"Fully Stable\",OR(C24=D24,D24=E24,C24=E24),\"Almost Stable\")","v":"Unstable"},null,null,"Smartwatch",250,280,300]
[null,"Desktop Computer",1200,1200,1200,{"$f":"_xlfn.IFS(AND(C16<>D16,D16<>E16,C16<>E16),\"Unstable\",AND(C16=D16,D16=E16,C16=E16),\"Fully Stable\",OR(C25=D25,D25=E25,C25=E25),\"Almost Stable\")","v":"Fully Stable"},null,null,"Desktop Computer",1200,1200,1200]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"2 Columns Similarity,Difference","index":6,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Compare in Excel",null,null,null,null,null,"Compare in Excel"]
[]
[null,"Comparing Two Lists for Similarities and Differences",null,null,null,null,null,"Do It Yourself"]
[]
[null,"Available in Store",null,"Ordered Products","Remarks",null,null,"Available in Store",null,"Electronic Product","Remarks"]
[null,"Smartphone",null,"Laptop",{"$f":"IF(COUNTIF($B:$B, $D7)=0, \"Not Available\", \"Available\")","v":"Available"},null,null,"Smartphone",null,"Laptop"]
[null,"Laptop",null,"Smartphone",{"$f":"IF(COUNTIF($B:$B, $D8)=0, \"Not Available\", \"Available\")","v":"Available"},null,null,"Laptop",null,"Smartphone"]
[null,"Gaming Console",null,"Smart TV","Available",null,null,"Gaming Console",null,"Smart TV"]
[null,"Tablet",null,"Digital Camera","Not Available",null,null,"Tablet",null,"Digital Camera"]
[null,"Smartwatch",null,"Gaming Console","Available",null,null,"Smartwatch",null,"Gaming Console"]
[null,"Smart TV",null,"Wireless Headphones","Not Available",null,null,null,null,"Wireless Headphones"]
[null,"Fitness Tracker",null,"Fitness Tracker","Available",null,null,null,null,"Fitness Tracker"]
[null,null,null,"Tablet","Available",null,null,null,null,"Tablet"]
[null,null,null,"Smartwatch","Available",null,null,null,null,"Smartwatch"]
[null,null,null,"Desktop Computer","Not Available",null,null,null,null,"Desktop Computer"]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Pulling Matched Data","index":7,"n_rows":45,"n_cols":14,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Compare in Excel",null,null,null,null,null,null,null,"Compare in Excel"]
[]
[null,"Comparing Two Lists and \nPulling Matched Data",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Electronic Product","Price",null,"Search Product","Price",null,null,null,"Electronic Product","Price",null,"Search Product","Price"]
[null,"Laptop",800,null,"Fitness Tracker",{"$f":"VLOOKUP(E7,B7:C16,2,FALSE)","v":120},null,null,null,"Laptop",800,null,"Wireless Headphones"]
[null,"Smartphone",700,null,null,null,null,null,null,"Smartphone",700]
[null,"Smart TV",1200,null,null,null,null,null,null,"Smart TV",1200]
[null,"Digital Camera",400,null,null,null,null,null,null,"Digital Camera",400]
[null,"Gaming Console",300,null,null,null,null,null,null,"Gaming Console",300]
[null,"Wireless Headphones",150,null,null,null,null,null,null,"Wireless Headphones",150]
[null,"Fitness Tracker",120,null,null,null,null,null,null,"Fitness Tracker",120]
[null,"Tablet",400,null,null,null,null,null,null,"Tablet",400]
[null,"Smartwatch",250,null,null,null,null,null,null,"Smartwatch",250]
[null,"Desktop Computer",1200,null,null,null,null,null,null,"Desktop Computer",1200]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]
[]
[]
[null,"List of All Items "]
[null,"Laptop"]
[null,"Smartphone"]
[null,"Smart TV"]
[null,"Digital Camera"]
[null,"Gaming Console"]
[null,"Wireless Headphones"]
[null,"Fitness Tracker"]
[null,"Tablet"]
[null,"Smartwatch"]
[null,"Desktop Computer"]
[null,"Smart Refrigerator"]
[null,"4K Ultra HD Smart TV"]
[null,"Wireless Bluetooth Speaker"]
[null,"Robot Vacuum Cleaner"]
[null,"DSLR Camera"]
[null,"Gaming Laptop"]
[null,"Fitness Smartwatch"]
[null,"Noise-Canceling Headphones"]
[null,"Home Security Camera System"]
[null,"Portable Solar Charger"]

{"sheet":"Highlighting Using CF","index":8,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Compare in Excel",null,null,null,null,"Compare in Excel"]
[]
[null,"Comparing and Highlighting Similarities and Differences",null,null,null,null,"Do It Yourself"]
[]
[null,"Electronic Product","Previous Price","Current Price",null,null,"Electronic Product","Previous Price","Current Price"]
[null,"Laptop",800,900,null,null,"Laptop",800,900]
[null,"Smartphone",500,800,null,null,"Smartphone",500,800]
[null,"Smart TV",1200,1200,null,null,"Smart TV",1200,1200]
[null,"Digital Camera",400,450,null,null,"Digital Camera",400,450]
[null,"Gaming Console",300,400,null,null,"Gaming Console",300,400]
[null,"Wireless Headphones",150,150,null,null,"Wireless Headphones",150,150]
[null,"Fitness Tracker",120,120,null,null,"Fitness Tracker",120,120]
[null,"Tablet",400,350,null,null,"Tablet",400,350]
[null,"Smartwatch",250,280,null,null,"Smartwatch",250,280]
[null,"Desktop Computer",1200,1200,null,null,"Desktop Computer",1200,1200]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Comparing Any Cells","index":9,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Compare in Excel",null,null,null,"Compare in Excel"]
[]
[null,"Comparing Any 2 Cells and Writing Remarks",null,null,null,"Doi It Yourself"]
[]
[null,"Electronic Product","Monthly Sales",null,null,"Electronic Product","Monthly Sales"]
[null,"Laptop",{"$f":"3200","v":3200},null,null,"Laptop",{"$f":"3200","v":3200}]
[null,"Smartphone",2800,null,null,"Smartphone",2800]
[null,"Smart TV",4800,null,null,"Smart TV",4800]
[null,"Digital Camera",1600,null,null,"Digital Camera",1600]
[null,"Gaming Console",1200,null,null,"Gaming Console",1200]
[null,"Wireless Headphones",600,null,null,"Wireless Headphones",600]
[null,"Fitness Tracker",480,null,null,"Fitness Tracker",480]
[null,"Tablet",1600,null,null,"Tablet",1600]
[null,"Smartwatch",1000,null,null,"Smartwatch",1000]
[null,"Desktop Computer",4000,null,null,"Desktop Computer",4000]
[]
[null,"Maximum Sales",{"$f":"MAX(C7:C16)","v":4800},{"$f":"_xlfn.FORMULATEXT(C18)","v":"=MAX(C7:C16)"},null,"Maximum Sales",{"$f":"MAX(G7:G16)","v":4800},{"$f":"_xlfn.FORMULATEXT(G18)","v":"=MAX(G7:G16)"}]
[null,"Product","Smart TV",null,null,"Product","Gaming Console"]
[null,{"$f":"C19 & \" Provided Max Sales?\"","v":"Smart TV Provided Max Sales?"},{"$f":"IF(VLOOKUP(C19,B7:C16,2,FALSE)=C18,\"Yes\", \"No\")","v":"Yes"},null,null,{"$f":"G19 & \" Provided Max Sales?\"","v":"Gaming Console Provided Max Sales?"}]
[]
[null,"Back to Home Page"]

{"sheet":"ComparingSheets_1","index":10,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Compare in Excel",null,null,null,null,"Compare in Excel"]
[]
[null,"Comparing 2 Cells in Different Sheets (Previous Price)",null,null,null,null,"Do It Yourself"]
[]
[null,"Electronic Product","Previous Price","Price Changes?",null,null,"Electronic Product","Previous Price","Price Changes?"]
[null,"Laptop",800,{"$f":"IF(ComparingSheets_1!C7=ComparingSheets_2!C7, \"NO\",\"YES\")","v":"YES"},null,null,"Laptop",800]
[null,"Smartphone",700,{"$f":"IF(ComparingSheets_1!C8=ComparingSheets_2!C8, \"NO\",\"YES\")","v":"YES"},null,null,"Smartphone",700]
[null,"Smart TV",1200,{"$f":"IF(ComparingSheets_1!C9=ComparingSheets_2!C9, \"NO\",\"YES\")","v":"NO"},null,null,"Smart TV",1200]
[null,"Digital Camera",400,{"$f":"IF(ComparingSheets_1!C10=ComparingSheets_2!C10, \"NO\",\"YES\")","v":"YES"},null,null,"Digital Camera",400]
[null,"Gaming Console",300,{"$f":"IF(ComparingSheets_1!C11=ComparingSheets_2!C11, \"NO\",\"YES\")","v":"YES"},null,null,"Gaming Console",300]
[null,"Wireless Headphones",150,{"$f":"IF(ComparingSheets_1!C12=ComparingSheets_2!C12, \"NO\",\"YES\")","v":"NO"},null,null,"Wireless Headphones",150]
[null,"Fitness Tracker",120,{"$f":"IF(ComparingSheets_1!C13=ComparingSheets_2!C13, \"NO\",\"YES\")","v":"NO"},null,null,"Fitness Tracker",120]
[null,"Tablet",400,{"$f":"IF(ComparingSheets_1!C14=ComparingSheets_2!C14, \"NO\",\"YES\")","v":"YES"},null,null,"Tablet",400]
[null,"Smartwatch",280,{"$f":"IF(ComparingSheets_1!C15=ComparingSheets_2!C15, \"NO\",\"YES\")","v":"NO"},null,null,"Smartwatch",280]
[null,"Desktop Computer",1200,{"$f":"IF(ComparingSheets_1!C16=ComparingSheets_2!C16, \"NO\",\"YES\")","v":"NO"},null,null,"Desktop Computer",1200]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"ComparingSheets_2","index":11,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Compare in Excel",null,null,null,null,"Compare in Excel"]
[]
[null,"Comparing 2 Cells in Different Sheets (Current Price)",null,null,null,null,"Do It Yourself"]
[]
[null,"Electronic Product","Current Price","Price Changed?",null,null,"Electronic Product","Current Price","Price Changed?"]
[null,"Laptop",900,{"$f":"IF(C7=ComparingSheets_1!C7,\"No\",\"YES\")","v":"YES"},null,null,"Laptop",900]
[null,"Smartphone",800,{"$f":"IF(C8=ComparingSheets_1!C8,\"No\",\"YES\")","v":"YES"},null,null,"Smartphone",800]
[null,"Smart TV",1200,{"$f":"IF(C9=ComparingSheets_1!C9,\"No\",\"YES\")","v":"No"},null,null,"Smart TV",1200]
[null,"Digital Camera",450,{"$f":"IF(C10=ComparingSheets_1!C10,\"No\",\"YES\")","v":"YES"},null,null,"Digital Camera",450]
[null,"Gaming Console",400,{"$f":"IF(C11=ComparingSheets_1!C11,\"No\",\"YES\")","v":"YES"},null,null,"Gaming Console",400]
[null,"Wireless Headphones",150,{"$f":"IF(C12=ComparingSheets_1!C12,\"No\",\"YES\")","v":"No"},null,null,"Wireless Headphones",150]
[null,"Fitness Tracker",120,{"$f":"IF(C13=ComparingSheets_1!C13,\"No\",\"YES\")","v":"No"},null,null,"Fitness Tracker",120]
[null,"Tablet",350,{"$f":"IF(C14=ComparingSheets_1!C14,\"No\",\"YES\")","v":"YES"},null,null,"Tablet",350]
[null,"Smartwatch",280,{"$f":"IF(C15=ComparingSheets_1!C15,\"No\",\"YES\")","v":"No"},null,null,"Smartwatch",280]
[null,"Desktop Computer",1200,{"$f":"IF(C16=ComparingSheets_1!C16,\"No\",\"YES\")","v":"No"},null,null,"Desktop Computer",1200]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"ComparingWorkbooks_1","index":12,"n_rows":20,"n_cols":3,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Compare in Excel"]
[]
[null,"Comparing 2 Different Workbooks (Previous Price)"]
[]
[null,"Electronic Product","Previous Price"]
[null,"Laptop",800]
[null,"Smartphone",700]
[null,"Smart TV",1200]
[null,"Digital Camera",400]
[null,"Gaming Console",300]
[null,"Wireless Headphones",150]
[null,"Fitness Tracker",120]
[null,"Tablet",400]
[null,"Smartwatch",280]
[null,"Desktop Computer",1200]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Statistical Compariosn","index":13,"n_rows":27,"n_cols":13,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Compare in Excel",null,null,null,null,null,null,"Compare in Excel"]
[]
[null,"Statistical Comparison",null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Month","Sales Quantity (Wired Headphones)","Sales Quantity (Wireless Headphones)",null,null,null,null,"Month","Sales Quantity (Wired Headphones)","Sales Quantity (Wireless Headphones)"]
[null,"January",50,60,null,null,null,null,"January",50,60]
[null,"February",40,70,null,null,null,null,"February",40,70]
[null,"March",35,75,null,null,null,null,"March",35,75]
[null,"April",20,80,null,null,null,null,"April",20,80]
[null,"May",25,90,null,null,null,null,"May",25,90]
[null,"June",40,100,null,null,null,null,"June",40,100]
[]
[null,"Statistical Parameters","Sales Quantity (Wired Headphones)","Formula (Wired Headphones)","Sales Quantity (Wireless Headphones)","Formula (Wireless Headphones)",null,null,"Statistical Parameters","Sales Quantity (Wired Headphones)","Formula (Wired Headphones)","Sales Quantity (Wireless Headphones)","Formula (Wireless Headphones)"]
[null,"Mean",{"$f":"AVERAGE(C7:C12)","v":35},{"$f":"_xlfn.FORMULATEXT(C15)","v":"=AVERAGE(C7:C12)"},{"$f":"AVERAGE(D7:D12)","v":79.166666666666671},{"$f":"_xlfn.FORMULATEXT(E15)","v":"=AVERAGE(D7:D12)"},null,null,"Mean",{"$f":"AVERAGE(J7:J12)","v":35},{"$f":"_xlfn.FORMULATEXT(J15)","v":"=AVERAGE(J7:J12)"},{"$f":"AVERAGE(K7:K12)","v":79.166666666666671},{"$f":"_xlfn.FORMULATEXT(L15)","v":"=AVERAGE(K7:K12)"}]
[null,"Standard Deviation",{"$f":"_xlfn.STDEV.S(C7:C12)","v":10.954451150103322},{"$f":"_xlfn.FORMULATEXT(C16)","v":"=STDEV.S(C7:C12)"},{"$f":"_xlfn.STDEV.S(D7:D12)","v":14.288690166235222},"=STDEV.S(D7:D12)",null,null,"Standard Deviation",{"$f":"_xlfn.STDEV.S(J7:J12)","v":10.954451150103322},{"$f":"_xlfn.FORMULATEXT(J16)","v":"=STDEV.S(J7:J12)"},{"$f":"_xlfn.STDEV.S(K7:K12)","v":14.288690166235222},{"$f":"_xlfn.FORMULATEXT(L16)","v":"=STDEV.S(K7:K12)"}]
[null,"Coefficient of Variation",{"$f":"C16/C15","v":0.31298431857438064},"=C16/C15",{"$f":"E16/E15","v":0.180488717889287},"=E16/E15",null,null,"Coefficient of Variation",{"$f":"J16/J15","v":0.31298431857438064},"=J16/J15",{"$f":"L16/L15","v":0.180488717889287},"=L16/L15"]
[null,"Range",{"$f":"MAX(C7:C12)-MIN(C7:C12)","v":30},"=MAX(C7:C12)-MIN(C7:C12)",{"$f":"MAX(D7:D12)-MIN(D7:D12)","v":40},"=MAX(D7:D12)-MIN(D7:D12)",null,null,"Range",{"$f":"MAX(J7:J12)-MIN(J7:J12)","v":30},"=MAX(J7:J12)-MIN(J7:J12)",{"$f":"MAX(K7:K12)-MIN(K7:K12)","v":40},"=MAX(K7:K12)-MIN(K7:K12)"]
[]
[null,"Statistical Parameters","Greater Value",null,null,null,null,null,"Statistical Parameters","Greater Value"]
[null,"Mean",{"$f":"IF(C15>E15, \"Wired Headphones\", \"Wireless Headphones\")","v":"Wireless Headphones"},null,null,null,null,null,"Mean"]
[null,"Standard Deviation",{"$f":"IF(C16>E16, \"Wired Headphones\", \"Wireless Headphones\")","v":"Wireless Headphones"},null,null,null,null,null,"Standard Deviation"]
[null,"Coefficient of Variation",{"$f":"IF(C17>E17, \"Wired Headphones\", \"Wireless Headphones\")","v":"Wired Headphones"},null,null,null,null,null,"Coefficient of Variation"]
[null,"Range",{"$f":"IF(C18>E18, \"Wired Headphones\", \"Wireless Headphones\")","v":"Wireless Headphones"},null,null,null,null,null,"Range"]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Comparing Using VBA","index":14,"n_rows":20,"n_cols":25,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Compare in Excel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Compare in Excel"]
[]
[null,"Comparing 2 Columns Using VBA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Do It Yourself (Modify the Code for Cell Reference)"]
[]
[null,"Electronic Product","Previous Price","Current Price","Remarks",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Electronic Product","Previous Price","Current Price","Remarks"]
[null,"Laptop",800,900,"Changed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Laptop",800,900]
[null,"Smartphone",700,800,"Changed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Smartphone",700,800]
[null,"Smart TV",1200,1200,"Not Changed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Smart TV",1200,1200]
[null,"Digital Camera",400,450,"Changed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Digital Camera",400,450]
[null,"Gaming Console",300,400,"Changed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gaming Console",300,400]
[null,"Wireless Headphones",150,150,"Not Changed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wireless Headphones",150,150]
[null,"Fitness Tracker",120,120,"Not Changed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fitness Tracker",120,120]
[null,"Tablet",400,350,"Changed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tablet",400,350]
[null,"Smartwatch",250,280,"Changed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Smartwatch",250,280]
[null,"Desktop Computer",1200,1200,"Not Changed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Desktop Computer",1200,1200]
[]
[]
[]
[null,"Back to Home Page"]