Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Multiple-Validations (connected to each other) Data Validation
  • Excel sessions – 2013 VS 2010 Excel User tips
  • WorksheetName and WorksheetsNo UDFs Lookup and References
  • Cell formats 0.0\% and 0.0%;(0.0%) Format Cells
  • Show developer tab Excel User tips
  • Excel Limits Excel User tips
  • Expenses calendar, FaCal Basic Math
  • Sorting with functions only CHOOSE

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

  • Rotate table using 1 formula ADDRESS
  • Count Unique COUNTIF
  • Fixed length ID Formulas - combined functions
  • Get column name (columnname as A,B,C, etc) as input inside cell ADDRESS
  • Expenses calendar, FaCal Basic Math
  • Week number to Sunday date – Weeknum reverse DATE

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
  • Count Unique COUNTIF
  • iframe in Excel (XLiFrame) ADDRESS
  • Skills Grid Conditional Formatting
  • MID + SEARCH to convert cell to rows MID
  • Get 3rd Wednesday of month Basic Math
  • LastSunday, LastSaturday Date and Time
  • Search across sheets in function ADDRESS
  • Shapes with dynamic output Excel User tips

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme