Filter for unique values or remove duplicate values
To filter for unique values, click Data > Sort & Filter > Advanced. To remove duplicate values, click Data > Data Tools > Remove Duplicates. To highlight unique or duplicate values, use the Conditional Formatting command in the Style group on the Home tab.
Find and remove duplicates - Microsoft Support
Find and remove duplicates. Sometimes duplicate data is useful, sometimes it just makes it harder to understand your data. Use conditional formatting to find and highlight duplicate data. That way you can review the duplicates and decide if you want to remove them.
How to compare data in two columns to find duplicates in Excel
Method 1: Use a worksheet formula. Start Excel. In a new worksheet, enter the following data as an example (leave column B empty): Type the following formula in cell B1: =IF (ISERROR (MATCH (A1,$C$1:$C$5,0)),"",A1) Select cell B1 to B5. Select Fill …
FIND, FINDB functions - Microsoft Support
The FIND and FINDB function syntax has the following arguments: Find_text Required. The text you want to find. Within_text Required. The text containing the text you want to find. Start_num Optional. Specifies the character at which to start the search. The first character in within_text is character number 1.
Look up values with VLOOKUP, INDEX, or MATCH - Microsoft …
Here'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.
Find or replace text and numbers on a worksheet
Use 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.
Count unique values among duplicates - Microsoft Support
Count the number of unique values by using a filter. You can use the Advanced Filter dialog box to extract the unique values from a column of data and paste them to a new location. Then you can use the ROWS function to count the number of items in the new range.
Find cells that contain formulas - Microsoft Support
Find merged cells. Find ranges by using defined names. Remove or allow a circular reference. Find hidden cells on a worksheet. To find cells that contain formulas, click Home, Find & Select, and Go To. Click Special, and then click Formulas. You can search part or all of a worksheet.
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. These characters can be the asterisk (*), the question mark (?), and the tilde (~).
LINEST function - Microsoft Support
The LINEST function calculates the statistics for a line by using the "least squares" method to calculate a straight line that best fits your data, and then returns an array that describes the line.
Excel functions (by category) - Microsoft Support
Worksheet functions are categorized by their functionality. Click a category to browse its functions. Or press Ctrl+F to find a function by typing the first few letters or a descriptive word. To get detailed information about a function, click its name in the first column.