If cell contains any text
The picture above shows different values in column B and a formula in column C that tries to identifies the […]

Count cells with text
Table of Contents Count cells with text Count cells with text excluding cells containing a space character Count text values […]

How to use the ISTEXT function
What is the ISTEXT function? The ISTEXT function returns Boolean value TRUE if value is text. Use the ISTEXT function […]

Sort values by corresponding text arranged in a column
This article describes a formula that sorts values arranged in a column from A to z by every other value. […]

Lookup multiple values in one cell
This article explains how to perform multiple lookups based on values in one cell with a delimiting character using a […]

Change column/bar color in charts
This article demonstrates how to set up a chart so it shows one color for increasing bars/columns and another color […]

Filter unique distinct values, sorted and blanks removed from a range
EEK asks: I am looking for the same formula on this page, but targeting a range of MxN (spanning multiple […]

Extract a unique distinct list sorted from A to Z ignore blanks
This article demonstrates ways to extract unique distinct sorted from A to Z ignoring blanks, and based on a condition. […]

Extract unique distinct values if adjacent cell is text
Question: I want a unique distinct list to be created from a column where an adjacent column has text cell […]