¥»©«³Ì«á¥Ñ ziv976688 ©ó 2019-12-9 11:52 ½s¿è
¦³ª¦¤å¨ì¤£³W«h¸õ¦CӼƥ[Á`ªº2003ª©¨ç¼Æ¤½¦¡
https://blog.xuite.net/hcm19522/twblog/588557495
=COUNT(0/(IF(ISNA(MATCH(ROW(A3:A51),SMALL(IF(A3:A51="",ROW(3:51)-{0,1}),ROW(1:19)),)),A3:A51)<6)) °}¦C
½Ð¸Ô¨£Sheet1!A1ªº¤½¦¡¡C
·Q®M¥Î¦bSheet2!A1
¦ý¤£¸Ñ¤½¦¡¤¤ROW(1:19)ªº¥Ñ¨Ó¡AµLªk±o¨ì¥¿½Tµª®×¡C
EX¡JSheet2!A2
=COUNT(0/(IF(ISNA(MATCH(ROW(A3:A71),SMALL(IF(A3:A71="",ROW(3:71)-{0,1}),ROW(1:19)),)),A3:A71)<6)) °}¦C
Sheet2!A2¡JC2ªº¥[Á`Ó¼Æè¦n³£=Sheet2!A1¡JC1ªº¥¿½Tµª®×+1Ó¡C
½Ð°Ý¡JSheet2!A1ªº¥¿½T¤½¦¡¡H
ÁÂÁ¡I
´ú¸ÕÀÉ :
¤£³W«h¸õ¦CӼƥ[Á`.rar (3.94 KB)
|