Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Edit directly in cell Excel User tips
  • Sum of divide – Array formula Array formula
  • Excel Limits Excel User tips
  • Comments versus Notes Excel User tips
  • Hello world! Uncategorized
  • Count cells with condition – multiple conditions COUNTIFS
  • Count how many times letter found Formulas - combined functions
  • Extract current (Active) workbook name CELL

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
  • Return 12 values in one number AND
  • Excel Limits Excel User tips
  • Workdays – Across months DATE
  • Searching table in 2 dimensions. Formulas - combined functions
  • Highlight dates dynamically AND
  • Middle name + 1st name Basic Math
  • Excel @ before function names in formulas Excel User tips
  • Get column name (columnname as A,B,C, etc) as input inside cell ADDRESS

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme