Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Filter. Google Sheets function Google Sheets
  • Count Unique COUNTIF
  • SimpleANBox Basic Math
  • Get monthly total from table with dates DATE
  • Excel @ before function names in formulas Excel User tips
  • Recover the unrecoverable Excel User tips
  • Count cells with condition – multiple conditions COUNTIFS
  • Compare2, a tool to compare two sheets using formulas Conditional Formatting

Spreadsheet Compare application

Posted on October 25, 2022 By ANmar

This is only available in Microsoft 365 Enterprise version, an application that can compare two workbooks in all objects.

This includes cells (values or formulas) in all sheets, VBA objects and macros.

Bug: I noticed that even if VBE project in a workbook is protected, it will still open it and show you all macros, a bug I reported a while back to Microsoft.

Spreadsheet compare application in Office 365 Enterprise channel

Icon:
%ProgramFiles%\Microsoft Office\Root\VFS\Windows\Installer{90160000-000F-0000-1000-0000000FF1CE}\sscicons.exe,3

Application location and command:
"C:\Program Files\Microsoft Office\root\Client\AppVLP.exe" "C:\Program Files (x86)\Microsoft Office\Office16\DCF\SPREADSHEETCOMPARE.EXE"

More details on official link here …

https://support.microsoft.com/en-us/office/overview-of-spreadsheet-compare-13fafa61-62aa-451b-8674-242ce5f2c986

Excel User tips, Non-functions, Worksheet Tags:compare, spreadsheet, VBE

Post navigation

Previous Post: Repeated Offset
Next Post: Get 3rd Wednesday of month

Related Posts

  • Recover the unrecoverable Excel User tips
  • Stale values (Scratched functions) Excel User tips
  • Excel ad from early 90s Non-functions
  • Cell formats 0.0\% and 0.0%;(0.0%) Format Cells
  • Excel keeps converting all cells to “Date” (or Time) Excel User tips
  • Highlight dates dynamically AND

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
  • 0% interest promotion Basic Math
  • Week number to Sunday date – Weeknum reverse DATE
  • Cuts string of list of items Formulas - combined functions
  • FORMULATEXT to show formulas FORMULATEXT
  • Walking Columns ActiveX controls
  • Formula Beautifier Excel User tips
  • Extract Address into table Formulas - combined functions
  • Sum of divide – Array formula Array formula

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme