Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Excel sessions – 2013 VS 2010 Excel User tips
  • 6174 Kaprekar’s constant Basic Math
  • WorksheetName and WorksheetsNo UDFs Lookup and References
  • Limited Ceiling Basic Math
  • Walking Columns ActiveX controls
  • Links between two workbooks – dynamically using functions INDIRECT
  • Fx to cut long column into two columns Formulas - combined functions
  • Cuts string of list of items Formulas - combined functions

Category: Standard functions

Standard functions that comes with Excel, plain single functions

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

LastSunday, LastSaturday

Posted on October 17, 2023 By ANmar
LastSunday, LastSaturday

Get the date of the most recent SUNDAY for a specific date:D12 is the cell containing the date =D12 – WEEKDAY(D12) + 1 While Saturday is easier Get the date of the most recent SATURDAY for a specific date: =D12 – WEEKDAY(D12)

Date and Time, Standard functions, WEEKDAY

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

Unix DateTime Number

Posted on January 6, 2023 By ANmar
Unix DateTime Number

Convert Date/time number from regular number to Unix DateTime Number.

Read More “Unix DateTime Number” »

Basic Math, DATE, Date and Time, 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

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

Posts pagination

1 2 … 8 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
  • Expenses calendar, FaCal Basic Math
  • Convert cell into textbox Excel User tips
  • Get column name (columnname as A,B,C, etc) as input inside cell ADDRESS
  • OFFSET+MATCH Formulas - combined functions
  • Recover the unrecoverable Excel User tips
  • Get 3rd Wednesday of month Basic Math
  • Repeated Offset Basic Math
  • Fx to cut long column into two columns Formulas - combined functions

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme