Skip to content

Excel Functions

Excel f(x)s = Excel Functions

Stale values (Scratched functions) Excel User tips
Validation based on another Validation COUNTA
Excel @ before function names in formulas Excel User tips
Dynamic selection list ActiveX controls
Tally chart in functions Formulas - combined functions
Spreadsheet Compare application Excel User tips
CTRL+Y a mini macro Excel User tips
MID + SEARCH to convert cell to rows MID

When Excel tells you to go get some life

Posted on January 29, 2019 By ANmar

This is what happens when you spend too much time in Excel

Go have a break and get some life

Excel User tips, Non-functions, Worksheet

Post navigation

Previous Post: DayName

Next Post: Cell formats 0.0\% and 0.0%;(0.0%)

Related Posts

Shades of gray Graphics
Excel @ before function names in formulas Excel User tips
Custom fiscal year calendar (CFlex) Basic Math
Excel ad from early 90s Non-functions
Walking Columns ActiveX controls
Excel sessions – 2013 VS 2010 Excel User tips

Search for:

Recent Posts

Stale values (Scratched functions)
Middle name + 1st name
LastSunday, LastSaturday
Paste Special Percentage
Jan8 date format

Archives

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

Count Unique COUNTIF
CountIf limitation COUNTIF
Blank (isempty) VS “” (null string) Excel User tips
Standard math to calculate Aspect Ratio Basic Math
UDF – Convert Number into text (English and Arabic) User-Defined f(x)s = UDF
Insert Blank rows into table using functions CHAR
Filter. Google Sheets function Google Sheets
Count how many times letter found Formulas - combined functions

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme