How to use the COUNTIF function to count not blank cells
The COUNTIF function is very capable of counting non-empty values. Column B above have a few blank cells, they are […]
If cell contains text
The easiest way to check if a cell contains a specific text string is, in my opinion, the IF and […]
Use IF + COUNTIF to perform numerous conditions
The COUNTIF function allows you to construct a small IF formula that carries out plenty of logical expressions. Combining the IF […]
How to use the COUNTIF function
Counts the number of cells that meet a specific condition.
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 […]
Count unique distinct values
This article describes how to count unique distinct values. What are unique distinct values? They are all values but duplicates are […]
5 easy ways to extract Unique Distinct Values
First, let me explain the difference between unique values and unique distinct values, it is important you know the difference […]
Extract shared values between two columns
Question: How can I compare two columns to find values that exists in both cell ranges? The picture above shows […]
COUNTIF not blank cells
Random unique nums
Unique dist. values
Shared values 2 cols
Most used functions
Weekly Blog EMAIL
Get a FREE PDF book!
Feel free to comment and ask Excel questions.
Make sure you subscribe to my newsletter so you don't miss new blog articles.