'ISNUMBER function' category
Count cells with text
Table of Contents Count cells with text Count cells with text excluding cells containing a space character Count text values […]
Table of Contents Count cells with text Count cells with text excluding cells containing a space character Count text values […]
How to extract numbers from a cell value
What's on this page How to extract numbers from a cell value - Excel 2016 Sort and return unique distinct […]
What's on this page How to extract numbers from a cell value - Excel 2016 Sort and return unique distinct […]
How to use the ISNUMBER function
The ISNUMBER function checks if a value is a number, returns TRUE or FALSE. Table of Contents ISNUMBER Function Syntax […]
The ISNUMBER function checks if a value is a number, returns TRUE or FALSE. Table of Contents ISNUMBER Function Syntax […]
Count cells containing text from list
Table of Contents Count cells containing text from list Count entries based on date and time 1. Count cells containing […]
Table of Contents Count cells containing text from list Count entries based on date and time 1. Count cells containing […]
INDEX MATCH – Case sensitive
The picture above demonstrates a formula in cell F3 that allows you to look up a value in column B […]
The picture above demonstrates a formula in cell F3 that allows you to look up a value in column B […]
INDEX MATCH – multiple results
Table of Contents INDEX MATCH - multiple results INDEX and MATCH - multiple criteria and multiple results INDEX and MATCH […]
Table of Contents INDEX MATCH - multiple results INDEX and MATCH - multiple criteria and multiple results INDEX and MATCH […]
Match two columns and return another value on the same row
This article demonstrates formulas that match two conditions in a column each and return another value on the same row […]
This article demonstrates formulas that match two conditions in a column each and return another value on the same row […]
INDEX MATCH with multiple criteria
This article demonstrates formulas that let you perform lookups using two or more conditions. The image above shows two conditions […]
This article demonstrates formulas that let you perform lookups using two or more conditions. The image above shows two conditions […]
If cell contains text
This article demonstrates different formulas based on if a cell contains a given text. Formula in cell C3: =B3=$E$3 The […]
This article demonstrates different formulas based on if a cell contains a given text. Formula in cell C3: =B3=$E$3 The […]
Partial match and return value with highest level
This article demonstrates a formula that searches a cell (partial match) based on values in a table and returns a […]
This article demonstrates a formula that searches a cell (partial match) based on values in a table and returns a […]
Search for a sequence of cells based on wildcard search
This article demonstrates array formulas that perform a wildcard search based on a sequence of values. The formulas return the […]
This article demonstrates array formulas that perform a wildcard search based on a sequence of values. The formulas return the […]
Working with classic ciphers in Excel
What's on this page Reverse text Insert random characters Convert letters to numbers How to shuffle characters in the alphabet […]
What's on this page Reverse text Insert random characters Convert letters to numbers How to shuffle characters in the alphabet […]
Wildcard lookups and include or exclude criteria
This article demonstrates three different ways to filter a data set if a value contains a specific string and if […]
This article demonstrates three different ways to filter a data set if a value contains a specific string and if […]
Partial match 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 […]
This article demonstrates array formulas that search for cell values containing a search string and returns corresponding values on the […]
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 […]
EEK asks: I am looking for the same formula on this page, but targeting a range of MxN (spanning multiple […]
Search each column for a string each and return multiple records – OR logic
RU asks: Can you please suggest if i want to find out the rows with fixed value in "First Name" […]
RU asks: Can you please suggest if i want to find out the rows with fixed value in "First Name" […]
VLOOKUP – Return multiple unique distinct values
This article shows how to extract unique distinct values based on a condition applied to an adjacent column using formulas. […]
This article shows how to extract unique distinct values based on a condition applied to an adjacent column using formulas. […]
Filter strings containing a given substring in a cell range
This post describes ways to extract all matching strings from cells in a given cell range if they contain a […]
This post describes ways to extract all matching strings from cells in a given cell range if they contain a […]
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. […]
This article demonstrates ways to extract unique distinct sorted from A to Z ignoring blanks, and based on a condition. […]
Match two criteria and return multiple records
This article demonstrates how to extract records/rows based on two conditions applied to two different columns, you can easily extend […]
This article demonstrates how to extract records/rows based on two conditions applied to two different columns, you can easily extend […]
Extract unique distinct values if the value contains the given string
This article demonstrates formulas that list unique distinct values if they contain a specified substring. Table of contents Extract unique […]
This article demonstrates formulas that list unique distinct values if they contain a specified substring. Table of contents Extract unique […]
5 easy ways to VLOOKUP and return multiple values
This post explains how to lookup a value and return multiple values. No array formula required.
This post explains how to lookup a value and return multiple values. No array formula required.
Extract numbers from a column
I this article I will show you how to get numerical values from a cell range manually and using an […]
I this article I will show you how to get numerical values from a cell range manually and using an […]
Perform multiple partial matches and return records – AND logic
Question: Can expand this equation set into more than two colums of data, say if I had a first, middle […]
Question: Can expand this equation set into more than two colums of data, say if I had a first, middle […]
Extract duplicates from a multi-column cell range
This article describes two formulas that extract duplicates from a multi-column cell range, the first one is built for Excel […]
This article describes two formulas that extract duplicates from a multi-column cell range, the first one is built for Excel […]
Search for a text string in a data set and return multiple records
This article explains different techniques that filter rows/records that contain a given text string in any of the cell values […]
This article explains different techniques that filter rows/records that contain a given text string in any of the cell values […]
Count a specific text string in a cell
Table of Contents Count a specific text string in a cell (case sensitive) Count text string in a range (case […]
Table of Contents Count a specific text string in a cell (case sensitive) Count text string in a range (case […]
Partial match with two conditions and return multiple results
This article demonstrates a formula that extracts a row or record from a data table using two strings as criteria. […]
This article demonstrates a formula that extracts a row or record from a data table using two strings as criteria. […]
Partial match for multiple strings – AND logic
This article demonstrates formulas that let you perform partial matches based on multiple strings and return those strings if all […]
This article demonstrates formulas that let you perform partial matches based on multiple strings and return those strings if all […]
How to extract email addresses from an Excel sheet
Question: How to extract email addresses from this sheet? Answer: It depends on how the emails are populated in your worksheet? […]
Question: How to extract email addresses from this sheet? Answer: It depends on how the emails are populated in your worksheet? […]
Excel formula categories
AverageChooseCombine MergeCompareConcatenateConditional FormattingCountCount valuesDatesDuplicatesExtractFilterFilter recordsFiltered valuesFilterxmlHyperlinkIf cellIndex MatchLogicLookupsMatchMaxMinNumbers in sumOR logicOverlappingPartial matchRecordsSequenceSmallSort bySort valuesSumSumifsSumproductString manipulationTimeUnique distinct recordsUnique distinct valuesUnique recordsUnique valuesVlookupVlookup return values