Skip to content

Excel Functions

Excel f(x)s = Excel Functions

iframe in Excel (XLiFrame) ADDRESS
Stale values (Scratched functions) Excel User tips
Schedule column Basic Math
Standard math to calculate Aspect Ratio Basic Math
Highlight dates dynamically AND
Multiple lines in cell using functions CHAR
Looplist – Repeating months using formulas Basic Math
Lesson learned: Do not trust Google Sheets function Google Sheets

LoopList3

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

Cuts string of list of items Formulas - combined functions
Highlight dates dynamically AND
Multiple Dual-Validations COUNTA
Hyperlink usage and HyperlinkOf UDF CELL
Get 3rd Wednesday of month Basic Math
Rotate table using 1 formula ADDRESS
Excel ad from early 90s Non-functions
Min Max vehicle Formulas - combined functions

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme