怎么把Excel的数据相同的归类答:T2输入公式:“=IF(Q2="","",Q2)”;U2输入公式:“=IF(T2="","",INDEX(B:B,MATCH(T2,A:A,0)))”;V2输入公式:“=IF(ISNA(MATCH($T2,C:C,0)),"",$T2)”;W2输入公式:“=IF(V2="","",INDEX(D:D,MATCH(V2,C:C,0)))”;X2输入公式:“=IF(ISNA(MATCH($T2,E:E...
excel 怎么用函数把数据归类答:vlookup就行了,欢迎追问 首先,你得有各城市及其所属区域的对照表,以供查询。或者这样 =IF(OR(A1={"上海","上海西","上海南"}),"华东",IF(OR(A1={"北京西","北京南","北京北","北京东","北京东南"}),"华北","华南"))不好意思,信手写来,有点小错误,现已纠正 ...