Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • CountIf limitation COUNTIF
  • Show developer tab Excel User tips
  • Excel @ before function names in formulas Excel User tips
  • Extract Address into table Formulas - combined functions
  • Cells with additional spaces AND
  • VALUE() of LEFT() Formulas - combined functions
  • Get column name (columnname as A,B,C, etc) as input inside cell ADDRESS
  • Search across sheets in function ADDRESS

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
  • OFFSET+MATCH Formulas - combined functions
  • Schedule column Basic Math
  • Sum of divide – Array formula Array formula
  • Expenses calendar, FaCal Basic Math
  • 6174 Kaprekar’s constant Basic Math

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
  • Standard math to calculate Aspect Ratio Basic Math
  • DayName Date and Time
  • Convert 2-column into wide (column-row) table Formulas - combined functions
  • Min Max vehicle Formulas - combined functions
  • Blank (isempty) VS “” (null string) Excel User tips
  • Week number to Sunday date – Weeknum reverse DATE
  • Multiple-Validations (connected to each other) Data Validation
  • Get 3rd Wednesday of month Basic Math

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme