A6 | search
Click here to view A6 news from 60+ newspapers.
Bookmark or Share- 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.
- XLOOKUP function - Microsoft SupportUse the XLOOKUP function to find things in a table or range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID.
- SUMIFS function - Microsoft SupportThe SUMIFS function, one of the math and trig functions, adds all of its arguments that meet multiple criteria. For example, you would use SUMIFS to sum the number of retailers in the country who (1) reside in a single zip code and (2) whose profits exceed a specific dollar value.
- Filter by using advanced criteria - Microsoft SupportClick a cell in the list range. Using the example, click any cell in the range A6:C10. On the Data tab, in the Sort & Filter group, click Advanced. Do one of the following: To filter the list range by hiding rows that don't match your criteria, click Filter the list, in-place.
- Guidelines and examples of array formulas - Microsoft SupportThe following formula is used in cell A8 counts the total number of characters (66) in cells A2 through A6. =SUM(LEN(A2:A6)) In this case, the LEN function returns the length of each text string in each of the cells in the range.
More
