ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] «ü©w¼Æªº²Ä1¦C¦PÄæ¹ïÀ³¼Æ

[µo°Ý] «ü©w¼Æªº²Ä1¦C¦PÄæ¹ïÀ³¼Æ

¥»©«³Ì«á¥Ñ papaya ©ó 2019-10-31 15:21 ½s¿è


½Ð°Ý¤U¦C2­Ó»Ý¨Dªº2003ª©¤½¦¡¡H
1_B8=²Ä6¦C(B6¡JAN6)>20ªº²Ä1¦C¦PÄæ¹ïÀ³¼Æ

2_B9=²Ä6¦C(B6¡JAN6)=<20ªº²Ä1¦C¦PÄæ¹ïÀ³¼Æ

ÁÂÁ¡I

´ú¸ÕÀÉ : «ü©w¼Æªº²Ä1¦C¦PÄæ¹ïÀ³¼Æ.rar (2.1 KB)

°}¦C¤½¦¡:
=IF(COLUMN(A1)>COUNTIF($B6:$AN6,">20"),"",SMALL(IF($B6:$AN6>20,$B1:$AN1),COLUMN(A1)))
=IF(COLUMN(A1)>COUNTIF($B6:$AN6,"<=20"),"",SMALL(IF($B6:$AN6<=20,$B1:$AN1),COLUMN(A1)))

TOP

¦^´_ 2# ­ã´£³¡ªL
ª©¥D : ±z¦n!
­ì¨Ó¬O¥ÎCOUNTIF+SMALL+IF¤~¹ï¡A§Ú¥ÎINDEX+MATCH¡A´N¬OµLªk¥¿½T¶]¥X±Æ§Ç^^"

´ú¸Õ¦¨¥\¡C
·PÁ±zªº¼ö¤ßÀ°¦£©M«ü¾É¡C

TOP

        ÀR«ä¦Û¦b : §Ú­Ì³Ì¤jªº¼Ä¤H¤£¬O§O¤H¡D¥i¯à¬O¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD