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.
Use AND and OR to test a combination of conditions
When you need to find data that meets more than one condition, such as units sold between April and January, or units sold by Nancy, you can use the AND and OR functions together. Here's …
Using wildcard characters in searches - Microsoft Support
Use wildcard characters as comparison criteria for text filters, and when you're searching and replacing content. This feature enables you to find values that share a simple pattern. These characters can be the asterisk (*), the question mark (?), and the tilde (~).
Excel video training - Microsoft Support
A list of Excel training, from entry level to advanced skills, plus templates and other resources.
Create custom functions in Excel - Microsoft Support
Instead, Excel provides you with the ability to create custom functions, which are explained in this article. Custom functions, like macros, use the Visual Basic for Applications (VBA) programming language. They differ from macros in two significant ways. First, they use Function procedures instead of Sub procedures.
REGEXEXTRACT Function - Microsoft Support
You can extract the first match, all matches or capturing groups from the first match. The REGEXEXTRACT function extracts strings within the provided text that matches the pattern. The syntax of the REGEXEXTRACT function is: REGEXEXTRACT (text, pattern, [return_mode], [case_sensitivity])
Filter by using advanced criteria - Microsoft Support
To indicate an equality comparison operator for either text or a value, type the criteria as a string expression in the appropriate cell in the criteria range: =''= entry '' Where entry is the text or value you want to find. For example: When filtering text data, Excel doesn't distinguish between uppercase and lowercase characters.
Detect errors in formulas - Microsoft Support
Formulas can sometimes result in error values in addition to returning unintended results. The following are some tools that you can use to find and investigate the causes of these errors and determine solutions. Note: This topic contains techniques that can help you correct formula errors.
FIND, FINDB functions - Microsoft Support
This article describes the formula syntax and usage of the FIND and FINDB functions in Microsoft Excel. FIND and FINDB locate one text string within a second text string, and return the number of the starting position of the first text string from the first character of the second text string. These functions may not be available in all languages.
VLOOKUP function - Microsoft Support
Use VLOOKUP when you need to find things in a table or a range by row. For example, look up a price of an automotive part by the part number, or find an employee name based on their employee ID. In its simplest form, the VLOOKUP function says:
Using Checkboxes in Excel - Microsoft Support
Checkboxes are a versatile feature in Excel, useful for making interactive lists and forms. In this article, we'll cover how to add, remove, and toggle them. To insert Checkboxes: Select the range where you want checkboxes. Select Insert > Checkbox. To remove checkboxes: Select the range of cells with the checkboxes you want to remove.