Taking the four Chinese medical citation databases as an example, the paper uses Excel function and VBA editing language to realize the automatic de-duplication of database citation retrieval results with various resources, judges the self-citation times of an individual author and a group author accurately as well as the number of collected citations of each database, and increases the accuracy of the retrieval results of collection and citation as well as work efficiency.