Skip to content

Excel Functions

Excel f(x)s = Excel Functions

Custom fiscal year calendar (CFlex) Basic Math
Validation based on another Validation COUNTA
Always get 1st name (or last) Formulas - combined functions
Sorting with functions only CHOOSE
UDF – Convert Number into text (English and Arabic) User-Defined f(x)s = UDF
Search across sheets in function ADDRESS
Skills Grid Conditional Formatting
WorksheetName and WorksheetsNo UDFs Lookup and References

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

Blank (isempty) VS “” (null string) Excel User tips
Custom fiscal year calendar (CFlex) Basic Math
SimpleANBox Basic Math
WorksheetName and WorksheetsNo UDFs Lookup and References
Skills Grid Conditional Formatting
Edit directly in cell 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

Get 3rd Wednesday of month Basic Math
Return 12 values in one number AND
Multiple Dual-Validations COUNTA
Excel Limits Excel User tips
GoLast to jump to last cell in a column CELL
Paste Special Percentage Excel User tips
IFS (and IFNA) to avoid nested IFs Formulas - combined functions
Spreadsheet Compare application Excel User tips

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme