## 'SEARCH function' category

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

Extract specific word based on position in cell value

Table of Contents Extract first word in cell value Extract the first word in cell - return warning if not […]

Table of Contents Extract first word in cell value Extract the first word in cell - return warning if not […]

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

If cell contains multiple values

This article demonstrates formulas that perform a partial match for a given cell using multiple strings specified in cells F2 […]

This article demonstrates formulas that perform a partial match for a given cell using multiple strings specified in cells F2 […]

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

Find last value in a column

This article demonstrates formulas that return the last value in a given cell range or column. The image above shows […]

This article demonstrates formulas that return the last value in a given cell range or column. The image above shows […]

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

Split search value using a delimiter and search for each substring

This article demonstrates formulas and a UDF that searches for values in a table based on concatenated values and returns […]

This article demonstrates formulas and a UDF that searches for values in a table based on concatenated values and returns […]

How to extract rows containing digits [Formula]

This article describes a formula that returns all rows containing at least one digit 0 (zero) to 9. What's on […]

This article describes a formula that returns all rows containing at least one digit 0 (zero) to 9. What's on […]

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

How to use the SEARCH function

Returns a number representing the position a substring is, if found in a textstring. FIND is case sensitive and SEARCH is not.

Returns a number representing the position a substring is, if found in a textstring. FIND is case sensitive and SEARCH is not.

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

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

Fuzzy VLOOKUP

This formula returns multiple values even if they are arranged differently or have minor misspellings compared to the lookup value.

This formula returns multiple values even if they are arranged differently or have minor misspellings compared to the lookup value.

A Comprehensive Guide to Splitting Text in Excel

This blog article describes how to split strings in a cell with space as a delimiting character, like Text to […]

This blog article describes how to split strings in a cell with space as a delimiting character, like Text to […]

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

Lookup and return multiple values concatenated into one cell

This article demonstrates how to find a value in a column and concatenate corresponding values on the same row. The […]

This article demonstrates how to find a value in a column and concatenate corresponding values on the same row. The […]

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.

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

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

Filter unique distinct records

Table of contents Filter unique distinct row records Filter unique distinct row records but not blanks Filter unique distinct row […]

Table of contents Filter unique distinct row records Filter unique distinct row records but not blanks Filter unique distinct row […]

## 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