Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Extract Address into table Formulas - combined functions
  • CTRL+Y a mini macro Excel User tips
  • Extract current (Active) workbook name CELL
  • Fx to cut long column into two columns Formulas - combined functions
  • Limited Ceiling Basic Math
  • Highlight dates dynamically AND
  • Lesson learned: Do not trust Google Sheets function Google Sheets
  • Get monthly total from table with dates DATE

Return 12 values in one number

Posted on August 8, 2022 By ANmar

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

The main concept is set of formulas to do that, here we are using Excel functions only to do so.

Example shows how formulas can extract list of items based on one number user enter in a cell.

Excel Online
Download
AND, Formulas - combined functions, IF, Logical, Math and Trig, Min, Standard functions, SUM Tags:AND, IF, MIN, SUM

Post navigation

Previous Post: Cells with additional spaces
Next Post: Excel @ before function names in formulas

Related Posts

  • Expenses calendar, FaCal Basic Math
  • MATCH fumction, just a simple search Lookup and References
  • Count Unique COUNTIF
  • Sum of divide – Array formula Array formula
  • Walking Columns ActiveX controls
  • Always get 1st name (or last) Formulas - combined functions

Recent Posts

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

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
  • Shapes with dynamic output Excel User tips
  • Hello world! Uncategorized
  • 0% interest promotion Basic Math
  • Shades of gray Graphics
  • Blank (isempty) VS “” (null string) Excel User tips
  • Sorting with functions only CHOOSE
  • Looplist – Repeating months using formulas Basic Math
  • Cuts string of list of items Formulas - combined functions

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme