excel彩通吧 关注:5贴子:65
  • 0回复贴,共1

统计单位数的个数从多到少,从上到下排列

只看楼主收藏回复

=IF(ROW(A1)>SUM(N(COUNTIF($H$8:$CNW$8,ROW($1:$10)-1)
>200)),"",RIGHT(LARGE(IF(COUNTIF($H$8:$CNW$8,ROW($1:$10)-1)
>200,COUNTIF($H$8:$CNW$8,ROW($1:$10)-1)*10+ROW($1:$10)-1),ROW
(A1))))


IP属地:山东1楼2015-04-25 11:45回复