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

½Ð°Ý¦p¦ó­pºâ±m²¼´X´Á¥¼¶}ªº¤è¦¡

½Ð°Ý¦p¦ó­pºâ±m²¼´X´Á¥¼¶}ªº¤è¦¡

·Q½Ð°Ý«e½ú­Ì¦p¹Ï¦³¤½¦¡¯àÅã¥Ü¬°´X´Á¥¼¶}¶Ü? ©Î¦³¨ä¥L¤è¦¡¯à¹ê²{ ÁÂÁÂ





¤µ±m.rar (75.25 KB)

¦^´_ 1# eric7765


    ÁÂÁ«e½úµoªí¦¹¥DÃD»P½d¨Ò
«á¾ÇÂǦ¹©«½m²ßVBA°}¦C»P¦r¨å,¾Ç²ß¤è®×¦p¤U,½Ð«e½ú°Ñ¦Ò

¤µ±m_20230915.zip (106.12 KB)

°õ¦æ«e:


°õ¦æµ²ªG:
¥Î¦æ°Ê¸Ë¸mÂsÄý½×¾Â¾Ç²ß«Ü¤è«K,ÁÂÁ½׾¸gÀç¹Î¶¤
½Ð¤j®a¤@°_¤W½×¾Â¨Ó¥æ¬y

TOP

H2 (©¹¤U´X´Á¥X²{  ¦P´Á¥X²{¬° 0   ©¹¤UµL¥X²{¬°ªÅ)=IF(COUNTIF($C2:$G2,H$1),,IFERROR(MATCH(1,MMULT(N($C3:$G$250=H$1),{1;1;1;1;1}),),""))
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¥»©«³Ì«á¥Ñ Andy2483 ©ó 2023-10-19 15:05 ½s¿è

¦^´_ 2# Andy2483


¸¹½X1
¶}¹L36¦¸,¤w¸g³sÄò10¦¸¨S¦³¶}¥X

¸¹½X2
¶}¹L27¦¸,¤W´Á¶}¹L,¥»´Á¥¼¶}¥X

¸¹½X3
¶}¹L27¦¸,¥»´Á¶}¥X

¸¹½X4
¶}¹L30¦¸,¤w¸g³sÄò6¦¸¨S¦³¶}¥X

¨Ì¦¹Ãþ±À¡K¡K¡K
¥Î¦æ°Ê¸Ë¸mÂsÄý½×¾Â¾Ç²ß«Ü¤è«K,ÁÂÁ½׾¸gÀç¹Î¶¤
½Ð¤j®a¤@°_¤W½×¾Â¨Ó¥æ¬y

TOP

¦^´_ 3# hcm19522


    ¤j¤j ½Ð°Ý ¶¶§Ç¦³¿ìªk¤Ï¹L¨Óªº¤½¦¡¶Ü ¤ñ¦p²{¦b¬O 43210 Åܦ¨01234 ³o¼Ë¤ñ¸û¦n­pºâ·í¤Ñªº´Á¼Æ¦A³Â·Ð¤F ÁÂÁÂ

TOP

¦^´_ 5# eric7765
eric7765¤j¤j   °Ñ¦Ò¬Ý¬Ý

TOP

¦^´_ 6# jdg188  

¤j¤j~§Aªº¹Ïªí¦n²M·¡³á ¯à¸ò§A½Ð±Ð ¥¼¶}´Á¼Æ³¡¤Àªº¤½¦¡¶Ü?

TOP

¦^´_ 7# eric7765

" Q3=LOOKUP(2,1/($D$5:$H$1855<>""),Q$5:Q$1855)  "     ¡÷¦Ü³Ì«á...

TOP

¦^´_ 8# jdg188


    ¤j¤j ¤£¦n·N«ä ¦]¬°§ÚQ5~Q1855 ¨ºÃ䪺¤½¦¡ §Ú¤£ª¾¹D¦p¦ó²Ö¥[ ©Ò¥H¥u¦³Q3ªº¤½¦¡ §Ú¨S¿ìªkÅã¥Ü

TOP

¦^´_ 9# eric7765

eric7765 ¤j¤j..... ¦p¤U¡G
Q5~BC5=0 (ªì©l)
Q6=IF($D6="","",IF(COUNTIF($D6:$H6,Q$4)=1,0,Q5+1))    ¥k©Ô+¤U©Ô ~~~ ¦Ü³Ì·s¤@´ÁÀx¦s®æ¡G
Q1275=IF($D1275="","",IF(COUNTIF($D1275:$H1275,Q$4)=1,0,Q1274+1))

TOP

        ÀR«ä¦Û¦b : ¤£­nÀH¤ß©Ò±ý¡A­nÀH¤ß±Ð¨|¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD