Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • New function IFERROR, finally IFERROR
  • Multiple Dual-Validations COUNTA
  • Custom fiscal year calendar (CFlex) Basic Math
  • Spreadsheet Compare application Excel User tips
  • Count Unique COUNTIF
  • Pixel Excel Drawing Format Cells
  • BMI Calculator Basic Math
  • Formula Beautifier Excel User tips

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

  • FORMULATEXT to show formulas FORMULATEXT
  • VLookup Lookup and References
  • iframe in Excel (XLiFrame) ADDRESS
  • Excel Dynamic Drop-Downs that grow with you COUNTA
  • Repeated Offset Basic Math
  • Searching table in 2 dimensions. Formulas - combined functions

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
  • Hyperlink usage and HyperlinkOf UDF CELL
  • Get column name (columnname as A,B,C, etc) as input inside cell ADDRESS
  • Schedule column Basic Math
  • Scorring, saving multiple outputs in 1 number Basic Math
  • DayName Date and Time
  • Sort list dynamically (functions) COLUMN
  • Worksheet name, dynamically using formula CELL
  • Change Calculator – calculate change in multiple bills/coins Formulas - combined functions

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme