Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • VALUE() of LEFT() Formulas - combined functions
  • Sorting with functions only CHOOSE
  • Cuts string of list of items Formulas - combined functions
  • Min Max vehicle Formulas - combined functions
  • Fx to cut long column into two columns Formulas - combined functions
  • Multiple lines in cell using functions CHAR
  • Extract Address into table Formulas - combined functions
  • Week number to Sunday date – Weeknum reverse DATE

Scorring, saving multiple outputs in 1 number

Posted on December 10, 2018 By ANmar

I have seen this practice before several locations

Returning multiple outputs in 1 single number.

for example

If you have list of items:

Red

Blue

Black

Gray

Green

Pink

Yellow

Orange

And then you have a function that need to return, Red yellow, or black orange, or blue gray green.

How can you do that in 1 return? or 1 number?

Answer is as I like to call “Scorring”, which by giving numeric value to each of these items, these values need to be unique so we can calculate them again from the single return number.

Best that I found were these numbers.

1: Red

2: Blue

4: Black

8: Gray

16: Green

32: Pink

64: Yellow

128: Orange

Look familiar? I bet …

Means if we need to return Red blue, our number should be 3

Red black, 5

Red only, 1

if blue black gray, then return 14

red gray pink, it is 31

And so on

This Excel file has formulas needed to break a large number (up tp 1m) into its small parts, again I call it here scorring, not sure what is the official practice name is.

Download
Online Excel version
Basic Math, Conditional Formatting, Formulas - combined functions, Logical, Non-functions, Standard functions

Post navigation

Previous Post: Expenses calendar, FaCal
Next Post: Looplist – Repeating months using formulas

Related Posts

  • Shapes with dynamic output Excel User tips
  • Sheet() and Sheets() Lookup and References
  • Insert Blank rows into table using functions CHAR
  • Workdays – Across months DATE
  • Links between two workbooks – dynamically using functions INDIRECT
  • Week number to Month number 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
  • Return 12 values in one number AND
  • Sum of divide – Array formula Array formula
  • Worksheet name, dynamically using formula CELL
  • Searching table in 2 dimensions. Formulas - combined functions
  • Highlight dates dynamically AND
  • Expenses calendar, FaCal Basic Math
  • Recover the unrecoverable Excel User tips
  • Show developer tab Excel User tips

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme