Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Cuts string of list of items Formulas - combined functions
  • Excel keeps converting all cells to “Date” (or Time) Excel User tips
  • CountIf limitation COUNTIF
  • Multiple Dual-Validations COUNTA
  • VALUE() of LEFT() Formulas - combined functions
  • Show developer tab Excel User tips
  • Always get 1st name (or last) Formulas - combined functions
  • Excel Dynamic Drop-Downs that grow with you COUNTA

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

  • Multiple Dual-Validations COUNTA
  • DayName Date and Time
  • VLookup Lookup and References
  • CountIf limitation COUNTIF
  • Scorring, saving multiple outputs in 1 number Basic Math
  • Looplist – Repeating months using formulas Basic Math

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
  • 0% interest promotion Basic Math
  • State Abbr with Index+Match+Validation Data Validation
  • Compare2, a tool to compare two sheets using formulas Conditional Formatting
  • VLookup Lookup and References
  • Stale values (Scratched functions) Excel User tips
  • MID + SEARCH to convert cell to rows MID
  • WorksheetName and WorksheetsNo UDFs Lookup and References
  • Count cells with condition – multiple conditions COUNTIFS

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme