- ©«¤l
- 812
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 862
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¤¤
- µù¥U®É¶¡
- 2010-5-13
- ³Ì«áµn¿ý
- 2019-10-10
|
¦^´_ 6# age54321
A2=INDEX(¦W³æ!A:A,SMALL(IF(¦W³æ!$A$2:$A$10000="AM",ROW($A$2:$A$10000),65536),ROW(A1)))&""
³Ì¥~¼h¬OINDEX¨ç¼Æ¤¤¶¡¬OSMALL¤º¼h¬OIF²z¸Ñ°_¨ÓÀ³¤£Ãø
¤@¯ë¸ûªøªº¤½¦¡¥i¦b½s¿è¦C¤¤¥Ñ³Ì¤º¼h¤½¦¡¥Î·Æ¹«¤Ï¥Õ«á«öF9¦A©¹¥~©µ¦ù¥iª¾¤½¦¡¦p¦ó§@¥Î
IF(¦W³æ!$A$2:$A$10000="AM",ROW($A$2:$A$10000),65536)
°²¦pA2¨ìA10000ªºÈµ¥©ó"AM"´Nµ¹2:10000ªºÈ,§_«hµ¹65536 (65536¬OAÄæ³Ì«á¤@Ó¦ì¸m)
SMALL(IF(¦W³æ!$A$2:$A$10000="AM",ROW($A$2:$A$10000),65536),ROW(A1))
IF¤½¦¡¤¤©Ò±o¨ìªº°}¦C¨ú²Ä´X¤pªºÈ(¨ÌROWªº¦ì¸m¨M©w¨úÈ) |
|