作者查詢 / GodOfTiger

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

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

限定看板：Office

看板排序：

全部Wei-Lun319Office239ONE_PIECE219ck55th309203Lakers200BBSmovie75pal44KobeBryant39China-Drama25Conan22Facebook21PokemonGO17Sawajiri15Electronics14joke11comm_and_RF9HOT_Game8liuyifei8SCU_CIS-92A8Kindaichi_Q7NBA_Film7Kusan_89-3126NBA6NTUHorti966share6ck55th1205Gossiping5Instant_Mess5MapleStory5SOFTSTAR5CrazyArcade4DIABLO4asciiart3CLHS-53-133EZsoft3NCKU-Stat-963TaiwanDrama3AnimMovie2AVEncode2CCU_EE962ck56th3222ck57th3282CPU_FC7312CTV2FJU_SW_SBMan2HSNU_9482HY-40-Xin2InitialD2KG93-3132KHCHS-93-3092KS94-3122KS94-3202NCHU-TIM952NDMC-M101-f2Nets2NHLUE-EED9512NTHU_STAT942NTU-K92NTUBIME-1022NUU_Talk2PCSH91_3052pet2StupidClown2THU-CHE-Soft2THU_BA20002TigerBlue2TKU_EE_92C2TMU9712Violation2ADS1Agronomy-871Alice1Apay1Army-Sir1ASIA-uni1B963021XX1b_class1BLEACH1Buzz_Act1Buzz_Service1Cavaliers1CCJH12th3111CCUfinGrad921Celine1CGSH86th3161ChicagoBulls1CHUSHAN89-331ck-talk1ck50th3231ck53rd3171ck55th3141ck55th3231ck55th3291ck56th3151ck56th3311ck57th3081ck61st3211CKKN1cksh76th101cksh80th3171cksh81st3201CLAMP1CMCRX421CMU_Guitar421CMU_M481CPU_CID7311CSIE_BASKET1CSMU-D-BSK1CSMU-D891CSMU-MED941CSMU-MT921CSMU-SG1CSNT-BASKET1CTSH923011CTSH923021CYCU_ICE90AB1CYSH97Y3181D-grayman1Delivery1DIP_Gbasket1Doraemon1Dynasty1e-coupon1ESOE-951EthnosSport1EYESHIELD211FCU-PF20061FCU_ECON_93B1FCU_EE97B1fireex1FJ_Astroclub1FJU-ACC91a1FJU-EE-2004A1FJU-EE-2006B1FJU-TM1FJU_AD-041FJU_ADBA1FJU_ADY2K1FJU_Chiayun1FTP1FTV1GHIBLI1Golden-Award1Greenfield1GUNNM1H-GAME1hc3141HCHS603121HCHS923131HCKuo1HFU_me_90B1HK-movie1Horror1HPSH-93-3121HSNU_10081HSNU_10581HSNU_10601HSNU_10661HSNU_10851HSNU_11431HSNU_9491HSNU_9581ILSH-943131ILSH-963081KG94-3171KMSH_MS981Knicks1KOTDFansClub1KS87-3021KS92-3041KS93-3161KS93-3201KS94-3071KS94-3111KS94-3151KS95-3111KS97-3101KS98-3021Law-Basket1LawBasketbal1Lottery1LTJH-943061ManUtd1marvel1media-chaos1MEMS424_95th1MiamiHeat1Militarylife1MMA1museum1MusicComic1NCCU03_Stat1NCCU04_LawHa1NCCU05_CHI1NCCU05_GIDS1NCCU05_PHILO1NCCU05_PSYGR1NCCU08_Ethno1NCCU08_Math1NCCU99_DIP1NCCU_ChungYo1NCCU_SEED1NCCUEco_SC1NCHU-AGR001NCHU-AGR021NCHU-AGR041NCHU-AGR061NCHU-CE-361NCHU-FINGRAD1NCHUAGRMENBK1NCKU-IMM951NCKU-Stat-951NCTU-CVLab1NCUFingrad031NDHU-DSLS081NDHU-MBA941NDHU-MBA951NDHU-phy951NDMC-M1051NDMC-PH231NDMC-PH241NHCUE_Rover1Nicholas_Teo1NKUTEE1NOCHIGH1NSYSU_EE95-11ntnuch92b1NTOU-EBFS921NTPU-ACC871NTPU-COECO881NTU-EM911NTU-EM931NTU-Graduate1NTUAC941NTUBSE-B-941NTUBST981NTUBST991NTUCE-1021NTUCH-901NTUE-Art951NTUE-ArtBK1NTUE-CS1031NTUE_Nse961NTUE_Nse971NTUEE_LAB5261NTUEE_Speech1NTUEE_VAL1NTUGIPO_307A1NTUMSE-941NTUot941NTUST-ECE1NTUSTMIS_M951NTUT_CH585A1NTUT_en489b1NUK_EE100A1Old-Games1OtsukaAi1ouran_hosuto1P2PSoftWare1PCman1PCSH96_1071PF_BASKET1PHI_Basketba1PHX-Suns1Rockets1RSSH90_3021RSSH93_3011RSSH93_3051SCU_ACC_96A1Sean1SHUTA1Sportcenter1STUT_4EMT94A1Suckcomic1SYSOP1TCFSHvolley1TCSH561TFSHS64th3091TFSHS65th3221TFSHS66th3121TFSHS66th3261THU-CHEM941THU-P-Softbo1TKU_CE94C1TKU_TSPCB931TMU_GIMI931TS2ndChong1TTU-I90B1TTU-I91A1TTU-US941TunHua05t3111USC1UTAH-JAZZ1VET_911VET_971Warfare1wonfu1WuLing50-3031XiangSheng1YLclub1Yon1YoungDotx31Yup01-041Yup99-061YUYUHAKUSHO1YZU-EE95A1<< 收起看板(306)

首頁

尾頁

[算表] 剪下後儲存格可以同時上移或左移嗎

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

作者: unfinish - 發表於 2013/10/05 17:27(12年前)

5^F→GodOfTiger:剪下row2 → 插入剪下的儲存格 → 會變表三耶!10/05 22:46

[算表] 複製工作表到新的活頁簿，只取值 NO公式

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

作者: A1pha - 發表於 2013/05/14 17:41(12年前)

1^F→GodOfTiger:複製右鍵選擇性貼上貼上值這種方式可否?05/14 18:14

Re: [算表] Excel符合多條件就跳出特定文字

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

作者: windknife18 - 發表於 2013/02/18 09:31(13年前)

10^F推GodOfTiger:就版主大人呀 ^^"02/19 00:19

[算表] EXCEL判斷英文後抓取數字幾碼

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

作者: giunping - 發表於 2012/12/02 10:25(13年前)

1^F→GodOfTiger:B1=IF(ISERROR(MID(A1,1,1)-1),MID(A1,5,1),MID(A1,4,212/02 11:00

2^F→GodOfTiger:)12/02 11:00

3^F→GodOfTiger:) ..... 又少一個 =.="12/02 11:00

Re: [算表] EXCEL擷取資料問題(文字不定長度)

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

作者: windknife18 - 發表於 2012/09/07 11:49(13年前)

1^F推GodOfTiger:好神09/14 20:52

Re: [算表] Excel算最大連續虧損

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

作者: windknife18 - 發表於 2012/06/22 12:19(13年前)

2^F推GodOfTiger:好讚的公式呀!09/14 21:30

[算表] 把數字拆開到各儲存格

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

作者: beskur - 發表於 2012/01/30 16:30(14年前)

1^F→GodOfTiger:A2=mid($A$1,COLUMN()-1,1) 複製A2 往A3~A6貼上01/30 16:44

[算表] 儲存格內換行改成下一列

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

作者: docse - 發表於 2012/01/27 01:02(14年前)

1^F→GodOfTiger:大量(已用enter斷行)的資料先貼到記事本再貼回excel?01/27 01:09

[算表] excel凍結窗格的問題

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

作者: apexclimber - 發表於 2012/01/07 20:30(14年前)

1^F→GodOfTiger:點選 2012/1 下面那格再凍結01/07 22:28

[算表] 儲存格內字母計算

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

作者: JJabrams - 發表於 2011/12/16 17:14(14年前)

3^F→GodOfTiger:B1=LEN(A1)-LEN(SUBSTITUTE(A1,"a","")) 向下複製12/17 00:34

4^F→GodOfTiger:C1=LEN(A1)-LEN(SUBSTITUTE(A1,"b","")) 向下複製12/17 00:34

首頁

尾頁