Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • FORMULATEXT to show formulas FORMULATEXT
  • Shades of gray Graphics
  • New function IFERROR, finally IFERROR
  • BMI Calculator Basic Math
  • Blank (isempty) VS “” (null string) Excel User tips
  • Excel Functions = XL f(x)s XLfxs
  • CamelCase to Camel Case CHAR
  • Convert 2-column into wide (column-row) table Formulas - combined functions

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

  • Count how many times letter found Formulas - combined functions
  • Highlight dates dynamically AND
  • Unix DateTime Number Basic Math
  • Multiple-Validations (connected to each other) Data Validation
  • FORMULATEXT to show formulas FORMULATEXT
  • Custom fiscal year calendar (CFlex) Basic Math

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
  • Rotate table using 1 formula ADDRESS
  • Sorting with functions only CHOOSE
  • Get monthly total from table with dates DATE
  • Spreadsheet Compare application Excel User tips
  • Shapes with dynamic output Excel User tips
  • Pixel Excel Drawing Format Cells
  • IF with AND and IF with OR AND
  • Standard math to calculate Aspect Ratio Basic Math

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme