应用LOOKUP函数转换门诊科室分类

目的将现有的门诊科室转换为所需要的科室分类。方法取某医院2009年门诊工作报表,用EXCEL中的LOOKUP函数将报表中的门诊科室名称转换为按专科分类的门诊科室名称,再进行门诊人次汇总。结果设置好科室分类的对应关系后,LOOKUP函数快速地将现有报表的科室设置转换为专科科室分类。结论 EXCEL中的LOOKUP函数可以方便地实现科室转换,结合数据透视表能将大量数据按需要进行复杂的分类统计,适应不同的分析要求。

Conversion of Out-patient Department Classification with LOOKUP Function

Objective To convert existing out-patient departments＇ names to required department classifications.Methods Out-patient department names in work report of a hospital in 2009 were converted to those classified by LOOKUP function in EXCEL,and person-time outpatient service were summarized.Results After setting up corresponding department classification,existing departments＇ names were quickly converted to special department classifications with LOOKUP function.Conclusion Conversion between departments can be conveniently achieved with LOOKUP function in EXCEL,when combined with Pivot Table,complex classification and statistics can be conducted on a large amount of data on demand for various analysis and requirements.