Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Min Max vehicle Formulas - combined functions
  • Why I ran from =INDIRECT() function Formulas - combined functions
  • Tally chart in functions Formulas - combined functions
  • OFFSET+MATCH Formulas - combined functions
  • Worksheet name, dynamically using formula CELL
  • Week number to Sunday date – Weeknum reverse DATE
  • Cell formats 0.0\% and 0.0%;(0.0%) Format Cells
  • CONVERT function CONVERT

Tag: spreadsheet

Spreadsheet Compare application

Posted on October 25, 2022 By ANmar
Spreadsheet Compare application

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,…

Read More “Spreadsheet Compare application” »

Excel User tips, Non-functions, Worksheet

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
  • Cuts string of list of items Formulas - combined functions
  • LastSunday, LastSaturday Date and Time
  • Sorting with functions only CHOOSE
  • Blank (isempty) VS “” (null string) Excel User tips
  • GoLast to jump to last cell in a column CELL
  • Multiple Dual-Validations COUNTA
  • Middle name + 1st name Basic Math
  • Standard math to calculate Aspect Ratio Basic Math

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme