帆软固定顺序、条件去重

Posted on 2019-12-24 09:34  zhuyu123  阅读(1358)  评论(0编辑  收藏  举报

固定顺序:

 

 公式=index(列,固定列表)

去重计数:

c列隐藏列

count(UNIQUEARRAY(C3{B3 = $B3 && A3 = $A3 && len(C3) > 0}))

Copyright © 2024 zhuyu123
Powered by .NET 8.0 on Kubernetes