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

[µo°Ý] ¨ç¼Æ ¨ú§t¦³ÃöÁä¦rªºÀx¦s®æ¤º®e+ÁY±Æ

[µo°Ý] ¨ç¼Æ ¨ú§t¦³ÃöÁä¦rªºÀx¦s®æ¤º®e+ÁY±Æ

¥¼©R¦W.png
2020-4-7 10:02

¨ç¼Æ ¨úÃöÁä¦r+ÁY±Æ.rar (2.71 KB)
B3
=¨úAÄæ§t¦³ÃöÁä¦r"³s"ªºÀx¦s®æ¤º®e
¤U©Ô
+©¹¤WÁY±Æ

½Ð±Ð¡JB3ªºExcel 2003ª©¨ç¼Æ¤½¦¡¡C
ÁÂÁ¡I

¸É¥R :
AÄ榳ÃöÁä¦r"³s"ªºÀx¦s®æ¤º®e¤£·|­«½Æ¡C

TOP

°}¦C:
=INDEX(A:A,SMALL(IF(ISERR(FIND("³s",A$1:A$72)),4^8,ROW($1:$72)),ROW(A1)))&""

¤@¯ë:¤£­«ÂÐ
=LOOKUP("z",IF({1,0},"",VLOOKUP("*³s*",OFFSET(A$1,IF(ROW(A1)=1,,MATCH(B2,A:A,)),,999),1,)))

TOP

¦^´_ 3# ­ã´£³¡ªL
­ã´£ª©¥D : ¤È¦w !
ÁÂÁ±zªº¤£§[½ç±Ð¡I·P®¦^^

TOP

        ÀR«ä¦Û¦b : ¤£­n¤p¬Ý¦Û¤v¡A¦]¬°¤H¦³µL­­ªº¥i¯à¡C
ªð¦^¦Cªí ¤W¤@¥DÃD