Skip to content

Excel Functions

Excel f(x)s = Excel Functions

Min Max vehicle Formulas - combined functions
Repeated Offset Basic Math
Get monthly total from table with dates DATE
Get column name (columnname as A,B,C, etc) as input inside cell ADDRESS
Skills Grid Conditional Formatting
Excel Functions = XL f(x)s XLfxs
Calculate hours between two cells ABS
Excel Dynamic Drop-Downs that grow with you COUNTA

LoopList1

Search for:

Recent Posts

Calculate above and below me
Stale values (Scratched functions)
Middle name + 1st name
LastSunday, LastSaturday
Paste Special Percentage

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 (83)
- 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 (31)
  - AND (5)
  - IF (25)
  - IFERROR (7)
  - 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 (6)
  - Average (1)
  - 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

WorksheetName and WorksheetsNo UDFs Lookup and References
Progress bar in pure functions CHAR
Extract Address into table Formulas - combined functions
Walking Columns ActiveX controls
Skills Grid Conditional Formatting
6174 Kaprekar’s constant Basic Math
Comments versus Notes Excel User tips
MATCH fumction, just a simple search Lookup and References

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme