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.
Define and use names in formulas - Microsoft Support
By using names, you can make your formulas much easier to understand and maintain. You can define a name for a cell range, function, constant, or table. Once you adopt the practice of using names in your workbook, you can easily update, audit, and …
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 ...
Split text into different columns with functions - Microsoft Support
Split text into different columns with functions. You can use the LEFT, MID, RIGHT, SEARCH, and LEN text functions to manipulate strings of text in your data. For example, you can distribute the first, middle, and last names from a single cell into three separate columns.
AGGREGATE function - Microsoft Support
Returns an aggregate in a list or database. The AGGREGATE function can apply different aggregate functions to a list or database with the option to ignore hidden rows and error values.
Create a named range from selected cells in a worksheet
You can quickly create a named range by using a selection of cells in the worksheet. Note: Named ranges that are created from selecting cells have a workbook-level scope. Select the range you want to name, including the row or column …
VLOOKUP function - Microsoft Support
Look up values with VLOOKUP, INDEX, or MATCH. HLOOKUP function. Learn how to use function VLOOKUP in Excel to find data in a table or range by row. Our step-by-step guide makes vlookup in excel easy and efficient.
Use the Name Manager in Excel - Microsoft Support
Insert a named range into a formula in Excel. Define and use names in formulas. The Name Manager dialog box is a central place to manage named ranges in your Excel spreadsheet.
Use Goal Seek to find the result you want by adjusting an input …
On the Home tab, in the Number group, click Percentage. Click Increase Decimal or Decrease Decimal to set the number of decimal places. If you know the result you want from a formula but aren't sure which input is needed to get that result, use Excel's Goal Seek feature.
Rename an Excel table - Microsoft Support
Go to Table Tools > Design > Properties > Table Name. On a Mac, go to the Table tab > Table Name. Highlight the table name and enter a new name. Tips: All of your tables will be shown in the Address bar, which appears to the left of the Formula bar.
RIGHT, RIGHTB functions - Microsoft Support
RIGHT returns the last character or characters in a text string, based on the number of characters you specify. RIGHTB returns the last character or characters in a text string, based on the number of bytes you specify. These functions may not be available in all languages.