½Ð±Ð¦p¦ó²Î­p­Ó§O¤H­ûªº¤£­«½ÆªÑ²¼²M³æ

peter460191

½Ð±Ð¦p¦ó²Î­p­Ó§O¤H­ûªº¤£­«½ÆªÑ²¼²M³æ,¤£¦n·N«ä!ªþ¥ó¤W¶Ç¤£¤F~~

¤U¸ü (100.42 KB)

2021-6-28 13:45

peter460191

¦^´_ 15# hcm19522

¥i¥H¥Î¤F,±`·PÁ±z! hcm19522
§A­Ì¯uªº¦n¼F®`³á!

hcm19522

¦^´_ 14# peter460191


    {=SUM(IFERROR((B$2:B$99=E2)/COUNTIFS(A$2:A$99,A$2:A$99,B$2:B$99,B$2:B$99),))

peter460191

¦^´_ 13# hcm19522
­pºâ¥X¨Ó¬O­ÓªÑ¦WºÙ,¤£¬O²Î­p«áªº¼Æ¶q,¬O§Ú­þ¸Ì§Ë¿ù¤F¶Ü?

hcm19522

¦^´_  hcm19522
½Ð°Ýhcm19522
­Y½d³ò¤£©T©w­n¦p¦ó§ï¨ç¼Æ,¦]¬°¥u­n¦³ªÅªºÀx¦s®æ®É´N¤£¯à­pºâ¤F !
peter460191 µoªí©ó 2021-6-30 13:42

    {=IFERROR(INDEX(A:A,RIGHT(SMALL(IF(MATCH($A$2:$A$99&$B$2:$B$99,$A$2:$A$99&$B$2:$B$99,)=ROW($1:$98),MATCH($B$2:$B$99&"",$E$2:$E$7&"",)/1%%+ROW($2:$99)),ROW(A1)),4))&"","")

peter460191

¦^´_ 8# hcm19522
½Ð°Ýhcm19522
­Y½d³ò¤£©T©w­n¦p¦ó§ï¨ç¼Æ,¦]¬°¥u­n¦³ªÅªºÀx¦s®æ®É´N¤£¯à­pºâ¤F !

peter460191

¦^´_ 8# hcm19522
ÁÂÁ±z~~
¥i¥H¥Î¤F,­nªáÂI®É¶¡¨Ó¬ã¨s¤F..

peter460191

¦^´_ 8# hcm19522
«D±`ÁÂÁÂ hcm19522
¥i¥H¤F,¨ç¼Æ¤]¥i¥H¤F,§A­Ì¯u¬O¤Ó±j¤F,­nªá¤@ÂI®É¶¡¨Ó¬ã¨sVBA&¨ç¼Æªº¨âºØ¼gªk
¦A¤@¦¸ÁÂÁ§A­Ì.

samwang

¦^´_ 7# peter460191

¥[¤F¥Î¨ç¼Æ¤è¦¡ªí¥Ü¡A½Ð¦A´ú¸Õ¬Ý¬Ý¡AÁÂÁÂ

hcm19522

https://blog.xuite.net/hcm19522/twblog/589860035