Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Excel ad from early 90s Non-functions
  • CTRL+Y a mini macro Excel User tips
  • Count cells with condition – multiple conditions COUNTIFS
  • SimpleANBox Basic Math
  • Count how many times letter found Formulas - combined functions
  • Insert Blank rows into table using functions CHAR
  • Compare2, a tool to compare two sheets using formulas Conditional Formatting
  • Standard math to calculate Aspect Ratio 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

  • Calculate hours between two cells ABS
  • Multiple Dual-Validations COUNTA
  • Excel sessions – 2013 VS 2010 Excel User tips
  • Progress bar in pure functions CHAR
  • Rotate table using 1 formula ADDRESS
  • VALUE() of LEFT() 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
  • Search across sheets in function ADDRESS
  • Limited Ceiling Basic Math
  • Excel sessions – 2013 VS 2010 Excel User tips
  • Pixel Excel Drawing Format Cells
  • Excel Functions = XL f(x)s XLfxs
  • DayName Date and Time
  • Highlight dates dynamically AND
  • Tally chart in functions Formulas - combined functions

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme