Highlight opposite numbers

Pamela asks: I would like to ask you how to identify PAIR of same numbers, but with a different sign. […]

How to use the COUNT function

The COUNT function counts all numerical values in an argument, it allows you to have up to 255 arguments. Blank […]

If cell contains multiple values

The array formula in cell C3 checks if text string in B3 contains all values in F2:F3.

Create dependent drop down lists containing unique distinct values

This article explains how to build dependent drop down lists. Here is a list of order numbers and products. We […]

Exact word in string

I read an interesting blog post Is A Particular Word Contained In A Text String? on Spreadsheetpage. That inspired me […]

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 […]

Count the number of times a specific number exists in a list

Question: How many times is the value 3 (B2) in this list (A:A)? Answer: =COUNT(SEARCH(B2,A:A)) + CTRL+ SHIFT + ENTER […]