## ISNUMBER function

Excel » Functions » Information » ISNUMBER function »

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

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

The ISNUMBER function checks if a value is a number, returns TRUE or FALSE. Formula in cell D3: =ISNUMBER(B3) Excel […]

INDEX MATCH – multiple results

The array formula in cell E6 extracts values from column C when the corresponding value in column B matches the […]

The easiest way to check if a cell contains a specific text string is, in my opinion, the IF and […]

Search for a text string and return multiple adjacent values

This article demonstrates array formulas that search for cell values containing a search string and returns corresponding values on the […]

Filter unique distinct values if value contains specific string [Formula and Advanced Filter]

Table of contents Filter unique distinct values using a "contain" condition Filter unique distinct values using a "contain" condition (Advanced […]

Extract numbers and text from a range sorted from A to Z

This blog post describes how to filter text values and then numbers from a range. Array formula in B15: =INDEX(tbl, […]

Filter numbers or text in a column

Question: I want to extract all numeric values into a new column? Also all text values into another column? Answer: […]

Sum values containing text based on a condition

Question: I want to sum cells that have a "C" and a decimal number. The cells have other numbers and […]

Lookup with multiple criteria and return multiple search results

Question: How do I search a list containing First name column and a last name column? I want to search […]