## Archive for 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: […]

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

Find the largest number in an expanding cell range

Question: I have a list that I add data to every day. I would like to find the largest number […]

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