a5007185

¦³½d¥»¶Ü?!

a5007185

¦^´_ 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

¤U¸ü (372.86 KB)

2018-8-9 11:28

³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)

¤U¸ü¦¸¼Æ: 3

2018-8-9 11:34

a5007185

¦^´_ 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

a5007185

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

­ã´£¤j¤j¡A
ÁÂÁ§A¦^õXªº·N¨£¡A
·Q¸ò§A½Ð±Ð¤@¤U¡u9E+307¡v³o¬O¤°»ò·N«ä¡H¦³¤°»ò¥Î·N¡H
ÁÂÁ¡I

a5007185

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


¹ê¦b¤Ó·PÁ§A¤F¡I
¤S¾Ç¨ì¤F¤@½Ò¡I

¦pªG LOOKUP ¨ç¼Æ§ä¤£¨ì lookup_value¡A
´N·|¤ñ¹ï lookup_vector ¤¤¤p©ó©Îµ¥©ó lookup_value ªº³Ì¤j­È¡A
©Ò¥H³]¤@­Ó·¥¤jªºlookup_value¡C
https://support.office.com/zh-tw/article/lookup-%E5%87%BD%E6%95%B8-446d94af-663b-451d-8251-369d5e3864cb


¥t¥~½T»{¤@¤U B3ªº¨ç¦¡¬O¤£¬O³o¼Ë³]©w·|§ó·Ç½T¡H

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

½Æ»s¥N½X