作者查詢 / ZZZZ0
作者 ZZZZ0 在 PTT [ Office ] 看板的留言(推文), 共35則
限定看板:Office
看板排序:
全部Gossiping357Accounting105car82Office35NTPU-ACC8714Cheer10MOD9NCHU_MBA_969NTPU-ACC899sex9Storage_Zone9WorldCup9cookclub8NewYork7HBO6BigBanciao5motor_detail5Old-Games5tax5YOLO5EZsoft4Broad_Band3CarShop3Master_D3PhD3Tai-travel3AntiVirus2CCHS-98012EAseries2Emulator2Google2Hate2HCSHch13_3112HSNU_9002Japanese-A872joke2MenTalk2NTPU-ACC912Option2Wine2AfterPhD1Android1B94A011XX1Buzz_Theater1Car-rent1ChthoniC1CHU-GO1ck53rd3251cksh75th151cksh80th3071CMU_M481CSI1CSMU-MED931FCBarcelona1FJU-Law20051Football1GreysAnatomy1Hiking1homemaker1HOT_Game1Hsinchu1HSNU_9201KOTDFansClub1KSCC49-6181L_TalkandCha1LCD1Liu1lostsleep1medstudent1MGL-history1NCCU01_PF1NCCU04_SOCI1NCTU_TALK1NDMC-guitar1NTPU-ACC931NTUCH-901NTUGIEE_RFIC1NUK_AC981NY-Yankees1Olympics_ISG1P2PSoftWare1PCman1pighead1PttLaw1PublicServan1RockMetal1ScienceNote1SCU_chem921skinny1SpaceArt1specialman1Stock1StupidClown1SYSOP1Tennis1TY_Research1Uni-Service1Visual_Basic1W-Philosophy1Wallpaper1WomenTalk1YTHT1<< 收起看板(102)
1F推:2003的作法是貼到word全選,然後中、英選好再貼回excel11/28 21:36
1F推:不是不行啦,只是你用2003,欄位只能到255吧,資料很多嗎?10/18 12:56
2F→:基本上,在這個數字以下,你用轉置的就夠用了,不行再說10/18 12:57
4F推:不會,不過感謝你的offsetXDD 個人是會用indirect啦~~10/18 23:09
5F→:建議改用2007,橫的愛怎麼擺就怎麼擺(還…還是有限啦…)10/18 23:10
1F推:請愛用lookup08/20 08:52
5F推:b2=vlookup(a1,$c$1:$d$xxxx,2,false) b3自動填滿08/16 00:32
1F推:自動分行還是斷行的要勾消08/10 00:44
1F推:trim08/09 00:21
1F推:用開啟舊檔的方式,選分隔符號,逗號分隔(懷念的tickerXD)07/27 12:24
2F→:若超過65535,請改用2007,否則就用access,一樣逗號分隔07/27 12:26
1F推:if07/18 20:43
3F→:對不起,我耍寶了…囧rz07/18 21:09
1F推:alt+滑鼠拖曳,可以直直地選取範圍,選完再改格式07/18 15:53
1F推:太強了!!!07/16 23:21