First, enter the function COUNTIF($G$2:$G$2 1, G2) in the blank cell of the same row in excel, and then drop it down to the last row of all data. $G$2:$G$2 1 is an absolute reference to the data range to be searched.
The value of 1 indicates that the data appears once without duplication, the value of 2 indicates that there are two identical data, and the value of 3 indicates that there are three identical data. If the data exceeds 15 bits, write = countif (a: a, a1&; "*"), drop down.
Extended data:
The law of duplicate checking of graduation thesis;
1, paragraphs and format of the paper
Paper detection is basically the whole article upload. After uploading, the paper detection software first divides it, and the final manuscript format has a great influence on the plagiarism rate. The division of different paragraphs may cause small paragraphs of dozens of words not to be found. So we can reduce the plagiarism rate by dividing more small paragraphs.
2. Database database
Paper detection mostly aims at matching published graduation papers, periodical papers and conference papers, and some databases also contain some articles on the Internet.
3, chapter conversion
Changing the order of chapters or extracting different articles from different articles has little effect on the results of plagiarism detection. Therefore, it is recommended not to think that copying a few or dozens of articles will pass.