本帖最后由 xuxuxiong 于 2022-7-17 15:34 编辑
分类 | 出院诊断 | 妊娠 | 右侧输卵管壶腹部妊娠流产型 | 妊娠 | 左侧输卵管壶腹部妊娠(流产型) | 妊娠 | 左侧输卵管壶腹部妊娠(流产型) | 粘连 | 右侧输卵管粘连 | 妊娠 | 左侧输卵管壶腹部妊娠(流产型) | 妊娠 | 左侧输卵管壶腹部妊娠(流产型) | 妊娠 | 左侧输卵管壶腹部妊娠流产型 | 妊娠 | 左侧输卵管壶腹部妊娠(流产型) | 其他 | 右侧输卵管积水并扭转 | 妊娠 | 右侧输卵管妊娠壶腹部妊娠(流产型) | 妊娠 | 左侧输卵管壶腹部妊娠流产型 | 其他 | 双侧输卵管绝育术后复通 | 妊娠 | 右侧输卵管壶腹部妊娠(流产型) | 妊娠 | 左侧输卵管壶腹部妊娠流产型 | 妊娠 | 左侧输卵管间质部妊娠 | 其他 | 左侧输卵管积脓 | 目前使用的函数有点繁杂:=IFERROR(LOOKUP(1,0/(FIND({"息肉","肌瘤","妊娠","肿瘤","癌","肉瘤","畸胎瘤","黄体","流产","内膜异位","乳头状瘤","脱垂","囊腺瘤","膜细胞瘤","粘连","腺肌病","鳞状上皮","盆腔炎","失禁","颗粒细胞瘤","囊腺纤维瘤","节育器","排卵障碍","早孕","药流"},B4,1)),{"息肉","肌瘤","妊娠","肿瘤","肿瘤","肿瘤","肿瘤","黄体","妊娠","内膜异位","肿瘤","脱垂","肿瘤","肿瘤","粘连","腺肌病","鳞状上皮","盆腔炎","失禁","肿瘤","肿瘤","节育器","排卵障碍","妊娠","妊娠"}),"其他")
我最初的想法是,比如“*输卵管*妊娠*”的字段归类到“妊娠”疾病组,而“*输卵管*积脓”or“*输卵管*积水”or“*输卵管*积水”等等归类到“输卵管”疾病组。
现在就是不清楚能使用什么样的函数,能筛选出某单元格字段包含A字符(比如输卵管and积水)但又排除B字符(比如妊娠)使我能更精细的进行疾病分类。
谢谢大家!
|