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

¦p¦ó¥h§äÂ÷¦Û¤v³Ìªñªº­È?

¦^´_ 9# ­ã´£³¡ªL


    ­ã¤j¡A¯à³Â·Ð§AÀ°§Ú¥´¦b½d¨Ò¤W­±§Ú¦A¬ã¨s¬Ý¬Ý¶Ü?

TOP

¦^´_ 10# ÂŤÑÄR¦À

GOOGLE¤@¤U//°}¦C¤½¦¡ªº¥Îªk§a!!!
Xl0000216.rar (4.11 KB)

TOP

¦^´_ 9# ­ã´£³¡ªL

­ã¤j¡A§Ú»¡¤£À´¬O¦]¬°¬d¨ìªº¸ò§A»¡ªº¤£¤Ó¤@¼Ë¡A¤£ª¾¹D¬O¥´¿ù¡AÁÙ¬O¦³¨ä¥L¥Îªkhttps://support.microsoft.com/zh-tw/office/%E5%BD%B1%E7%89%87-%E9%99%A3%E5%88%97%E5%85%AC%E5%BC%8F-8ff8257a-b28e-4e81-b4f8-30f793412dfa

TOP

¦^´_ 13# ÂŤÑÄR¦À

1) ³æ®æªº°}¦C¤½¦¡, ¦b¤@­ÓÀx¦s®æ½s¿è¤½¦¡, ¦A¥Î¤TÁä¿é¤J, µM«á½Æ»s¨ì¨ä¥¦Àx¦s®æ(³q±`¬O:¥k©Ô/¤U©Ô)
2) °Ï°ìªº°}¦C¤½¦¡, «h­n¿ï¨ú¤@­Ó°Ï°ì¦A«ö¤TÁä

³q±`²ßºD¨Ï¥Î³æ®æ°}¦C¤½¦¡, ¾A¦XÂX±i½d³ò~~

googleÀ³¥i§ä¨ì§ó¦h¸ÑÄÀ, «o¥u¥h¬Ý¤@­Ó...???

TOP

¥»©«³Ì«á¥Ñ ÂŤÑÄR¦À ©ó 2024-2-6 21:10 ½s¿è

¦^´_ 14# ­ã´£³¡ªL


   ­ã¤j¡A§Ú¤@¶}©l¦bK2¥ÎCtrl + Alt+ Enter¡Aµ²ªG¨S¤ÏÀ³¡A«á¨Ó¬Ý¨ì¥t¤@½g¬O¥ÎCtrl + Shift + Enter¡Aµ²ªG¥L´N¦Û¤v§e²{¥k©Ô¸ò¤U©Ôªº¥\¯à¡A¦]¬°¨â­Ó¦³ÂI¹³¡A©Ò¥H¤~·|»~¸Ñ¬O¥´¿ù¡A©Î¬O¦³¨ä¥L¥Îªk¡A©êºp

TOP

¦^´_ 15# ÂŤÑÄR¦À


¬O§Ú¥´¿ù¤F, À³¸Ó¬OShift + Ctrl + Enter

TOP

¦^´_ 14# ­ã´£³¡ªL


    ¥t¥~¡A­ã¤j§Ú¦³¨Ç¦a¤è¤£¤Ó¤F¸Ñ¡A§Ú¦³¥ÎGPT¥ý¬d¤F¤@¤UÁÙ¬O¤£¤ÓÀ´¡A¦b¸ò±z½Ð±Ð¤@¤U

      1.MOD(MAX(($C$1:$F2=C3)*(ROW($A$1:$A2)*10^5+$G$1:$J2)),10^5) ³oÃä³o¦ê§Ú¤£¤Ó¤F¸Ñ¥¦ªº­ì²zMAX¡BROW¡BMOD¡B10^5¡A³o¨Ç¤À¶}§Ú³£¬Ý±oÀ´¡A¦ý¦X¦b¤@°_§Ú´N¤£À´¤F¡A¥i¥H³Â·Ð­ã¤jÀ°§Ú»¡©ú¤@¤U¶Ü?
      
      2.³o­Ó°}¦C¤½¦¡¿é¤J§¹¨S°ÝÃD«á¡A§Ú¦A¥hÂIK2Åý¦o§e²{½s¿èª¬ºA¡AµM«á¤°»ò³£¤£§ï¡A¦b«öENTER¡A¤§«á¦o·|¥X²{#VALUE¡A¬°Ô£{}·|®ø¥¢¤£¨£?¤S¬°Ô£¦Û¤v¥[{}«o¨S¿ìªk¦³°}¦Cªº®ÄªG¤F©O?

      3.¤]¬O¦P¤W­±ªº°ÝÃD¡A°²¦p§Ú¦³¥H¤Uªºµ{¦¡½X¡A¦b³o¸Ìªº³¡¤À­n¶ñ¤JRange("V" & Target.Row).Formula = "{=IF(OR($C$1:$F1=C2),G2-MOD(MAX(($C$1:$F1=C2)*(ROW($A$1:$A1)*10^5+$G$1:$J1)),10^5),"")"}¡A¦ý¤S¦]¬°{}¦Û¤v¥[·|¨S®ÄªG¡A¨º§Úµ{¦¡½X¤SÀ³¸Ó¦p¦ó§ó§ï©O?

Private Sub Worksheet_Change(ByVal Target As Range)
    Application.EnableEvents = False
    If Not Intersect(Target, [B5:B210000]) Is Nothing Then
        Range("V" & Target.Row).Formula = "³o¸Ì"
      
     ElseIf Not Intersect(Target, [C5:C210000]) Is Nothing Then
        Range("W" & Target.Row).Formula = "³o¸Ì"
   End If
   Application.EnableEvents = True
        

End Sub

­ã¤j©êºp¡A°ÝÃD¤ñ¸û¦h¡A·Q»¡³o­Ó½×¾Â¦³«Ü¦h¼F®`ªº«e½ú¦b¡A·Q¦h¦h¾Ç²ß¡AÁٽЭã¤j¤£§[½ç±Ð

TOP

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2024-2-7 10:09 ½s¿è

¦^´_ 17# ÂŤÑÄR¦À

Æ[¹î°}¦C¤½¦¡, ±oµ½¥Î"F9", ¥H¤U¤½¦¡³v¤@¿é¤J¦Ü K5, ¦b"½s¿èª¬ºA"¤U, «öF9¬Ý¬Ý//
(1) =($C$1:$F4=C5)  «öF9,
    ¥i¬Ý¨ì//{FALSE,FALSE,FALSE,FALSE;FALSE,TRUE,FALSE,FALSE;TRUE,FALSE,FALSE,FALSE;FALSE,FALSE,FALSE,FALSE}
(2) =($C$1:$F4=C5)*(ROW($A$1:$A4)*10^5+$G$1:$J4)
    //{0,0,0,0;0,200005,0,0;300012,0,0,0;0,0,0,0}

(3) =MAX(($C$1:$F4=C5)*(ROW($A$1:$A4)*10^5+$G$1:$J4)) ... ³o®É¥u·|¥X²{¤@­Óµ²ªG//300012...mod§À¼Æ12´N¬Oµ²ªG

¦b§¹¾ã¤½¦¡¤U,
=IF(OR($C$1:$F4=C5),G5-MOD(MAX(($C$1:$F4=C5)*(ROW($A$1:$A4)*10^5+$G$1:$J4)),10^5),"")
¿ï¨ú¬õ¦â¦r¬q, ¦A«öF9, §Y¬°(2)ªºµ²ªG

TOP

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2024-2-7 10:24 ½s¿è

¦^´_ 17# ÂŤÑÄR¦À


2.³o­Ó°}¦C¤½¦¡¿é¤J§¹¨S°ÝÃD«á¡A§Ú¦A¥hÂIK2Åý¦o§e²{½s¿èª¬ºA¡A
µM«á¤°»ò³£¤£§ï¡A¦b«öENTER¡A¤§«á¦o·|¥X²{#VALUE¡A¬°Ô£{}·|®ø¥¢¤£¨£?¤S¬°Ô£¦Û¤v¥[{}«o¨S¿ìªk¦³°}¦Cªº®ÄªG¤F©O?


¥u­nÂI¶iÀx¦s®æ, ¤£ºÞ¸Ì­±¬OªÅ®æ/¤å¦r©Î¤½¦¡, ¥¦´N¹F¨ì CHANGE ®ÄªG

°ÝÃD(3)//ÂI"¿ý»s¥¨¶°" >> ÂI¶i¤½¦¡½s¿è. ¤TÁ䧹¦¨ > °±¤î¿ý»s
¤½¦¡¹ïÀx¦s®æ¦³"¬Û¹ï°Ñ·Ó/µ´¹ï°Ñ·Ó"¤§¤À, ¦b¤£¦P¦ì¸m²£¥Í¤£¦P°Ñ·Ó, ­Y¤£¼ô±x¨ä¹B§@, ¨Ï¥Î¿ý»s¥X¨Óªºµ{¦¡½X¸û¤£·|¦³°ÝÃD~~

­è¤JEXCEL¤§ªù, ÁÙ¬O­n¦Û¦æ¦h¦hGOOGLE, ©Î¦A¦hªá®É¶¡¬Ý¬Ý½×¾Â©«¤l§a!  
¦]¬°¦^µª°_¨Ó¤Óªá®É¶¡~~~¦^µª¤F°ÝÃD¤S·|°Ý§ó¦h///

TOP

¦^´_ 19# ­ã´£³¡ªL


    ·PÁ­ã¤jªº¦^ÂСA§Ú¦A¬ã¨s¬Ý¬Ý

TOP

        ÀR«ä¦Û¦b : Ä@­n¤j¡B§Ó­n°í¡B®ð­n¬X¡B¤ß­n²Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD