Check if a cell contains text (case-insensitive) in Excel
Let's say you want to ensure that a column contains text, not numbers. Or, perhapsyou want to find all orders that correspond to a specific salesperson. If you have no concern for upper- or …
Check if a cell contains text (case-sensitive) - Microsoft Support
Learn how to check if a cell contains text, when the case of the text is important.
Check if a cell contains text (case-insensitive) in Excel
Learn how to find text inside cells, when the case of the text doesn't particularly matter.
Find and select cells that meet specific conditions in Excel
Use the Go To command to quickly find and select all cells that contain specific types of data, such as formulas. Also, use Go To to find only the cells that meet specific criteria,—such as …
MATCH function - Microsoft Support
How to use the MATCH function in Excel to search for a specified item in a range of cells, returning the relative position of that item in the range.
FIND function - Microsoft Support
This article describes the formula syntax and usage of the FIND function in Microsoft Excel. FIND locates one text string within a second text string, and return the number of the starting …
Ways to count cells in a range of data in Excel
Excel contains several functions to help you count the number of cells in a range that are blank or contain certain types of data. Select the cell where you want the result to appear.
Using IF with AND, OR, and NOT functions in Excel
In Excel, the IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if that condition is True or False.
COUNTIFS function - Microsoft Support
How to use the COUNTIFS function in Excel to apply criteria to cells, across multiple ranges, and count the number of times all criteria are met.
Use the COUNTIF function in Microsoft Excel
In its simplest form, COUNTIF says: =COUNTIF (Where do you want to look?, What do you want to look for?) For example: The group of cells you want to count. Range can contain numbers, …
Use Excel built-in functions to find data in a table or a range of ...
This step-by-step article describes how to find data in a table (or range of cells) by using various built-in functions in Microsoft Excel. You can use different formulas to get the same result. This …