List][*]the | search
Click here to view List][*]the news from 60+ newspapers.
Bookmark or Share- Define and use names in formulas - Microsoft SupportDefine and use names in formulas. 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 manage these names. Windows macOS Web.
- Excel functions (alphabetical) - Microsoft SupportOverview of formulas in Excel. How to avoid broken formulas. Detect errors in formulas. A complete list of all Excel functions in alphabetical order.
- Look up values with VLOOKUP, INDEX, or MATCH - Microsoft SupportIt'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)
- Look up values in a list of data - Microsoft SupportLook up data in Excel to find data in a list and verify that it's correct. Then, perform calculations or display results with the values returned. Use the VLOOKUP, HLOOKUP, INDEX, MATCH, and OFFSET functions to find related data in rows and columns in Excel.
- UNIQUE function - Microsoft SupportThe UNIQUE function returns a list of unique values in a list or range. Return unique values from a list of values. Return unique names from a list of names. Syntax. Examples. Example 1. This example uses SORT and UNIQUE together to return a unique list of names in ascending order. Example 2.
More
