如图：求E列中结果的公式只是给出E列字面的东西（字母）即可；如全是单个排列为ABC

网友回答

用函数真复杂,复杂,复杂
=CHOOSE(IF(SUM(A1:C1)>9,3,CHOOSE(COUNTIF($A1:$C1,A1),IF(COUNTIF($A1:$C1,B1)=2,4,1),2,3)),CONCATENATE(LOOKUP(ROUNDUP(LOG(A1,2),0)+1,{1,2,3},{A,B,C}),LOOKUP(ROUNDUP(LOG(B1,2),0)+1,{1,2,3},{A,B,C}),LOOKUP(ROUNDUP(LOG(C1,2),0)+1,{1,2,3},{A,B,C})),2&CONCATENATE(LOOKUP(ROUNDUP(LOG(A1,2),0)+1,{1,2,3},{A,B,C}),LOOKUP(ROUNDUP(LOG(B1,2),0)+1,{1,2,3},{A,B,C})),3&LOOKUP(ROUNDUP(LOG(A1,2),0)+1,{1,2,3},{A,B,C}),2&LOOKUP(ROUNDUP(LOG(B1,2),0)+1,{1,2,3},{A,B,C})&LOOKUP(ROUNDUP(LOG(A1,2),0)+1,{1,2,3},{A,B,C}))