Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Unix DateTime Number Basic Math
  • CountIf limitation COUNTIF
  • Shapes with dynamic output Excel User tips
  • Links between two workbooks – dynamically using functions INDIRECT
  • Pixel Excel Drawing Format Cells
  • Week number to Month number DATE
  • New function IFERROR, finally IFERROR
  • CONVERT function CONVERT

Walking Columns

Posted on January 14, 2023 By ANmar

An easy way to scroll through set of data in a graphic way without graphs.

A-pure-formula xlsx workbook. These were done using formulas, conditional formatting, and ActiveX control.

An idea came in last night. Showing graph bars using cell colors only, no objects, no charts, just mare cells with colors.

This will display numbers relative to 100, column is found in another sheet (1st screen), will see if I will have time for future enhances to make it dynamic.

Excel Online
Download
ActiveX controls, Basic Math, COLUMN, Conditional Formatting, Formulas - combined functions, IF, INT, Logical, Lookup and References, Math and Trig, Non-functions, OFFSET, ROW, Standard functions

Post navigation

Previous Post: Unix DateTime Number
Next Post: Filter. Google Sheets function

Related Posts

  • Count cells with condition – multiple conditions COUNTIFS
  • Repeated Offset Basic Math
  • Multiple-Validations (connected to each other) Data Validation
  • BMI Calculator Basic Math
  • Return 12 values in one number AND
  • Cuts string of list of items 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
  • IFS (and IFNA) to avoid nested IFs Formulas - combined functions
  • Limited Ceiling Basic Math
  • CONVERT function CONVERT
  • Workdays – Across months DATE
  • Cuts string of list of items Formulas - combined functions
  • Sort list dynamically (functions) COLUMN
  • Edit directly in cell Excel User tips
  • Week number to Sunday date – Weeknum reverse DATE

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme