Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Week number to Month number DATE
  • CHOOSE – tree of decisions CHOOSE
  • Pixel Excel Drawing Format Cells
  • Schedule column Basic Math
  • Hyperlink usage and HyperlinkOf UDF CELL
  • Convert cell into textbox Excel User tips
  • Custom fiscal year calendar (CFlex) Basic Math
  • Count cells with condition – multiple conditions COUNTIFS

Category: Formulas – combined functions

Two or more functions = One Formula, how to combine more than one function to present a powerful formula that does the job well

Middle name + 1st name

Posted on February 3, 2024 By ANmar
Middle name + 1st name

Get the initial (middle name) from a triple name in a cell.
C4 The cell contains the triple name separated with spaces.
=LEFT(C4,1) & "." & MID(C4, SEARCH(" ", C4, 1) + 1, 1) & "." & MID(C4, SEARCH(" ", C4, SEARCH(" ", C4, 1) + 1) + 1, 1) & "."

Read More “Middle name + 1st name” »

Basic Math, Formulas - combined functions, LEFT, MID, SEARCH, Standard functions, Texts and Strings

Jan8 date format

Posted on April 24, 2023 By ANmar
Jan8 date format

Format a date in shortest format possible indicating how many days have passed (Past date)

If date1-date2 < 8 Sat, Fri, …
If date1-date2 < 350 Dec24, Jan4, Aug14
Else 2020Feb4

Read More “Jan8 date format” »

AND, Date and Time, Formulas - combined functions, IF, Logical, Standard functions, TEXT, Texts and Strings, TODAY

Walking Columns

Posted on January 14, 2023 By ANmar
Walking Columns

An easy way to scroll through set of data in a graphic way without graphs.

A-pure-formula xlsx workbook. These were done using formulas, conditional formatting, and ActiveX control.

Read More “Walking Columns” »

ActiveX controls, Basic Math, COLUMN, Conditional Formatting, Formulas - combined functions, IF, INT, Logical, Lookup and References, Math and Trig, Non-functions, OFFSET, ROW, Standard functions

Get 3rd Wednesday of month

Posted on November 15, 2022 By ANmar
Get 3rd Wednesday of month

This was an interesting request.

Needing to get the date of 3rd Wednesday for a given month, automatically, using pure Excel functions.

So, sharing here on what is the formula and how to get there.

Read More “Get 3rd Wednesday of month” »

Basic Math, CHOOSE, DATE, Date and Time, Formulas - combined functions, Lookup and References, MONTH, Standard functions, WEEKDAY, YEAR

Repeated Offset

Posted on September 19, 2022 By ANmar
Repeated Offset

I needed to have an offset of columns to be repeated every 12 months.

This is part of a project, we needed to calculate the coefficient of sales prediction based on the month number, we do have coefficient saved in another table that repeated every year (12 months).

Read More “Repeated Offset” »

Basic Math, COLUMN, Formulas - combined functions, IFERROR, INT, Logical, Lookup and References, Math and Trig, OFFSET, Standard functions

Sorting with functions only

Posted on September 5, 2022 By ANmar
Sorting with functions only

This one is similar to http://xlfxs.com/sort-list-using-functions/ where we use some controls here that make it more user-friendly.

Read More “Sorting with functions only” »

CHOOSE, Formulas - combined functions, LARGE, Lookup and References, MATCH, Math and Trig, ROW, SMALL, Standard functions, VLOOKUP

6174 Kaprekar’s constant

Posted on September 2, 2022 By ANmar
6174 Kaprekar’s constant

This is the spreadsheet to prove this constant. When all roads lead to Kaprekar

Just enter any 4 digits number in D3 and watch roads walk you 6174

Read More “6174 Kaprekar’s constant” »

Basic Math, Formulas - combined functions, Standard functions, TEXT, Texts and Strings, VALUE

Cuts string of list of items

Posted on August 17, 2022 By ANmar
Cuts string of list of items

An old lesson to one of my early classes to show how can we cut a string having list of items into its parts. (At least 1st three parts) using formulas only.

Read More “Cuts string of list of items” »

Formulas - combined functions, LEFT, MID, SEARCH, Standard functions, Texts and Strings

Excel @ before function names in formulas

Posted on August 9, 2022 By ANmar
Excel @ before function names in formulas

Looks like there is a change coming. Excel started adding the symbol @ to some formulas, not sure why only those, but we are waiting to start using this new feature.

Read More “Excel @ before function names in formulas” »

Excel User tips, Formulas - combined functions

Return 12 values in one number

Posted on August 8, 2022 By ANmar
Return 12 values in one number

A technic I loved using, return list of items (up to 12 items now) in ONE number.

Let us say you have list of 12 items, and you want a function that will return some of that list (with no order), then this is how you can do it. This has been sitting around for awhile in my archive. I called it 12Return4095

Read More “Return 12 values in one number” »

AND, Formulas - combined functions, IF, Logical, Math and Trig, Min, Standard functions, SUM

Searching table in 2 dimensions.

Posted on July 26, 2022 By ANmar
Searching table in 2 dimensions.

Using VLOOKUP + MATCH (HLOOKUP + MATCH, OFFSET + 2 MATCHes or INDEX + 2 MATCHes) to search a table in both axis.

This post has been sitting for a while in my archive, waiting for me to get some time to polish and post.

Read More “Searching table in 2 dimensions.” »

Formulas - combined functions, HLOOKUP, INDEX, Lookup and References, MATCH, Standard functions, VLOOKUP

Posts pagination

1 2 … 6 Next

Recent Posts

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

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
  • Recover the unrecoverable Excel User tips
  • Count cells with condition – multiple conditions COUNTIFS
  • CTRL+Y a mini macro Excel User tips
  • Jan8 date format AND
  • VLookup Lookup and References
  • State Abbr with Index+Match+Validation Data Validation
  • Schedule column Basic Math
  • Tally chart in functions Formulas - combined functions

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme