Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • VALUE() of LEFT() Formulas - combined functions
  • Get 3rd Wednesday of month Basic Math
  • VLookup Lookup and References
  • Why I ran from =INDIRECT() function Formulas - combined functions
  • Spreadsheet Compare application Excel User tips
  • FORMULATEXT to show formulas FORMULATEXT
  • Week number to Sunday date – Weeknum reverse DATE
  • Repeated Offset Basic Math

Tag: Excel2010

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
  • VLookup Lookup and References
  • Validation based on another Validation COUNTA
  • SimpleANBox Basic Math
  • Get column name (columnname as A,B,C, etc) as input inside cell ADDRESS
  • Convert cell into textbox Excel User tips
  • Filter. Google Sheets function Google Sheets
  • GoLast to jump to last cell in a column CELL
  • Cells with additional spaces AND

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme