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

[µo°Ý] ½Ð°Ý¿é¤J¼Æ­È¡A¤£¦P¤u§@ªí¥X²{ ÃC¦â?

[µo°Ý] ½Ð°Ý¿é¤J¼Æ­È¡A¤£¦P¤u§@ªí¥X²{ ÃC¦â?

½Ð°Ý
¦b¤u§@ªí¿é¤J ¼Æ­È«á
¹ïÀ³¤£¦Pªº¤u§@ªí¡A§ä¨ì¬Û¦Pªº¼Æ­È¡A·|Åã¥Ü©³¦â?
°ÝÃD.rar (6.08 KB)

ÁÂÁ¤j®a
¿é¤J¼Æ­È
2089
3078

¦P®É ¹ïÀ³ªí®æ

·|¥X²{ ¶À¦â ©³¦â

¦^´_ 1# momo020608

ª¾¹D¤F
®M¥Î¤½¦¡ ·s¼W³W«h
=COUNTIF(¿é¤Jªí®æ!$A:$A,A1)>0 ®M¥Î®æ¦¡


½Ð°Ý
¿é¤J¼Æ­È ²£¥Í®É¶¡
·í¼Æ­È¥X²{¡A´N²£¥Í ·í®Éªº®É¶¡¡A¸Ó¦p¦ó¤U¤â©O?

TOP

¦^´_ 2# momo020608

¤U­z¤ù¬q¥\¯à¬OA¦C¥u­n¿é¤J¸ê®Æ,B¦C·|¦Û°Ê±a¥X¨t²Î®É¶¡

Private Sub Worksheet_Change(ByVal Target As Range)
  If Target.Count > 1 Then Exit Sub
     Select Case Target.Row
        Case 60000: Target(-59998, 2).Select
     End Select
   If Target.Column = 1 Then
      Target.Offset(0, 1) = Now
   End If
End Sub

??¤£ª¾¹D¦p¦ó­×§ï

TOP

¦^´_ 3# momo020608
½Ð°Ý
¦bEÄæ¦ì¿é¤J¼Æ­È«á¡A¦p¦ó¦Û°Ê²£¥Í®É¶¡?
ªþÀÉ ÁÂÁ¤j®a
0909°ÝÃD.rar (70.31 KB)

TOP

®æ¦¡¤Æ»Ý¦P­¶ ,©Ò¥H¿é¤J¼Æ­È³]¦P­¶©Î½Æ»s¨ì¦P­¶JÄæ³]»²§U
J2¤U©Ô=¿é¤Jªí®æ!A2
®æ¦¡¤Æ=COUNTIF($J:$J,A1)
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

        ÀR«ä¦Û¦b : ¸Ü¦h¤£¦p¸Ü¤Ö¡A¸Ü¤Ö¤£¦p¸Ü¦n¡C
ªð¦^¦Cªí ¤W¤@¥DÃD