Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Get column name (columnname as A,B,C, etc) as input inside cell ADDRESS
  • Week number to Month number DATE
  • Repeated Offset Basic Math
  • Tally chart in functions Formulas - combined functions
  • Jan8 date format AND
  • Multiple Dual-Validations COUNTA
  • Paste Special Percentage Excel User tips
  • Searching table in 2 dimensions. Formulas - combined functions

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

  • Sheet() and Sheets() Lookup and References
  • Pixel Excel Drawing Format Cells
  • Recover the unrecoverable Excel User tips
  • When Excel tells you to go get some life Excel User tips
  • Shapes with dynamic output Excel User tips
  • The Excel “&” bug Excel User tips

Recent Posts

  • Calculate above and below me
  • Stale values (Scratched functions)
  • Middle name + 1st name
  • LastSunday, LastSaturday
  • Paste Special Percentage

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 (83)
    • 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 (31)
      • AND (5)
      • IF (25)
      • IFERROR (7)
      • 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 (6)
      • Average (1)
      • 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
  • Count how many times letter found Formulas - combined functions
  • Searching table in 2 dimensions. Formulas - combined functions
  • Always get 1st name (or last) Formulas - combined functions
  • Tally chart in functions Formulas - combined functions
  • Excel Limits Excel User tips
  • iframe in Excel (XLiFrame) ADDRESS
  • Unix DateTime Number Basic Math

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme