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

[µo°Ý] ÃC¦â§P§O

¦^´_ 10# coafort


­è­èµo²{±zªº¸ê®Æ¦³85ºØ¤£¤@¼Ëªº
¥[¤F©³¦â«á¤]¬O§ä¤£®e©ö§ä¨ì¦P¤@­ÓÃC¦â
©Ò¥H¤£«Øij¥[©³¦â
ÁÂÁÂ

TOP

¥»©«³Ì«á¥Ñ hcm19522 ©ó 2021-10-30 12:41 ½s¿è

=(COUNTIF($A$3:$M$33,A3)>1)*(MOD(COLUMN(A1),4)=1)
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

=(COUNTIF($A$3M$33,A3)>1)*(MOD(COLUMN(A1),4)=1)
hcm19522 µoªí©ó 2021-10-30 12:36


½Ð°Ý¤j¤j
³o¬O¡H
ÁÂÁÂ

TOP

¦^´_ 13# coafort


  ®æ¦¡¤Æ¤½¦¡
https://blog.xuite.net/hcm19522/twblog/590098778

©Î$A:$M §ï $A$3:$M$33
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_  coafort


  ®æ¦¡¤Æ¤½¦¡


©Î$AM §ï $A$3M$33
hcm19522 µoªí©ó 2021-10-30 13:24


ÁÂÁ¤j¤j
¦ý¬O§Ú§Ë¤£¥X¨Ó
¬O§_¥i³Ò·Ð¤j¤j¥Î¤p§Ìªþ¥óÀ°¤p§Ì§Ë©O¡H
ÁÂÁ¤j¤j
«D±`·P®¦

TOP

¦^´_ 15# coafort

~~~~~~~~~~~~~

®æ¦¡¤Æ ­«½Æ­È ¼Æ¾Ú¸õ¦æ (9045).rar (7.83 KB)

ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_  coafort

~~~~~~~~~~~~~
hcm19522 µoªí©ó 2021-10-30 14:52


«D±`ÁÂÁ¤j¤jªºÀ°¦£
¦³±z¯u¦n
§Ú©ú¤Ñ¬ã¨s¬Ý¬Ý:kiss:

TOP

¦^´_ 10# coafort

®æ¦¡±ø¥ó+vba
1) ­«ÂÐ--ÂŦâ¦r
2) ¹ï¦³­«ÂЪºªÑ²¼¦WºÙÂùÀ»¥ªÁä, ©Ò¦³¬Û¦Pªº¼Ð²L¬õ©³
Xl0000797.rar (15.27 KB)

¥Î¤Fcountif, ½d³ò¤Ó¤j, ·|«Ü¥d~~¥i±¤¬O¸õÄæ, ¥Îmatch¤½¦¡«Üªø

TOP

¦^´_  coafort

®æ¦¡±ø¥ó+vba
1) ­«ÂÐ--ÂŦâ¦r
2) ¹ï¦³­«ÂЪºªÑ²¼¦WºÙÂùÀ»¥ªÁä, ©Ò¦³¬Û¦Pªº¼Ð²L¬õ©³
...
­ã´£³¡ªL µoªí©ó 2021-10-31 15:45


¤j¤j³o­Ó¦n¤è«K
«D±`·P®¦¤j¤j´£¨Ñªº¤èªk
·P®¦·P®¦µL­­:)

TOP

¦^´_ 19# coafort

½Ð´ú¬Ý¬Ý¡AÁÂÁÂ

test_1101.zip (20.69 KB)

TOP

        ÀR«ä¦Û¦b : ¬°¦Û¤v§äÂǤfªº¤H¥Ã»·¤£·|¶i¨B¡C
ªð¦^¦Cªí ¤W¤@¥DÃD