Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Paste Special Percentage Excel User tips
  • Pixel Excel Drawing Format Cells
  • When Excel tells you to go get some life Excel User tips
  • Extract current (Active) workbook name CELL
  • Recover the unrecoverable Excel User tips
  • Count cells with condition – multiple conditions COUNTIFS
  • GoLast to jump to last cell in a column CELL
  • VLookup Lookup and References

Tag: shapes

Shapes with dynamic output

Posted on July 18, 2022 By ANmar
Shapes with dynamic output

A trick learned awhile ago. Creating shapes connected to cell, that updated automatically.

When following steps attached, you will be able to connect any shape to any cell in away making it “linked”, so when cell changes the shape will also get updated.

Used it to enlarge or track user attention to a certain value, or sometimes to format certain text in a free way outside cells limitations.

Read More “Shapes with dynamic output” »

Excel User tips, Graphics, Non-functions

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
  • Standard math to calculate Aspect Ratio Basic Math
  • Get column name (columnname as A,B,C, etc) as input inside cell ADDRESS
  • Jan8 date format AND
  • VALUE() of LEFT() Formulas - combined functions
  • Show developer tab Excel User tips
  • Sum of divide – Array formula Array formula
  • Calculate above and below me Average
  • Compare2, a tool to compare two sheets using formulas Conditional Formatting

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme