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

[µo°Ý] ½Ð°Ý¯à§_«ü©w¬YÄæ¦ì¥u§ì³Ì·sÄæ¦ìªº¼Æ¾Ú?

[µo°Ý] ½Ð°Ý¯à§_«ü©w¬YÄæ¦ì¥u§ì³Ì·sÄæ¦ìªº¼Æ¾Ú?

½Ð°Ý¯à§_«ü©w¬YÄæ¦ì¥u§ì³Ì·sÄæ¦ìªº¼Æ¾Ú?
¨Ò¦p:Åý I2 ¦]A:A¤é´ÁªºÅÜ°Ê¡A¦Ó¸òµÛH:Hªº¼Æ¶q¦Û°Ê§ó·s?

¦^´_ 1# 997531
Àx¦s®æI2¿é¤J
¡×OFFSET($H$1,COUNT($H:$H),)
½Ð°Ñ¦Ò¡I

TOP

¦^´_ 2# p212


    «D±`·PÁÂ!
¹ï§Ú³oºØ¨S¾Ç¹LExcelªº·s¤â¨Ó»¡¡A
³o­Ó½×¾Â¯u¬O¤@­Ó«Ü´Îªº¦a¤è¡C
¯àÅý§Ú¾Ç¨ì«Ü¦h·sªº¤½¦¡!

TOP

­º¥ý¡A
¥ý·PÁÂP212¤j¤j·íªì´£¥Xªº¤½¦¡¡A
³o¤T¦~¨ÓÀ³¥Îªº«Ü¤è«K¡C
¬Æ¦Ü¤w§â¤½¦¡§ï¬°¥Ñ¤u[§@ªí¤G]Ū¨ú[¤u§@ªí¤@]
=OFFSET(®w¦s!$H$2,COUNT(®w¦s!$H:$H),)

¦ý¬O...
²{¦b¹J¨ì·sªº°ÝÃD¡C
²{¦b­n¦bªí¤GŪ¨úªí¤@¸ÌFÄæ[¥X³f¼Æ¶q]ªº³Ì·s¤@¦C¡A
¦ý¬O¦]¬°¤¤¶¡¦³ªÅ¥ÕÀx¦s®æªºÃö«Y¡A
©Ò¥H·|³y¦¨¤W­±ªº¤½¦¡²£¥Í¿ù»~¡C
½Ð°Ý¦U¦ì¤j¤j¦³¨ä¥Lªº¸Ñªk¶Ü?

TOP

¦³½d¥»¶Ü?!

TOP

¦^´_ 5# a5007185


    ¸Õ§@.rar (22.19 KB)
¤W­±³o­Ó¬O½d¥»

¥Ø«e¹J¨ìªº°ÝÃD¬O¡A
¦b[®w¦sªí]³o¤u§@ªí¨S¿ìªk¥Î=OFFSET¤½¦¡¡A
¥hŪ¨ú[µn°Oªí]¸Ìªº"¶i³f"¤Î"»â¥Î"¼Æ¶q¡C

TOP

¦^´_ 6# 997531

¥Ø«e§Ú·Q¨ìªº³Ì¨Î¸Ñ¥²¶·¶}±Ò¥¨¶°¡A
­º¥ý§A¥ý«ö¤U¦C¨BÆJ¶}±Ò¶}µoªÌ¼Ò¦¡¡A
https://ppt.cc/fU3nhx
µM«á±N¤U­±³o¬qµ{¦¡½X¶K¦b¼Ò²Õ¤¤¡C
  1. Function RowLastData(SheetName As String, PT As Range)
  2.     RowLastData= Sheets(SheetName).Cells(Cells.Rows.Count, PT.Column).End(xlUp)
  3. End Function
½Æ»s¥N½X
VBA.gif
³o­Ó¬O¦Û³Ð¨ç¼Æ¡A
¥D­n¥\¯à¬O¦^¶Ç¸ÓÀx¦s®æ©ÒÄݪºÄæ¦ì¤¤³Ì«á¤@µ§ªº¸ê®Æ
RowLastData(¤u§@ªí¦WºÙ,Àx¦s®æ)

¨Ò1¡GRowLastData("µn°Oªí",µn°Oªí!F3)="10800"
§Y¥Nªí¦b¡uµn°Oªí¡v³o­Ó¤u§@ªí¤¤¡A»P¡uµn°Oªí!F3¡v¬Û¦PªºÄæ¦ì¡uF¡v³Ì«á¤@µ§ªº¸ê®Æ¬O¡u10800¡v
¨Ò2¡GRowLastData("®w¦sªí",µn°Oªí!D3)="A20"
§Y¥Nªí¦b¡u®w¦sªí¡v³o­Ó¤u§@ªí¤¤¡A»P¡uµn°Oªí!D3¡v¬Û¦PªºÄæ¦ì¡uD¡v³Ì«á¤@µ§ªº¸ê®Æ¬O¡uA20¡v

¸Õ§@.zip (27.91 KB)

TOP

¦^´_ 7# a5007185


    ­è­è¤U¤F±z­×§ï¹Lªºª©¥»¸Õ¤F¤@¤U¡A
§Úµo²{¤£·|¸òµÛµn°OªíÅܧó¼Æ¶q­C???
¬O§Ú¾Þ§@¦³°ÝÃD¡A
ÁÙ¬O³o¥¨¶°¥u¯à§ì¯S©wªºÀx¦s®æ?

TOP

¦^´_ 8# 997531

½Ð±NVBA¨ç¼Æ¼W¥[³o¦æ¡uApplication.Volatile¡v
§ó§ï«á¦p¤U¡C
  1. Function RowLastData(SheetName As String, PT As Range)
  2.     Application.Volatile
  3.     RowLastData = Sheets(SheetName).Cells(Cells.Rows.Count, PT.Column).End(xlUp)
  4. End Function
½Æ»s¥N½X
¸Ô²Ó½Ð°Ñ¦Ò³o½g¤å³¹
http://club.excelhome.net/thread-176669-1-1.html

TOP

B3:
=IFERROR(LOOKUP(9E+307,OFFSET(µn°Oªí!$A:$A,,MATCH(A3,µn°Oªí!$1:$1,))),0)

B15:
=IFERROR(LOOKUP(9E+307,OFFSET(µn°Oªí!$A:$A,,MATCH(A15,µn°Oªí!$1:$1,)+1)),0)

E15:
=IFERROR(LOOKUP(9E+307,OFFSET(µn°Oªí!$A:$A,,MATCH(D15,µn°Oªí!$1:$1,)+2)),0)

TOP

        ÀR«ä¦Û¦b : ¦¨¥\¬OÀuÂIªºµo´§¡A¥¢±Ñ¬O¯ÊÂIªº²Ö¿n¡C
ªð¦^¦Cªí ¤W¤@¥DÃD