作者查詢 / verdant
作者 verdant 在 PTT [ Office ] 看板的留言(推文), 共36則
限定看板:Office
看板排序:
全部Gossiping2545Baseball430HOT_Game99Civil55HatePolitics50movie43Office36Magic29japanavgirls28painting26Architecture16Family14joke14media-chaos14Monkeys14TW-language10Hearthstone9MP9Cognitive7Digital_Art7HCKuo7FuMouDiscuss5Lions5NBA5WomenTalk5Beauty4C_Chat4e-shopping4GetMarry3L_TalkandCha3sex3ASHS-93-li2Boy-Girl2Cad_Cae2cksh83rd3032DummyHistory2Emergency2FLAT_CLUB2Guardians2IA2JinYong2KS98-3022Militarylife2NDHU-His1002NTPU-STAT962PublicIssue2Salary2specialman2THU_BA20002TigerBlue2TTU-AFL2TuTsau2USC2AfterPhD1ask-why1BaseballXXXX1BigBanciao1car1Catholic1Childhood1Christianity1cjjhs3271ck57th3091CMWang1Cobras1Conan1CrossStrait1DragonBall1Eason1Evangelion1FAPL1Feminism1Fencing1forsale1France1Gintama1Google1Hate1Hsinchu1HsinChuang1HSNU_8971hypermall1Ichiro1ILSH_923121INSECT-951JOB-Hunting1KOU1Lomo1LTK1Math1MdnCNhistory1MrFullswing1NCCU_SEED1NCHU_CsHsnu1NDMC-PH251Non-Graduate1NSYSU_MSOE991NTNU-SLM951NTU-Fantasy1NTUBilliard1NTUF-971NTULawHome1NTUND931Oceanography1Oh-Jesus1part-time1PttHistory1PublicServan1SENIORHIGH1Sijhih1soho1STU1StupidClown1Suckcomic1Tainan1Taitung1Tea1Teacher1Tech_Job1Test1TFSHS61st3211TFSHS65th3091tutor1TW-history1Violation1WorkinChina1<< 收起看板(126)
3F→: 喔喔OK了!!大感謝!!!03/10 14:11
2F推:如果要替換的是一串文字裡面的某幾個字就用SUBSTITUTE04/01 17:40
1F推:你的格數有多少? 其實用 & 就行了05/16 16:51
2F推:http://ppt.cc/wEjy05/16 17:00
1F推:你的AAAAA都是一樣的嗎?如果這樣就簡單08/05 10:16
2F→:先在C1儲存格輸入 =A108/05 10:19
3F→:然後在C2儲存格輸入 =IF(A2="AAAAA",A1,C1)08/05 10:20
4F→:將公式整個複製下去,然後以C列作篩選就好了08/05 10:21
5F→:C2儲存格更正 =IF(A2="AAAAAA",C1,A2)08/05 10:23
3F推:在C1儲存格打上 =A1&" "&B1 然後複製下來就可以了07/12 11:01
2F推:開一欄C1:C10 C1=A1&B1 然後用COUNTIF(..."男有"..)就好了06/27 16:37
1F推:問題二 =INDIRECT("F"&1+(ROW()-1)*2)03/23 18:01
2F→:不知道你的意思是不是這樣03/23 18:01
1F推:你沒有開在同一個EXCEL視窗下 不要直接點檔案03/14 15:45
2F→:用開啟舊檔打開兩個不同的檔案 就可以直接互貼公式了03/14 15:46
5F推:c=IF(ISERROR(A+B),"",A+B)03/02 08:13
4F推:=IF(AND(A1<b,A1>a),1/(b-a),0) 假設a、b是已知常數10/11 21:32
5F→:然後X值位於A行10/11 21:33