EXCEL户主,妻子,儿子,女儿排序?答:=IF(B2="户主",1,IF(B2="妻",2,IF(B2="夫",3,IF(B2="子",4,IF(B2="长子",4,IF(B2="次子",5,IF(B2="三子",6,IF(B2="四子",7,IF(B2="儿媳",8,IF(B2="女儿",9,IF(B2="长女",9,IF(B2="二女",10,IF(B2="三女"...
请问一下,在WPS或者EXCEL表中怎么把户主和配偶排在前面排在前面?而且...答:首先在A列插入一列 对“与户主关系”一列进行编号,输入公式 A6=IF(E6="户主",1,IF(E6="妻",2,IF(E6="父亲",3,IF(E6="长子",4,IF(E6="长女",5,IF(E6="次子",6,IF(E6="孙子",7)))选中A6:E19,进行升序排列 选中B6:E19进行升序排列,完成排序,删除A列即可 ...