Get Digital Help
  • Home
  • Templates
  • Products
  • Functions
  • Archive
  • Contact
  • About Me
    • About me
    • Blogs I read
    Function Reference Formulas Charts Conditional Formatting Excel Tables Pivot Tables VBA Knowledge Base Macros User Defined Functions Videos Advanced Excel Course

    Most used functions

    COUNTIF function INDEX function IF function SUM function SUMIFS function SUMPRODUCT function VLOOKUP function


Archive for NOT function


Count cells with text

The following formula in cell D3 counts cells with values stored as text. =SUMPRODUCT(ISTEXT(B3:B14)*1) In other words, cells containing nothing, errors, […]

How to use the NOT function

The NOT function returns the boolean opposite to the given argument. TRUE returns FALSE and FALSE returns TRUE. Formula in […]

Extract unique distinct values from a related table

In a previous post I described how to do lookups in a related table. In this post I am going […]

Merge two columns with possible blank cells

Question: This article is terrific. Thanks so much for posting this solution! I do have one question: Let's say my […]

List all unique events in a month

Question: I have a table with four columns, Date, Name, Level, and outcome. The range is from row 3 to […]

Create a custom date range

Question: how can i get the date range as : 01/01/09 - 01/15/09, 01/16/09 - 01/31/09 and so on I […]

Extract unique distinct values sorted based on sum of adjacent values

Table of Contents Filtering unique distinct text values and sort them based on sum of adjacent values Filtering unique distinct […]

Sort a range based on value frequency

Learn how to sort cell values by frequency.

How to create a list of random unique numbers

Question: How do I create a random list of unique numbers from say 1 to 10, without using VBA and […]

      Formula categories

      Count Dates Extract Index and Match Logic Lookups String manipulation Sum Time Vlookup
  • Welcome! I am Oscar and here to help you! Feel free to comment and ask excel questions.
    Don´t forget to add my RSS feed and subscribe to new blog articles by email.
  • Free Blog Emails

     
  • Search website

sponsored