Von | search
Click here to view Von news from 60+ newspapers.
Bookmark or Share- Find or replace text and numbers on a worksheetUse the Find and Replace features in Excel to search for something in your workbook, such as a particular number or text string. You can either locate the search item for reference, or you can replace it with something else. You can include wildcard characters such as question marks, tildes, and asterisks, or numbers in your search terms.
- Using IF with AND, OR, and NOT functions in ExcelIn 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.
- Look up values with VLOOKUP, INDEX, or MATCH - Microsoft SupportHere's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE) In this example, B2 is the first argument —an element of data that the function needs to work. For VLOOKUP, this first argument is the value that you want to find. This argument can be a cell reference, or a fixed value such as "smith" or 21,000.
- Split text into different columns with functions - Microsoft SupportThis article shows you how to extract various components from a variety of name formats using these handy functions. You can also split text into different columns with the Convert Text to Columns Wizard.
- Filter for unique values or remove duplicate valuesTo filter for unique values, select Data > Sort & Filter > Advanced. To remove duplicate values, select Data > Data Tools > Remove Duplicates. To highlight unique or duplicate values, from the Home tab, use the Conditional Formatting command in the Style group.
More
