作者查詢 / sleepwu

總覽項目：發文 | 留言 | 暱稱

作者 sleepwu 在 PTT [ Office ] 看板的留言(推文), 共71則

限定看板：Office

看板排序：

全部Gossiping529Violin137Salary100PushDoll76joke73PlayStation73Office71ShowOff59Tech_Job34Soft_Job33LoL30Stock29CareerPlan19Beauty18sex18CodeJob16SMSlife16graduate15score13X-Japan13piano12NTU11CVS9Database9DigiCurrency9PT-938Lottery7Network7WarCraft7DataScience6Doctor-Info6mobile-game6Steam6TigerBlue6Boy-Girl5guitar5GunsNRoses5hotspring5Jay5NDS5Neihu5Pal_online5PathofExile5RSSH94_3015WorldCup5BBSmovie4C_and_CPP4CFP4DigitalMusic4pal4specialman4Statistics4CHSH-93-3043NIUECE913b902040XX2b912040XX2biker2CCRomance2ck53rd3092ck57th3282cksh79th012DeathNote2DPP2Education2Employee2fastfood2FJU2Hamster2Hate2home-sale2InitialD2iOS2kachaball2KingofPop2KS97-3102KS98-3022Lineage2Marketing2Master_D2media-chaos2Militarylife2movie2NCCU04_MJOUR2NCCU04_TUR2NCHU-giip2NCHUS2NDHU-MBA972NKUTEE2NTUT_en489b2PeopleSeries2PublicIssue2Python2SENIORHIGH2share2TFSHS65th3222Visual_Basic2W-Philosophy2Yunlin2ASIA-uni1B00305XXX1Baseball1BigShiLin1Billiard1Biology1Broad_Band1car1CareerLady1CCSH_91_3201CCU_EE961CCUfinGrad921CCUfinGrad931CCUfinGrad951CGSH86th3231CGSH87th_3151Chemistry1Childhood1CHUSHAN89-331civil941ck55th3181ck55th3291ck56th3041ck56th3231ck57th3301CKBIGBOAT1cksh76th101cksh79th3101cksh80th3171cksh83rd3071cksh83rd3141cksh84th3021ClassicMusic1clmusic1CMCRX421CosmosPeople1CSMU-MED911CSMU-MED921CSMU-MED971CSMU-MT921CSMU-OSH1CTSH923011CTSH923021danceforever1dcsh-7th1dlsh-7th-3031Donate-Blood1Doraemon1Ecophilia1Emulator1ENG_BASE1FCU_ECON_93B1FJU-ACC90a1FJU-EE-2001a1FJU-Laws971FJU-PH14th1FJU-TM1FJU_Fashion1FLAT_CLUB1FSHS-90-3131FuMouDiscuss1Garena1GatoShoji1Golden-Award1GossipPicket1HatePolitics1hc3141HC5th-3121HCHS933141HCSHch13_3111HisShark1HK-movie1HK_Comics1HRM1HsinTien1HSNU_10081HSNU_10101HSNU_10581HSNU_11391HSNU_9491HSNU_9751HSNU_9891HSNU_j1021HW903201HY-40-Xin1I_LOVE_MRI1IA1Immigration1ISUEE93A1JA31th3111junji-ITO1kawaii1KERORO1Key_Mou_Pad1Kindaichi_Q1KMCJ-88-3111KS91-3031KS92-3041KS92-3191KS93-3141KS93-3151KS93-3201KS94-3031KS94-3101KS94-3111KS94-3121KS94-3131KS94-3161KS94-3201KS96-3011KS96-3181KS97-3051KS97-3081KS97-3161KS97-3201KS98-3011KS_PMAC1KSHS_Talk1Lifeismoney1LifeSci_961Linux1LTK1MAC1Math1MenTalk1MIT1MMA1MRT1Musicteach1NAOE-861NARUTO1NCCU05_PSYGR1NCCU08_Ethno1NCCU08_HISTO1NCCU09_PHILO1NCCU_KungFu1NCCUbike1NCCUGO1NCHU-AGR001NCHU-AGR021NCU92Physics1NCU97ME-B1NCYU_CW_981NDHU-DSLS081NDHU-phy951NDHU_MSE961NHSH13th3051NIU-ECE94b1Notebook1NSwitch1NSYSU_FG1021NTHU_STAT941NTNU-HISBK1NTOU-AQUA981NTPU-ACC871NTPU-COECO881NTPU-CSIE961NTPU-STAT951NTTU_CSIE991NTUA_MPD1NTUAC941NTUBSE-B-1001NTUBSE-B-941NTUDancing1NTUE-Art951NTUE-Art971NTUGIPO_307A1NTUHistory911NTUHistory941NTULibrary1NTUMSE-941NTUot941NTUSO1NUK_EE100A1NUU_MSE1Olympics_ISG1part-time1PC_Shopping1PCCU-CS1PCSH91_3051PhD1PokeMon1Property_M1PttHistory1PublicHealth1puzzle1RealDream1RealPlaying1Road_Running1RockMetal1RSSH91_3031RSSH92_3021RSSH94_3031Sangokumusou1Sassy-babe1Scout1SCU_CIS-90B1SCU_CIS-92A1Seiya1Shu-Lin1ShuangHe1single1SKET_DANCE1SPHS91P3B1SpongeBob1SRW1SSSH-09th1141SSSH-12th3041SSSH-16th3131StupidClown1Surf1TA_AN1TaiShan1TaiwanDrama1TennisTeam1Tera1TFSHS62th3161TFSHS68th3121TFSHS68th3131TFSHS69th3071THU-CHEM941THUID_Grad1THUIM-2nd1TKU-Softball1TKU_CE94C1TKUME-92A1TNFSH94011TNFSH98th1Tobacco1TOEIC1transgender1TS2ndChong1TTU-I90B1TTU-TE911TTU-US941TunHua05t3111TuTsau1TYSH48-3011V_ScHooL1VET_971VibWang1Wanhua1Weyslii1WFSH1Windows1wisdom1WUFU92-3221WuLing50-3031YOLO1YP87-3061YP92-3071YP94-3101Yup99-061YUYUHAKUSHO1YZU-EE95A1YZU_EE95B1<< 收起看板(354)

首頁

尾頁

[算表] 大量檔案自動改檔名

[ Office ]20 留言, 推噓總分: +2

作者: terry1983 - 發表於 2019/07/03 15:16(6年前)

1^F推sleepwu: 試試totalcommander這工具可以批次改檔名07/03 15:26

3^F→sleepwu: 檔名可用文檔導入07/03 15:26

[算表] 數量均攤至期間每一日

[ Office ]7 留言, 推噓總分: 0

作者: sleepwu - 發表於 2018/08/21 18:28(7年前)

2^F→sleepwu: https://imgur.com/a/u7X6ZHU 謝謝S大請問為什麼我的函08/21 18:56

3^F→sleepwu: 式不work @@08/21 18:56

7^F→sleepwu: 調整BC欄日期格式後就可以了謝謝S大08/22 10:03

[算表] 三個欄位為一體,刪除重複的資料

[ Office ]5 留言, 推噓總分: +1

作者: kikilalagirl - 發表於 2018/04/21 12:21(7年前)

1^F推sleepwu: 選取三個欄位後按移除重複項04/21 12:28

[算表] 如何用vlookup合併資料

[ Office ]33 留言, 推噓總分: +2

作者: sleepwu - 發表於 2018/04/17 22:10(7年前)

5^F→sleepwu: 第二個方法可用!感謝S大只是資料有幾十萬要等很久XD04/18 21:06

9^F→sleepwu: 用輔助欄快很多!一小時就跑完了!原本的跑超過一天才04/19 18:30

10^F→sleepwu: 十幾趴的進度04/19 18:30

11^F→sleepwu: 請問S大是怎麼判斷要使用哪種方式來加快速度的04/19 18:31

20^F→sleepwu: @S大我的確有貼成值後再去計算快很多04/20 00:58

21^F→sleepwu: @A大樞紐分析我有試過只能顯是有幾筆資料04/20 00:59

22^F→sleepwu: 無法顯示我想要的隔式04/20 00:59

24^F→sleepwu: https://imgur.com/a/yuvEGzk 樞紐會變這樣04/20 01:03

25^F→sleepwu: raw data(藍底)大約有70幾萬不重複的人名有20幾萬04/20 01:04

27^F→sleepwu: 欄數有11欄04/20 01:05

[算表] 比對多重資料後顯示於同一儲存格

[ Office ]4 留言, 推噓總分: 0

作者: sleepwu - 發表於 2015/03/04 22:01(11年前)

3^F→sleepwu: S大真神人 m_ _m叩謝03/05 00:00

[算表] excel怎麼快速計算這樣的格式？

[ Office ]2 留言, 推噓總分: +1

作者: ptguitar - 發表於 2014/03/12 21:49(12年前)

1^F推sleepwu:要看你資料結構乾不乾淨乾淨的話用樞紐一下就出來了03/12 21:51

[問題] 如何只保留含有某些字詞的句子？

[ Office ]6 留言, 推噓總分: +1

作者: geofrania - 發表於 2014/02/27 00:42(12年前)

1^F推sleepwu:=IF(ISERROR(FIND("女",A1)),"",A1) 貼在B102/27 01:01

[算表] 樞紐分析表中的百分比計算

[ Office ]8 留言, 推噓總分: 0

作者: sleepwu - 發表於 2014/02/26 21:28(12年前)

2^F→sleepwu:樓上J大 month想要放在報表篩選的話有可能嗎02/26 22:32

7^F→sleepwu:平均值是SUM(CTR)/項目數也不是喔@@02/26 22:47

8^F→sleepwu:我怎麼發現好像不用sum 用click/imp就好了 = =02/26 22:54

[算表] excel2007 自動ctrl+s

[ Office ]13 留言, 推噓總分: 0

作者: sleepwu - 發表於 2014/02/07 19:26(12年前)

3^F→sleepwu:S大可否再詳細說明一下? 謝謝02/08 18:57

5^F→sleepwu:S大所以這是一個定時器每天時間一到就會自動把所有開啟02/08 19:57

6^F→sleepwu:中的excel檔存檔嗎02/08 19:57

8^F→sleepwu:有辦法每天嗎@@ 想搭配excel的自動更新功能來使用02/08 20:13

9^F→sleepwu:一點P幣奉上感謝02/08 20:13

10^F→sleepwu:或是可以自己設定每格N小時就執行一次02/08 20:17

13^F→sleepwu:太感謝S大了02/09 20:04

[文件] 如何讓某特定選項的句尾通通加上句號？

[ Office ]6 留言, 推噓總分: +1

作者: geofran - 發表於 2014/01/17 00:38(12年前)

1^F推sleepwu:B1=IF(MID(A1,2,1)="4",A1&"。",A1)01/17 00:47

2^F→sleepwu:不會寫函氏的話用篩選 A欄包含(4) 然後在B欄=A1&"。"01/17 00:48

首頁

尾頁