There are two word files, which are lists, how can I quickly find the same name in them?

Copying the person's name into Excel can be solved by using a function.

Put the names of the people in both lists in column A of the excel sheet.

Enter the formula =countif(a:a,a1) in cell b1 to copy b1 downward, and then filter, the value of 2 is repeated.

Copy and paste the filtered data into a new worksheet, and then delete the rows that are followed by 2, to delete them line by line, originally there will be two identical names on this table, as long as one is deleted, the other will become 1 after the other, so just delete the rows that are 2 one by one. (Remove Duplicates).

Finally, save the file in text format (txt), then open the text file and copy it, and then paste it into word. (Remove**).

You copy the content of one of them to another, or create a new one, and then look for it in the new document, ctrl + f will appear on the search page, and then you enter the name that you personally think is likely to be repeated, enter, you will find the name that there is **, and then delete one of them, you can do it.

If you don't understand, Q me, 594046522

Open the file with the latest changes: Tools - Compare & Merge Files - Select your other file - Merge...

How to find duplicate names in a word document? When there is too much content in a word document, it is troublesome to filter the data, so how to filter duplicate names in a word document? The following is an introduction to the method of screening duplicate names in word documents, I hope it will be helpful to you.

Step 1: Open a Word document that needs to be filtered for duplicate names.

Step Two: In the Start menu, click to select the Find option on the right side.

Step 3: A navigation will pop up on the left side of the document.

How to filter duplicate names in word documents (method 2).

Step 1: Open the Word document that needs to filter duplicate names, and press Ctrl+F to pop up the navigation.

3Step 3: Click on the upper and lower triangles behind the result, and the selected result will be switched.

Execute the "-Find" command in the menu bar of the Word document to open the "Find and Replace" dialog box, in the "Find" page, enter the duplicate text you want to find, and then click the "Find Next" button, you can find whether the document you want to find is duplicated.

Open the word document, and then press Ctrl+F to enter the name you want to find in the dialog box, if you find it, it will automatically jump to, if you can't find it, it will prompt.

The specific steps to find the same name in two excel lists are as follows:

1. First of all, we turn on the computer and use the excel software in the computer to open two **, Table 1 contains two columns of names and dormitory numbers.

2. Table 2 contains two columns: name, grade and dormitory number, we look for the same name in Table 2 in Bigo, and the dormitory number in Table 2 shows the dormitory number corresponding to the same name in Table 1 and Table 2.

3. Select cell C2, click FX, and find the vlookup function.

4. The search value here is the name, that is, the same information of the two tables.

5. The data table is column A and B in Table 1, because it is queried in Table 2, and the dormitory number corresponding to Table 1 is queried through the same name in Table 2 and Table 1.

6. The ordinal number of columns is to select the two columns A and B in Table 1, so fill in 2 and fill in FASE for matching conditions.

7. Put the mouse in the lower right corner of **, a solid cross line appears, hold down the left mouse button to fill in, and the desired result will be completed.

Workaround:

Method 1: Function formula method.

Step 1: Enter your data.

How to find data with duplicate names in excel-1

Step 2: Insert the column that needs to display the repeat prompt, here column C is taken as an example.

excel how to find data with duplicate names - 2

Step 3: Insert the formula (see Figure 3) and then populate the drop-down sequence. If you don't understand the formula, press F1 to find the help file.

excel how to find data with duplicate names - 3

Step 4: Filter the data.

excel how to find data with duplicate names - 4

Method 2: Non-formula method.

This method comes with Office2007, and you can find duplicate data without formulas.

Step 1: Enter your data.

excel how to find data with duplicate names - 5

Step 2: Select the column or region that needs to be checked for data duplicates, then click the "Start" tab, find the "Style" option group, click the "Conditional Formatting" option, and select "Duplicate Values" in the first option "Highlight Cell Rules" in the drop-down list. As shown in the figure below:

excel how to find data with duplicate names - 6

Step 3: Set the style of duplicate value display in the pop-up "Duplicate Value" dialog box.

excel how to find data with duplicate names - 7

Step 4: Filter the data by color.

With the vlookup function, it will be implemented very quickly, even if you are looking for 1000 out of 10000.

I found out that there are 2 copies, just modify a:a to the data column of another list, or it can be a different workbook.

Send the problem as an attachment to the content and sample table (please note: if you want to be in the 03 version, the current situation and target effect will be displayed).

1. First find the word document, and then click the document to open.

2. After opening, press and hold the Ctrl+F key to open the Find and Replace function key.

3. After opening, enter the content you need to find in the Find Content column, and then click Find Next.

4. In this way, the system will mark the found content with different colors, so that you can query the duplicate names.

1. Select all the text, and the shortcut key is Ctrl+A

2. Press Ctrl+F to search (F is the prefix of English find), and enter "Li Ming" in "Search content".

To make a replacement, simply click the Replace menu, enter what you want to replace in the Replace With tab, and click Replace All.

Import the list into Excel and do the following.

Let your data be listed in column a

The first method: Select all in column A, menu --> formatting -> conditional formatting --> leftmost selection"Formula", enter:

countif(a:a,a1)=2

Then set the format of the cell display after the duplicate value is found.

The second method:

Enter the formula in b1:

ctrl+f

Directly enter it, and then the next one.

Ctrl+H, replace the search, and enter it directly.

Use the word search function,And then there's a highlight below all the items found in the range.,As for more than 100 names.,If you're not tired.,You can search one by one.,Batch words,I don't have a good way.。 I'm using WPS, and the function is similar, and the principle is the same.

- Find - Enter what you want to find, click Find All under the box selection in front of "Highlight all items found in this range" to see it.

Use the search command (shortcut key ctrl+h) to find it 100 times.

You can use the dos command fc to compare two files.

Command formats are everywhere on the web.

You copy and paste both documents into excel, note that paste them into one file to make different sheets: sheet1, sheet2. Then right-click on sheet1 and select all worksheets, at this time, the content you are looking for in sheet1 can also be seen in sheet2, you can try.

There's an option to look it up.,I can't remember exactly where.,If no one tells you about it, I'll do my own research.

1. Put data 1 on "sheet1".

2. Put data 2 on "sheet2".

3. Enter "=if(countif())) on cell B2 of sheet1

4. Place the mouse in the parentheses in the middle of "=if(countif())) and click sheet2 to select all data.

5. Go back to the formula of sheet1 and enter "=if(countif(sheet2!."a1:a20,a1),"s","f")”。

6. Press enter, the data displayed as s means that the data in sheet2 is in sheet1, and the data displayed as f is not.

7. Pull down and fill in from this row, and all the data can be filtered.

4. Filter out the dark red cells, which is the duplicate name you want, and the name without color filling is a different name.

5. Complete the renderings.

1. First, we open Excel to create what you want to filter and select this column. Let's take Zhang 1, Zhang 2, Zhang 3, Zhang 1, and Zhang 4 as examples.

2. Then find Start, Conditional Formatting, highlight the cell size and duplicate values.

3. After that, we click on the option to select the duplicate value and click on the small triangle to select the color.

4. Finally, click on the OK value to select it. You will find that the same name has been displayed in the same color.

How do I filter the same data between two excels?

Let's say these two tables are two sheets of the same workbook.

sheet1 and sheet2

And the names are all in column A.

Enter cell B1 in sheet1.

if(countif(sheet2!a:a,a1)>0,"Same","")

The x drop-down selectively pastes column b as a numeric value.

Filter by column B.

The specific steps to quickly find duplicate content in the same word file are as follows:

1. First click on the computer to open the word document you want to operate, and then use the mouse to select the text or paragraph you need to find in this document.

2. Then in this page, press and hold the "Ctrl+F" key on your keyboard at the same time.

3. Then the "View and Replace" dialog box will pop up, and enter the content you need to find in the text box after the "Find Content" item in this dialog box.

4. Then click on the "Find Next" option below, and then you can find all the duplicate content.

1. First, right-click and select a piece of text to be found.

2. Then press and hold Ctrl+F at the same time to bring up the Find function key.

3. Then enter the content you need to find in the Find Content box, such as people.

4. After entering the person, click on the next place below, and the system will automatically find it.

Take advantage of the Find feature.

1. Press CTRL+A to select all contents.

2. Press CTRL+F to bring up the "Find" dialog box.

3. Enter the search content, such as "person", and then press "Find Next", and the system will automatically search.

There is a powerful function called wildcards in word, if you just want to find duplicate content, ctrl+f can completely satisfy, if you need to find duplicate paragraphs, a simple search will definitely not work.

If it is a continuous repeating paragraph:

Click: Replace.

Tick the wildcard.

Find what: (13) ([13]@13).

Replace with: 1 2

Replace them all. Repeat it and see if it's replaced (a paragraph is generally not repeated more than 255 times, hehe), if not, just do it a few more times, until.

The number of substitutions is 0.

This command is very efficient! Thousands of pages can be completed in an instant!

If it's a discrete repetitive paragraph:

Click: Replace.

Tick the wildcard.

Find what:( 13[!.]^13]@^13)(*1

Replace with: 13 1 2

Replace them all. Repeat a few times, until the number of substitutions is 0.

This command can take a long time for hundreds of pages of documents, because to perform a circular comparison, please be patient!

enjoy!

Find what:( 13[!.]^13]@^13)

Replace with: 1

The meaning of this paragraph:

13 indicates a paragraph marker, [!.]for "not", [13] for any single character other than paragraph markers; @表示一个以上的前一字符或表达式, it follows [!

13] together to denote more than one character outside of the paragraph marker, 13[!].13]@ 13 is a non-empty paragraph that contains the markers of the preceding and following paragraphs, with any characters; Enclose it in parentheses (13[!.).13]@ 13), which means that this part is identified, which is the first part of our identification, and the 1 in the box is replaced below!

Represents at least n

The previous character or expression, then of course it means 2 or more of these paragraphs (parenthetically enclosed parts), note that they should be exactly the same paragraph! Note that @ can not be used instead of @, if @ is used, because it also includes the case of "one", then when executing, all the non-repeating paragraphs will also be replaced by itself, and the execution efficiency will be greatly reduced!

Digression: How nice it would be if there was a ** in the regular expression that means "two or more"!

In addition, in this paragraph, [!13] I think this idea is better to use! The computer is easy to judge, hehe! ]