[已解决]关于特定条件统计显示的问题

jf530qy

求高手帮忙，感谢
[img]blob:http://www.excelpx.com/8535bac4-3229-4139-8136-b086f1288a2f[/img]

最佳答案

月排行榜 / 总排行榜

魚。。

2023-3-2 15:26

G2公式：（下拉）

1. =IFNA(REPT("混-",COUNT(0/COUNTIF(B3:F3,{"低","中","高","特"}))>1)&MID("低中高特",MATCH(,-MATCH({"低","中","高","特"},B3:F3,)),1),"")

复制代码

跳转到最佳答案楼层

砂海

举例 要完整 准确 , 不然有太多可能

魚。。

G2公式：（下拉）

1. =IFNA(REPT("混-",COUNT(0/COUNTIF(B3:F3,{"低","中","高","特"}))>1)&MID("低中高特",MATCH(,-MATCH({"低","中","高","特"},B3:F3,)),1),"")

复制代码

cutecpu

=IF(SUM(LEN(UNIQUE(B3:F3,1)))>1,"混-","")&MID(" 低中高特",MAX(FIND(B3:F3," 低中高特")),1)