摘要
探讨Excel软件中常用的IF,OR,COUNTIF,VLOOKUP等函数在肿瘤登记病例查重中的应用。全文介绍了函数的涵义和使用方法,并举例对录入前查重和录入后查重进行说明。这些方法对使用CanReg4进行数据录入统计的基层肿瘤登记点进行重卡查找和剔除有一定的实用价值。
To investigate the application of Excel functions such as:IF, OR, COUNTIF,VLOOKUP in finding duplicate cards in cancer registration. In this article, the meaning and using method of these functions were introduced at first, and then examples were taken to explain the operation of finding duplicate cards before and after data entry. These methods will be very useful to find and delete duplicate cards for those registries using CanReg4 to enter cancer registration data.
出处
《中国肿瘤》
CAS
2014年第10期825-828,共4页
China Cancer