Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Formula Beautifier Excel User tips
  • Workdays – Across months DATE
  • Highlight dates dynamically AND
  • iframe in Excel (XLiFrame) ADDRESS
  • Why I ran from =INDIRECT() function Formulas - combined functions
  • The Excel “&” bug Excel User tips
  • Sorting with functions only CHOOSE
  • Limited Ceiling Basic Math

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 how many times letter found Formulas - combined functions
  • Cells with additional spaces AND
  • Paste Special Percentage Excel User tips
  • Workdays – Across months DATE
  • Jan8 date format AND
  • CTRL+Y a mini macro Excel User tips

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
  • iframe in Excel (XLiFrame) ADDRESS
  • Sum of divide – Array formula Array formula
  • DayName Date and Time
  • Validation based on another Validation COUNTA
  • Lesson learned: Do not trust Google Sheets function Google Sheets
  • Excel Functions = XL f(x)s XLfxs
  • Scorring, saving multiple outputs in 1 number Basic Math
  • Filter. Google Sheets function Google Sheets

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme