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. =IF (Something is True, then do something, otherwise do something else)
Check if a cell contains text (case-insensitive) - Microsoft Support
Find cells that contain text. Follow these steps to locate cells containing specific text: Select the range of cells that you want to search. To search the entire worksheet, click any cell. On the Home tab, in the Editing group, click Find & Select, and then click Find.
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.
Look up values with VLOOKUP, INDEX, or MATCH - Microsoft …
It's actually quite easy to do with a lookup function. The VLOOKUP and HLOOKUP functions, together with INDEX and MATCH, are some of the most useful functions in Excel. Note: The Lookup Wizard feature is no longer available in Excel. Here's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE)
How to correct a #N/A error in INDEX/MATCH functions
SOLUTION: To remove unexpected characters or hidden spaces, use the CLEAN or TRIM function, respectively. Also, verify if the cells are formatted as correct data types. You have used an array formula without pressing Ctrl+Shift+Enter.
Create, load, or edit a query in Excel (Power Query)
Create, load, or edit a query in Excel (Power Query) Applies To. Power Query offers several ways to create and load Power queries into your workbook. You can also set default query load settings in the Query Options window. Tip To tell if data in a worksheet is shaped by Power Query, select a cell of data, and if the Query context ribbon tab ...
TEXT function - Microsoft Support
The TEXT function lets you change the way a number appears by applying formatting to it with format codes. It's useful in situations where you want to display numbers in a more readable format, or you want to combine numbers with text or symbols.
Create a parameter query (Power Query) - Microsoft Support
Parameters can be used in any query step. In addition to functioning as a data filter, parameters can be used to specify such things as a file path or a server name. Parameters don’t prompt for input. Instead, you can quickly change their value using Power Query.
Create conditional formulas - Microsoft Support
You can use the AND, OR, NOT, and IF functions to create conditional formulas. For example, the IF function uses the following arguments. Formula that uses the IF function. logical_test: The condition that you want to check. value_if_true: The value to return if the condition is True.
Count how often a value occurs - Microsoft Support
There are several ways to count how often a value occurs. Count how often a single value occurs by using the COUNTIF function. Count based on multiple criteria by using the COUNTIFS function. Count based on criteria by using the COUNT and IF functions together.
How to compare data in two columns to find duplicates in Excel
How to compare data in two columns to find duplicates in Excel. You can use the following methods to compare data in two Microsoft Excel worksheet columns and find duplicate entries.