Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Stale values (Scratched functions) Excel User tips
  • Search across sheets in function ADDRESS
  • Progress bar in pure functions CHAR
  • Middle name + 1st name Basic Math
  • Excel @ before function names in formulas Excel User tips
  • Filter. Google Sheets function Google Sheets
  • DayName Date and Time
  • Pixel Excel Drawing Format Cells

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

  • Workdays – Across months DATE
  • IFS (and IFNA) to avoid nested IFs Formulas - combined functions
  • Extract current (Active) workbook name CELL
  • 6174 Kaprekar’s constant Basic Math
  • Compare2, a tool to compare two sheets using formulas Conditional Formatting
  • Search across sheets in function ADDRESS

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
  • CTRL+Y a mini macro Excel User tips
  • VALUE() of LEFT() Formulas - combined functions
  • Change Calculator – calculate change in multiple bills/coins Formulas - combined functions
  • Extract current (Active) workbook name CELL
  • Highlight dates dynamically AND
  • Cell formats 0.0\% and 0.0%;(0.0%) Format Cells
  • BMI Calculator Basic Math
  • Sum of divide – Array formula Array formula

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme