麻烦大神解答一下,在excel中如果某个单元格里满足多项关键字中的一项...答:在A1输入内容 在B1中输入或复制粘贴下列公式 =IF(OR(A1={"安徽","江苏","浙江","上海"}),1,IF(OR(A1={"北京","四川","云南"}),2,IF(OR(A1={"新疆","西藏","甘肃"}),3,"")))
关于excel排名问题!请大神帮帮忙!答:如图所示 E2公式:=IF(ROW(A1)>D$2,"",INDEX(A:A,MATCH(LARGE(IF((B$2:B$100>0)*(B$2:B$100>=LARGE(B$2:B$100,D$2)),B$2:B$100,),ROW(A1)),B:B,)))F2公式:=IF(ROW(A1)>D$2,"",INDEX(A:A,MATCH(SMALL(IF((B$2:B$100<0)*(B$2:B$100<=SMALL(B$2:B$...