- ©«¤l
- 41
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 52
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows10
- ³nÅ骩¥»
- 2019
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2017-11-28
- ³Ì«áµn¿ý
- 2025-3-4

|
¦^´_ 4# quickfixer
¦A«×ÁÂÁ¤j¤j´£¨Ñ¤èªk¡A¦ý¦]¦Ò¶q²Å¸¹¦]¯À©M¥¼¨Ó some_array=SMALL(IF(arange=¬ö¿ý!$F3,ROW(brange)-1,""), ROW(INDIRECT("1:"&COUNT(IF(arange=¬ö¿ý!$F3,ROW(brange),"")))))
³oÓ ¬ö¿ý!$F3 ·|®Ú¾Ú¤u§@ªí¡G ¨Ò¦p ²Ä1¶g!F3 / ²Ä2¶g!F3 ....¨Ì¦¹Ãþ±À
¥i¯àn³Ð³y100Ó¦WºÙ....
©Ò¥Hè観§ä¨ì¥t¤@Ӥ覡¡A¥u¥i±¤¨S¿ìªk Åý¨ä¥L¶g¦P®É¥X²{¤@¼Ëªº¤å¦r½}¤F...
G3 =TEXTJOIN(":",TRUE,IF(($B$2:$B$30=F3)*($C$2:$C$30<>""),IF(MATCH($C$2:$C$30,$C$2:$C$30,0)=(ROW($C$2:$C$30)-MIN(ROW($C$2:$C$30))+1),$C$2:$C$30,""),""))
¥Ø«e¬O§Æ±æ¯àÅý²Ä3¶g ¯à¶]¥X ¬Û¦Pªº¤å¦r
¸Ñ¨M¤FªÅ¥Õ©M«½Æ¡A«o³y¦¨¨ä¥L¶g«½Æ¶]¤£¥X¨Ó «¢«¢
¦A«ô°U¦U¦ì¤j¤j¨ó§U¤F
TEST03.zip (13.26 KB)
|
|