Skip to content

Excel Functions

Excel f(x)s = Excel Functions

Cuts string of list of items Formulas - combined functions
Rotate table using 1 formula ADDRESS
Week number to Sunday date – Weeknum reverse DATE
Excel Dynamic Drop-Downs that grow with you COUNTA
Week number to Month number DATE
Zipcode-State search Formulas - combined functions
Show developer tab Excel User tips
Extract current (Active) workbook name CELL

Excel ad from early 90s

Posted on March 14, 2018 By ANmar

Guess what I just found in my old archive !

Non-functions, Worksheet

Post navigation

Previous Post: Limited Ceiling

Next Post: Highlight dates dynamically

Related Posts

Blank (isempty) VS “” (null string) Excel User tips
When Excel tells you to go get some life Excel User tips
Excel keeps converting all cells to “Date” (or Time) Excel User tips
Show developer tab Excel User tips
SimpleANBox Basic Math
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

Excel keeps converting all cells to “Date” (or Time) Excel User tips
Filter. Google Sheets function Google Sheets
Shades of gray Graphics
Standard math to calculate Aspect Ratio Basic Math
Walking Columns ActiveX controls
Zipcode-State search Formulas - combined functions
Edit directly in cell Excel User tips
Tally chart in functions Formulas - combined functions

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme