Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Insert Blank rows into table using functions CHAR
  • Show developer tab Excel User tips
  • Searching table in 2 dimensions. Formulas - combined functions
  • Calculate hours between two cells ABS
  • CHOOSE – tree of decisions CHOOSE
  • Recover the unrecoverable Excel User tips
  • WorksheetName and WorksheetsNo UDFs Lookup and References
  • MID + SEARCH to convert cell to rows MID

Compare2, a tool to compare two sheets using formulas

Posted on December 5, 2018 By ANmar

Tool will compare between two sheets using formula/functions method.
Once you type in full folder locations (for both files), file names and sheets names in file1 and file2.

Make sure these two files are open, then sheet will be updated with comparison results, showing that every cell is checking for its equivalent addresses from both sheets in both files.

  • If cell in ‘Compare’ worksheet is blank, it means both equivalent cells in the two worksheets are blank.
  • If it is green ‘Y’, that means they are identical in value.
  • If it is red ‘N’, it means they are not equal/

 

 

 

 

 

 

 

 

 

 

 

 

 

Download Compare2
Excel Online

 

Conditional Formatting, Formulas - combined functions, IF, Logical, Standard functions

Post navigation

Previous Post: Edit directly in cell
Next Post: Custom fiscal year calendar (CFlex)

Related Posts

  • VALUE() of LEFT() Formulas - combined functions
  • Links between two workbooks – dynamically using functions INDIRECT
  • Walking Columns ActiveX controls
  • Min Max vehicle Formulas - combined functions
  • Limited Ceiling Basic Math
  • Fx to cut long column into two columns Formulas - combined functions

Recent Posts

  • Stale values (Scratched functions)
  • Middle name + 1st name
  • LastSunday, LastSaturday
  • Paste Special Percentage
  • Jan8 date format

Archives

Categories

  • Array formula (1)
  • Formulas – combined functions (58)
  • Google Sheets (2)
  • Non-functions (36)
    • ActiveX controls (2)
    • Conditional Formatting (7)
    • Data Validation (7)
    • Excel User tips (19)
    • Format Cells (6)
    • Graphics (4)
    • Names (3)
  • Standard functions (82)
    • Basic Math (18)
    • Date and Time (16)
      • DATE (9)
      • Hour (1)
      • MONTH (7)
      • NETWORKDAYS (2)
      • TODAY (7)
      • WEEKDAY (8)
      • WEEKNUM (1)
      • YEAR (8)
    • Engineering (1)
      • CONVERT (1)
    • Information (6)
      • CELL (4)
      • ISERROR (1)
      • N (1)
    • Logical (30)
      • AND (5)
      • IF (24)
      • IFERROR (6)
      • IFNA (1)
      • IFS (1)
      • ISERROR (1)
      • OR (2)
    • Lookup and References (36)
      • ADDRESS (4)
      • CHOOSE (3)
      • COLUMN (7)
      • FORMULATEXT (1)
      • HLOOKUP (1)
      • HYPERLINK (2)
      • INDEX (5)
      • INDIRECT (6)
      • MATCH (12)
      • OFFSET (15)
      • ROW (11)
      • VLOOKUP (5)
    • Math and Trig (24)
      • ABS (1)
      • CEILING (1)
      • COUNT (1)
      • COUNTA (4)
      • INT (9)
      • LARGE (2)
      • MAX (1)
      • Min (2)
      • SMALL (3)
      • SUM (3)
      • SUMIF (1)
      • SUMIFS (2)
      • SUMPRODUCT (1)
    • Statistical (5)
      • COUNTIF (4)
      • COUNTIFS (1)
    • Texts and Strings (24)
      • CHAR (5)
      • CONCATINATE (1)
      • FIND (1)
      • LEFT (8)
      • Len (4)
      • MID (9)
      • REPT (3)
      • RIGHT (2)
      • SEARCH (9)
      • STRING (1)
      • SUBSTITUTE (2)
      • TEXT (4)
      • TRIM (2)
      • VALUE (2)
  • Uncategorized (2)
  • User-Defined f(x)s = UDF (3)
    • HyperlinkOf (1)
  • Worksheet (16)
  • XLfxs (2)

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
  • Shapes with dynamic output Excel User tips
  • Extract current (Active) workbook name CELL
  • Text-to-Columns, dynamically using formulas IFERROR
  • Excel sessions – 2013 VS 2010 Excel User tips
  • Multiple Dual-Validations COUNTA
  • OFFSET+MATCH Formulas - combined functions
  • iframe in Excel (XLiFrame) ADDRESS
  • Count how many times letter found Formulas - combined functions

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme