作者查詢 / sebu
作者 sebu 在 PTT [ Office ] 看板的留言(推文), 共42則
限定看板:Office
看板排序:
全部Japandrama6214Baseball4305Lions3866Gossiping881Moto_GP308HatePolitics291BaseballXXXX241JP_Entertain235J-PopStation208Hsinchu205Golden-Award202TaiwanDrama193Beauty176NobuOnline114japanavgirls84Olympics_ISG81TW_Entertain80bicycle66C_Chat61movie61Boy-Girl59iOS59NBA59Office42Military41WomenTalk38MobileComm33basketballTW27Koei27Stock27Tech_Job25PokemonGO24nobunyaga21Hate18China-Drama17Jacky16MLB15ONE_PIECE15StupidClown12Lifeismoney10joke9Tennis9NSwitch8PokeMon8sex7Android5MIS5MISIA5The-fighting5Football4Fund4marvel4nCoV20194Suckcomic4Whales4CTime3DIABLO3Dota_Legend3Elephants3FORMULA13Guardians3Monkeys3PeopleSeries3swim3THU_BA20003TigerBlue3TY_Research3YOLO3AntiVirus2bicycle-tour2BLEACH2CoC2ComeHere2DiscoveryNGC2feminine_sex2HCHS_ALUMNI2HotBloodYuan2HSNU_8202hypermall2JingXingBoys2kochikame2LeBronJames2LivingGoods2MAC2NTUEOE_R306A2P2PSoftWare2SakaTalk2Salary2StrikeShoot2TA_AN2Tokusatsu2TTU-AMath2WorldCup2AndyLau1AnimalForest1Anti-ramp1Arashi1Asian-MLB1AtsukoMaeda1BabyBears1Bowling1CATCH1CCSH_92_3161CGI-Game1ChicagoBulls1ck50th3231ck57th3151ck58th3071ck_17_3011cksh80th3011cksh80th3141cksh82nd3221Cobras1CPU_CID7311creditcard1CSMU-AC921CSMU-MED901CSMU-N921CSMUdancepub1CTSH923061CYCU_Chem92b1CYCUEL95A1Drink1DYU1e-shopping1Eagles1EAseries1EYESHIELD211EZsoft1FJU-ACCR941FJU_AD-021FLAT_CLUB1Future-Star1gallantry1Gov_owned1HCHS583181HCKuo1HsinTien1HSNU_10081HSNU_8751HSNU_9261HSNU_9631Instant_Mess1JinYong1KG93-3131KMSH_C981KMT1KS91-3031KUAS_IEM941L_ShoppingMa1Lan-Yu1MayDay1MdnCNhistory1MiamiHeat1mobile-game1NAOE-861NCCU04_TUR1NCCU05_CHI1NCCU05_DIP1NCHU-AGR021NCHUS1NDHU-His1001NDHU_ACC_BT1NH11th3053091NTHU-EE-CAPT1NTHU_IEEM-941NTHU_LST_941NTUE-EPC-951NTUEE-Lab5301NTUEE-MBElab1NTUEESOCCER1Orioles1PCman1PDA1Poker1PresidentLi1SFFamily1shoes1SK_SD_PL1Songs1specialman1SSSH-16th-Fk1Stephen1Sub_GMobile1TFSHS64th3091TFSHS64th3181Tigers1TKU-ee-91a1TS2ndChong1TTU-I90B1wikibaseball1worldbasket1Wrestle1WSBL1YP95-3121YZU_CN99A1YZU_EE95B1<< 收起看板(197)
2F→:沒有...原來就是標準模式了03/07 11:37
5F→:soyoso 可以了~果然是欄隱藏,謝謝你~ 另外再請教一下03/07 11:53
6F→:我現在點這個檔都會出現 http://imgur.com/E0QnmXC03/07 11:53
7F→:有辦法拿掉嗎? 因為我在檔案>資訊>保護拿都取消密碼了03/07 11:55
8F→:一旦檔案關掉再開又要再輸入密碼03/07 11:55
10F→:可以了...謝謝03/07 12:02
2F→:vlookup我記得要最左邊那欄要先排序好才能查表03/05 11:51
3F→:這樣不會發生查錯的問題嗎?03/05 11:52
5F→:可以了,感謝soyoso的解惑 !03/05 12:55
3F→:我主要目的是當A2>0時 B3=A1-A2但同時B1,B2都要是001/16 16:42
4F→:A1~A2 ,B1~B3皆是>=0的數值01/16 16:43
6F→:B1,B2不為0時就顯示格子裡的數值,因為這兩格是其他格計算出來01/16 16:47
7F→:的加總我會放在這兩格01/16 16:47
10F→:soyoso 是的,你理解沒有錯01/16 17:15
12F→:soyoso大,你的算式在A1和B1有數值時,我A2填一個數字進來後01/16 17:35
13F→:B1不會變001/16 17:36
19F→:晚點再試試,感謝01/16 18:29
6F→:謝謝soyoso, 我回去研究一下12/13 16:45
7F→:請問0/((A1:A8="0001")*(C1:C8="預約"))這段意義是什麼?12/15 16:03
8F→:因為我用 (A1:A8="0001")*(C1:C8="預約")一樣也可以得到結果12/15 16:04
12F→:噢...了解了,感謝解說!12/15 16:54