How to find out the same data in different columns in Excel

Press Ctrl+F.

Enter what you want in the search field.

Click on all of them to display them one by one.

Press the Ctrl key.

Select the items you want.

In the Start menu, in the menu of Fonts.

Click on the one that looks like a keg.

Just choose the color you want in it.

This is my personal opinion.

FYI.

The landlord can "data" filter Advanced filter Select column A in the list area, select column B in the condition area OK "Fill in color" with the same data, and then "data" filter Show all, it's OK, I hope it will be useful to you, the other methods are either complicated or difficult to understand (for beginners).

Select all the columns that need to be searched for data, and click "Format-Conditional Format-Cell Value=A1, A2, A3....

Format: Font or pattern color, set to different colors by: Condition 1, Condition 2, Condition 3, the same data is obvious. I don't know if it helps you.

1. Open Excel** on the computer.

2. Enter the formula =vlookup(h6,$d$6:$e$11,2,0) in another column to be found, h6 is the value to be found, $d$6:$e$11 is the absolute value of the area to be found, the absolute value should be pressed f4, 2 is the number of columns of the search area, and 0 is the exact match.

3. After entering the formula, press enter, and you can match the value of another column.

4. Drop down the formula.

Use the function vlookup

The form is =vlookup(keyword, the area of another column [the first column is the keyword area], the first columns of the region, false).

1. For example, =vlookup(C1,F1:J10,2,False), it means that in the F1:J10 area, find which of the 10 cells F1-F10 is equal to C1 (such as C7), and return the value for column 2, that is, column G (G7).

2. Note: false can be copied from this value (write ture can only find English, false can find Chinese).

3. The format of the keyword cells must be exactly the same, otherwise it cannot be found (such as text, it cannot correspond to numbers).

Answer: I recommend you to use the vlookup function, the vlookup function is a longitudinal search function in excel, it belongs to a class of functions with the lookup function and the hlookup function, and is widely used in work. vlookup is to search by column, and finally return the value corresponding to the query column order required for the column; lookup value is the value that needs to be searched in the first column of the data table. The lookup value can be a numeric value, a reference, or a text string.

The syntax rules for the vlookup function are as follows:

1. vlookup(lookup value,table array,vlookup function syntax rules:

vlcol_index_nowum,range_lookup)。

The vernacular translates to vlookup (the value to be found, the range to be found, the value of the columns to be returned, the exact match fuzzy match).

2. lookup value: is the value to be found in the first column of the lookup range.

3. table array: For the search range, note that the first column of the search range is the value to be found.

4. col index num: the sequence number of the data column to be returned. Note: This ordinal number is the column number of the search range you selected, not column A as the first column.

5. Range lookup: is a logical value, which refers to whether the lookup is an exact match or a fuzzy match. If false or 0, an exact match is returned, and if it is not found, an error value of n a is returned.

If it is ture or 1, the result of a fuzzy match is returned. Exact matches are often used at work.

Select which column -> Sort -> select "Expand Selected Area" in the Sort By > to confirm.

This sorts all rows based on that column, and the same data in that column is grouped together. After tidying up, you can sort ** according to the column on which the previous sorting was based.

If there is no rule in the previous data sorting, you can add a secondary column, enter 1 in the first row, enter 2 in the second row, scroll down to the end, and then do the same as before. After tidying up, sort the column in ascending order, and finally delete the column.

The specific steps to use the matching formula vlookup are as follows:

Tools:Lenovo computer, keyboard, friendly mouse.

1. Select the cell first.

2. Enter the vlookup function.

3. Then look for the basis.

4. The area where the number of songs is located.

5. The column where the final result is located.

6. Enter false for exact matching.

7. Click Enter.

and pull down the fill.

1. Create a new excel** and enter the number of the example in the cell.

2. Select the cells that need to be searched.

3. Click on the "Conditional Formatting" option in the "Start" option in the toolbar.

4. Click "Conditional Formatting" and select "Highlight Cell Rules" in the pop-up option box.

5. After that, select the "Duplicate Value" option.

6. Click OK in the pop-up "Duplicate Value" dialog box, and you can see that the duplicate value of the selected cell is marked in red.

Click the "Advanced filtering" icon. Click "Copy filter results to another location". Select "List Area" and click on a cell range.

Select "Conditional Region" and click another cell range. Select "Copy to", click any cell, and then click "OK". Excel has looked up the same data and extracted it, detailed steps:

1. Open the computer**, and click the "Advanced Filtering" icon in the "Data" interface.

2. In the Advanced Filtering window, click "Copy Filtering Results to Other Locations".

3. Select "List Area" and click a cell range.

4. Select "Condition Region" and click another cell area.

5. Select "Copy to", click any cell, and then click "OK".

6. Excel has found the same data and extracted it.

The quick analysis function in Excel 2016 can quickly find cells with the same content in the same column, the specific steps are as follows:

1. Select the cells you need to find.

2. Click the "Quick Analysis Button" in the lower right corner (shortcut key Ctrl+Q) and select the duplicate value function.

3. Excel will automatically fill the duplicate content in light red, and the cells with the same content can be distinguished at a glance.

4. If you need to filter out the same content, click the filter function and select "Filter by color" to filter out the same content.

1. First of all, you need to select all the cells you want to find data, and then find them in the toolbar in turn"Get started"-"Style"；

2. Click in the style"Conditional formatting"and then select again"Highlight the wandering divination to show the cell rules"-"Duplicate values", as shown in the figure below;

3. Then the duplicate value dialog box will pop up, and we can freely set a way of annotation, such as the display of text with different colors and borders of different colors.

4. We can also choose from the above conditional formats"Create a new rule"，<>

5. Then select in the dialog box"Only unique or duplicate values are formatted"-"Format"；

6. Finally, it is found in the Format Cells dialog box"Filling"It is also possible to choose a color that is needed to label the same data just filtered out, as shown in the figure;

7. Complete the renderings.

You can do this by following the steps below.

1. Open ** on our computer to find duplicate data in the same column, as shown in the figure below.

2. After opening**, click [Sakura Early Data] and then click [Highlight Duplicates].

3. Select [Set Highlight Duplicates] in the highlighted duplicates.

After the 4. After the spine row finch, highlight and repeat the display value interface, select the column of data you are looking for, and here you are selected in column c.

5. You can see that all the duplicate data in a column is highlighted, so that the duplicate data can be found.

6. If we don't want to highlight duplicate data, click [Data] and then click [Highlight Duplicates] and then click [Clear Highlighted Duplicates] to restore the normal ** style.