老师，公司排名

dabianjiji111

老师，根据月总数据，把公司名称排名，不重复，全部显示

quqiyuan

1. =UNIQUE(TAKE(SORT(Sheet1!$A$4:$C$88,2,-1),,1))

复制代码

高个子

1. =IFERROR(INDEX(UNIQUE(SORT(Sheet1!$A$4:$C$88,2,-1)),ROW(A1),1),"")

复制代码

无聊的黑猫

=IFERROR(INDEX(UNIQUE(SORTBY(Sheet1!A$4:A$88,SUMIF(Sheet1!$A$4:$A$88,Sheet1!$A$4:$A$88,Sheet1!$B$4:$B$88),-1)),ROW(A1)),"")

dabianjiji111

无聊的黑猫 发表于 2023-5-13 09:32
=IFERROR(INDEX(UNIQUE(SORTBY(Sheet1!A$4:A$88,SUMIF(Sheet1!$A$4:$A$88,Sheet1!$A$4:$A$88,Sheet1!$B$4 ...

=IFERROR(INDEX(sheet1!$A$4:$A$10000,MATCH(LARGE(OFFSET(sheet1!$A$4:$A$10000,,MATCH($B$1&"月总",sheet1!$1:$1&sheet1!$2:$2,)-1),ROW($A4)-ROW($A$3)),OFFSET(sheet1!$A$4:$A$10000,,MATCH($B$1&"月总",sheet1!$1:$1&sheet1!$2:$2,)-1),)),"")

老师，这个公式修改一下，有重复值

无聊的黑猫

=IFERROR(INDEX(UNIQUE(SORTBY(Sheet1!$A$4:$A$92,SUMIF(Sheet1!$A$4:$A$92,Sheet1!$A$4:$A$92,OFFSET(Sheet1!$A$4:$A$92,,MATCH($B$1,Sheet1!$B$1:$C$1,0))),-1)),ROW(A1)),"") 一样WPS可用 你说有重复项 那就是按同公司求和数据多到少排名对吧 已经去重了 后面的数据用下SUMIF就好

dabianjiji111

无聊的黑猫 发表于 2023-5-13 10:09
=IFERROR(INDEX(UNIQUE(SORTBY(Sheet1!$A$4:$A$92,SUMIF(Sheet1!$A$4:$A$92,Sheet1!$A$4:$A$92,OFFSET( ...

老师，辛苦