作者查詢 / ck3300511
作者 ck3300511 在 PTT [ Office ] 看板的留言(推文), 共83則
限定看板：Office
看板排序：
全部Cardinals10970MLB1811joke632BB_Online501Baseball334LoL320MapleStory287Guardians270NCCU07_LAND203movie118NY-Yankees116Office83CMWang69ck59th32165NCCU08_LAND65LAND_LALA63Cobras55FuMouDiscuss53AlbertPujols44asciiart41MLB_Jersey40PlayBaseball40sex38WorldCup34PokemonGO32HCKuo30FBaseball29LandBaseball28ADS27StupidClown27Virgo26Gossiping24RedSox22Rangers21Finance20Nationals20AllTogether19NCCU19ONE_PIECE16Daan14SMSlife14LadyGaga13LAND_BASKET13PushDoll13Japandrama12NCCU10_LAND11Orioles11Aviation10Beauty10Tennis10PeopleSeries9Bundesliga8Childhood7SFGiants7YZU_CN99A7Dodgers6HarryPotter6Isayama6kochikame6PuzzleDragon6KS98-3025Lions5NBA5Angels4Asian-MLB4AvrilLavigne4BBSmovie4BoardGame4C_Chat4CourtBasebal4Koei4SP2_Baseball4AHQ3Ahqwestdoor3ASIA-uni3CKKN3CTSH953033DIP_Baseball3DragonBall3Garena3japanavgirls3Jeremy_Lin3JOJO3LGBT_SEX3NCCU09_LAND3NTPU-STAT953NTUF-963NTUmed913PublicIssue3SCU_ACC_96A3Spring_Union3TKU_IHM3TW-language3Tyukaitiban3WomenTalk3A-Rod2ArakawaCow2b982040XX2barterbooks2Braves2CHLin2ck59th3062ck60th3072ComeHere2Conan2CSMU-HSA962CSMU-MED962Cubs2DMM_GAMES2Drama-Ticket2fashion2FatMonkeys2FCU-PF20062FJU-ACCR942FLAT_CLUB2forsale2GambleGhost2Gintama2HCHS603122HSNU_11092HSNU_9202KS_PMAC2Lakers2LTK2Marlins2mobilesales2Monkeys2NDHU-His1022NDHU_OECLab2NFL2NSYSU_MSOE012NTHU_STAT942NTU-Karate2NTUBIME-1022NTUE-DC992NUTN_SSSS2NUU_CHE2NY-Mets2Rockies2RockMetal2San-Ying2SCUG2specialman2Tainan2TFSHS67th3242TKU-IE942USC2Vocal2WesternMusic2WOW2YuiAragaki2ACappella1Android1AOE1Aries1Arsenal1Astros1Athletics1B00A013XX1BaseballSYS1basketballTW1biker1Blue_Jays1Bon_Jovi1Boy-Girl1Brewers1Butterfly1CCF1Cheerleader1CHSH-3191CK59th1221ck59th3241ck59th3271ck61st3211CKGC1cksh79th011cksh85th3011cksh85th3171CSMU-D881CSMU-D961CSMU-MED931CSMUdancepub1CSU1CTSH963021CTSH97EXP1CYCU_CE92B1CYCU_Talk1CYSH97Y3181dance1Darvish1Design1DirectSales1dlsh-7th-3031DNF1Drum1EEBaseball1eSports1EthnosBase1Evangelion1FAIRYTAIL1FCSH_Club1FCU_EE97A1FCU_EE97B1FHB-TEAM1FJU-Family1FJU-STAT95B1FJU_AD-071FJU_Chiayun1FJU_JCS71FongShan1FSHS-95-3081gay1GetMarry1GHIBLI1GOGO-Hui1GuardRookies1guitar1Hate1HCSHch13_3111Hip-Hop1HotBloodYuan1HSNU_10081HSNU_10661HSNU_10981HSNU_11181HSNU_11261HSNU_11341HSNU_11351HSNU_11431Hunter1ILSH-963131Indians1ISU1kavalan081kawaii1Keelung1KG93-3061KLSH1KS94-3021KS96-3031KS96-3051KS96-3141KS96-3151KS97-2161KS97-3031KS97-3151LAND_Club1Live1Marines1MayDay1MCU_Talk1ME-PingPong1media-chaos1MenTalk1Militarylife1MIN-Twins1Minecraft1Nangang1NARUTO1NCCU02_Korea1NCCU05_LAND1NCCU06_HISTO1NCCU08_Ethno1NCCU_SEED1NCHU-ACC1011NCHU-AGR071NCHU-FS991NCHU-MKT991NCHU-Stat971NCKU_EARTH981NCUIM971NCYU_DMI_991NDHU-His1001NDHU-phy951NDHU_ACC_12t1NDHU_ACC_8th1NDMC-N571Nintendo1NKNU_Phy0981NKNU_Phy0991NSwitch1NSYSU-Chem991NTHU_ENGI1NTHUTL971NTOU-AQUA981NTOU-MME-99B1NTPU-ACC-VBB1NTTU_CSIE991NTUAC981NTUCHEbsball1NTUdent961NTUE_Nse981NTUEE_Lab4261NTUEOE_R4021NTUHorti961NTUot971NTUST-EE-B961NTUT_guitar1NTUT_ME495A1NTUT_MMRE931NTUTradOpera1NUTN_MS991NUU_ACG1NUU_BM1NUU_ID1NUU_Talk1Orzhong97cl1part-time1pccu_physics1PCSH96_3061Peter_EN1Phillies1Phy-Softball1PingTung1Pirates1PokeMon1PVC-GK1Rays1Reds1Sagittarius1Salary1SCU_Law101D1SCU_Talk1sinica1SJU1SM05th3xx1SmashBros1Sportcenter1SSSH-15th3131SSSH-16th-Fk1SSSH_17th3141StarCraft1STDM-93-3031SuperHeroes1TA_AN1TCFSHvolley1Teacher1TeaClub1Tech_Job1TFSHS64th3091TFSHS64th3181TFSHS69th3141TFSHS69th3181TKU_EW94B1TNFSH96121TOEIC1Transformers1tyart1Viator94Ding1Viator94gi1W-Philosophy1WashingtonDC1watch1Wrestle1WuLing46-3171WuLing50-3021XiangSheng1YP96-3141YUYUHAKUSHO1<< 收起看板(359)
6F推: s大請問如果有多列數字，我公式下拉好像就跑掉了08/08 16:17
7F推: 沒事了，我自己打錯，感謝s大，超猛08/08 16:22
2F→: 感謝s大，如果A欄的值為0的話，要排除分母，要如何改呢08/02 17:14
3F→: 比如說圖中A4為0，那就除以908/02 17:15
8F→: 謝謝S大08/04 16:32
3F→: s大您看我的程式有問題嗎?07/31 22:56
5F→: 好~我明天提供給您07/31 23:53
2F→: 所以.xlsx後面不用再加個"嗎?07/16 16:00
4F→: 小弟只會用錄的..s大可以在指點一下嗎?05/27 23:01
7F→: 好~我來試試看! 謝謝S大05/27 23:12
2F→: 請問s大K2也是公式嗎? J1~O1是文字?05/15 21:48
7F→: 了解!!感謝S大!!!! 有沒有可能用連結2的表格來設計公式05/15 21:56
8F→: 就是產品代碼的部分 01,02,03,04,05,0605/15 21:56
10F→: 如果產品代碼(B欄)是1,2,3,4,5,6 用if 1在數列的B欄05/15 22:21
11F→: 位置來設計?05/15 22:21
13F→: 回傳產品名稱05/15 22:36
15F→: 謝謝s大!05/15 22:52
16F→: s大如果要回傳產品代碼該如何調整呢？05/16 11:47
17F→: 10000000回傳0105/16 11:47
18F→: 10100000回傳010305/16 11:48
20F→: 感謝s大05/16 12:10
7F→: 感謝n大s大04/21 19:07
6F→: 再問一下，請問如果是E3到J3會填日期12/07 14:07
7F→: 如果全都空白，那K3就空白12/07 14:08
8F→: 如果有填日期，K3用min（E3：J3）顯示最早的日期，要如12/07 14:09
9F→: 何用if12/07 14:09
4F→: 有跳出視窗了，但如果L2的數字小於60還是跳出視窗09/28 12:29
5F→: 哪裡需調整呢09/28 12:29
9F→: 成功了！！謝謝s大09/28 22:15
9F→: 如果Ｌ欄有任何一個儲存格大於等於6009/24 13:20
10F→: 是用For Each cell In rng嗎？09/24 13:21
14F→: https://imgur.com/a/MLl8wO0 S大請問這樣有地方需調整09/24 21:40
15F→: 嗎?如果是L欄其中一個儲存格>=60就會跳Msgbox的話09/24 21:41
29F→: 只要有一筆符合就跳出訊息 exit for要怎麼用呀09/24 22:16
34F→: 謝謝Ｓ大09/24 22:36
35F→: 請問next和exit for要加在哪？09/25 21:02
36F→: 今天試跑出現錯誤訊息說沒有next09/25 21:03
37F→: next加的位置好像會牽連exit for09/25 21:03
40F→: 好!明天試試看~謝謝S大09/25 22:52