Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Expenses calendar, FaCal Basic Math
  • Zipcode-State search Formulas - combined functions
  • LastSunday, LastSaturday Date and Time
  • Why I ran from =INDIRECT() function Formulas - combined functions
  • Highlight dates dynamically AND
  • Rotate table using 1 formula ADDRESS
  • Get 3rd Wednesday of month Basic Math
  • Sheet() and Sheets() Lookup and References

Tag: Non-Functions

Stale values (Scratched functions)

Posted on June 30, 2025 By ANmar No Comments on Stale values (Scratched functions)
Stale values (Scratched functions)

Excel recently started to show cells with formulas scratched (see screenshot). Looks like this new feature to tell user that these cells will have new values and they are in the process of getting calculated. If you want to disable that feature, uncheck “Show stale values” in “Calculation Options” in “Formula” bar (Screenshot)

Excel User tips, Format Cells, Non-functions, Worksheet

Show developer tab

Posted on February 16, 2018 By ANmar
Show developer tab

Starting Excel 2007, users are not getting easy access to developer stuff.

Not sure why is that, but we can go around that, so quickly, if you need to start developing inside Excel (using VBA) first thing to do is to show the “Developer” tab that came in hidden by default

Just follow on these steps

Read More “Show developer tab” »

Excel User tips, Non-functions

Excel sessions – 2013 VS 2010

Posted on June 9, 2017 By ANmar
Excel sessions – 2013 VS 2010

Excel 2010 was great because you can easily open another Excel session while your current session is working.

This allowed us to run multiple tools at the same time, since those two sessions are separated and do not touch.

However, starting Excel  2013, the interface changed, making it harder to run new session or open Excel while we have another Excel session running some long process.

Read More “Excel sessions – 2013 VS 2010” »

Excel User tips, Non-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
  • Recover the unrecoverable Excel User tips
  • UDF – Convert Number into text (English and Arabic) User-Defined f(x)s = UDF
  • Hello world! Uncategorized
  • Get column name (columnname as A,B,C, etc) as input inside cell ADDRESS
  • Lesson learned: Do not trust Google Sheets function Google Sheets
  • FORMULATEXT to show formulas FORMULATEXT
  • Looplist – Repeating months using formulas Basic Math
  • MID + SEARCH to convert cell to rows MID

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme