Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Walking Columns ActiveX controls
  • Looplist – Repeating months using formulas Basic Math
  • Shades of gray Graphics
  • Rotate table using 1 formula ADDRESS
  • Cell formats 0.0\% and 0.0%;(0.0%) Format Cells
  • Cells with additional spaces AND
  • Excel @ before function names in formulas Excel User tips
  • MATCH fumction, just a simple search Lookup and References

Category: Uncategorized

Count Unique

Posted on August 9, 2019 By ANmar
Count Unique

A question by a colleague on how to count number of unique items in a column made me realize, I don’t have that here.

So here it is …

COUNTIF, Formulas - combined functions, IF, Standard functions, Statistical, Uncategorized

Hello world!

Posted on May 10, 2016 By ANmar No Comments on Hello world!

Welcome to WordPress. This is your first post. Edit or delete it, then start writing!

Uncategorized

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
  • Excel keeps converting all cells to “Date” (or Time) Excel User tips
  • Week number to Month number DATE
  • Compare2, a tool to compare two sheets using formulas Conditional Formatting
  • Scorring, saving multiple outputs in 1 number Basic Math
  • Get column name (columnname as A,B,C, etc) as input inside cell ADDRESS
  • Get monthly total from table with dates DATE
  • iframe in Excel (XLiFrame) ADDRESS
  • Edit directly in cell Excel User tips

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme