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

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 ISTEXT function

The ISTEXT function returns TRUE if value is text. Formula in cell C3: =ISTEXT(B3) Excel Function Syntax ISTEXT(value) Arguments value […]

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

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

The image above demonstrates a formula in cell D3 that extracts unique distinct numbers and text values sorted from A […]

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