作者查詢 / nfuman
作者 nfuman 在 PTT [ Office ] 看板的留言(推文), 共17則
限定看板：Office
看板排序：
全部NFU1059CTS809Gossiping242MobileComm134iOS124car98TY_Research85Japandrama81einvoice80Post75IME73biker46CMWang38TaiwanDrama32Liu30Lifeismoney24PeopleSeries19Shu-Lin18ShuangHe18Office17Android16ChineseMed16medstudent15AntiVirus14Militarylife14FiremanLife12SongShan12NY-Yankees9YoungDotx39Broad_Band8FITNESS8NTUB8Tai0rzSkate8fastfood7GossipPicket7Accounting6Blog6Browsers6medache6MOD6Road_Running6Uni-Service6AndyLau5Employee5FSHS-94-3165LED_MOUTH5MartialArts5NDHU-MBA955Neihu5PCSH91_3055pharmacist5Pharmacy5PingTung5specialman5Stock5TOEIC5Array4Cga4EMS4FTV4HatePolitics4Immigration4Instant_Food4JP_Custom4KMT4KS96-3184NCCU4NIU-ECE94b4NTUG-ANATOMY4NTUST-TX-B924NTUST_Talk4studyabroad4CMU_SignClub3dictionary3FCU_Talk3HCSHch13_3113Hiking3Hye-Kyo3KHCHS_TALK3KOU3KS93-3133KS95-3093KS96-3143Linux3love-vegetal3Nantou3NYUST98_FING3OTT3PttHistory3R983220PA3Road3sex3SuperTaste3Tea3THU_Talk3TuCheng3Violation3Weyslii3Anthro052Aussiekiwi2BBSview2BigShiLin2Catholic2CLHS-50-142ComGame-Plan2CVS2Datong2Delivery2Digitalhome2dlsh-7th-3032DPP2Ecophilia2Education2ElsieYeh2EuropeanCar2EuropeTravel2FLAT_CLUB2HSNU_10912hypermall2IA2JasonTsou2KEN_DOW2Kids_Sucker2KOF2KS92-3032KS92-3092KS93-3062KS94-3012KS94-3152KS94-3202KS94-3212KS95-3142Miaoli2Million_star2MobilePay2MP2MuscleBeach2NCCU_Climb2NCCU_poetry2NCKU-physiol2NDHU-His1022NDS2NH11th3053092Nintendo2NPUST2NTOU_TALK2NTPU-CSIE972NTUBST982NTUmed912NYUST2P2PSoftWare2Paradox2pesoftball2PHP2pighead2PublicHealth2RESIT2Scout2SET2SlamDunk2tajen2tax2TKU_Talk2TNFSH98th2TSU2TuTsau2TW-history2VISA2yoyo2AfterPhD1allergy1ASHS-93-li1ASIA-uni1Aves1Aviation1BabyFace1Beauty1BigPeitou1Billiard1Bunco1cafa1CareerPlan1CCJH12th3111CGSH87th_3151ChangHua1Christianity1CHU1civil871cksh83rd3101CODE_GEASS1CSMU-bridge1CSMU-CM-OP1CSMU-HSA961CSMU-MED961CSU1CTime1CTSH97EXP1CTV1CultureShock1CUST1Doraemon1Drink1E-appliance1EarthScience1Emergency1Evangelion1Facebook1FCU_EE97B1FinalFantasy1FJU-LAW20101FongShan1FuhTan1gallantry1Game-Talk1graduate1guitar1GUNDAM1hair_loss1handsomechef1Hate1HCHS_ALUMNI1HSNU_10371HSNU_11251hwhEE_592B1I-Lan1Insurance1japanavgirls1Jay1JOJO1joke1Keelung1KNU1KOTDFansClub1KS91-3191KS92-3021KS94-3221KS95-3151KS95-3161KS96-3051kualab1Lawyer1Lineage1LIT_EE971LittleNew1Liverpool1LTK1math_Base1MDU1media-chaos1MKSH-95-61movie1MRT1Mudran1MUST-SIM1N_Masami1NARUTO1NCCU01_PHILO1NCHU_GINPPA1NCUIM971NIHONGO1NSYSU1NSYSU_MSOE991NTHU_IEEM-941NTUCivilism1NTUE-CS1021NTUFS-981NTUMiaoli1NTUT_EE490A1NUK_AC991Nurse1NUU_Motor1NYUST_MOTOR1PDA1pet1Pet_Get1PhD1politics1Ptt-Charity1San-Ying1SCU_BM_VB1SF1SMSlife1soul1Stephen1STU1STUST1SuperHeroes1Supermission1Supersnail1SW_Job1SYSOP1TA_AN1TaiShan1TAXI1TCIVS1Teacher1TFSHS64th3161TFSHS66th3211TFSHS68th3121THUIM-5th1TKU_EW94B1TPC_Police1TTSH12th3091TW-language1UetoAya1USC1VET_961Wanhua1Warfare1Windows1WRADPE1Wrong_spell1WTUC_talk1YuiAragaki1Yunlin1YZU_MBA971<< 收起看板(316)
首頁
上一頁
1
下一頁
尾頁
1F→:現在我的問題卡在月份若有日期重複的話要怎麼樣取一次....01/14 18:53
3F→:Soyoso大，如果題目改成這樣該如何修正呢？01/14 22:27
5F→:SOYO大，1/8號有3筆可以只算成1筆嗎？01/14 22:40
7F→:我的月份次數統計要以天不重複的值計算01/14 22:42
8F→:soyo大，1月還是5筆餒，我今天一直卡在這裡XDD01/14 22:45
10F→:SOYO大AMJ那欄位是?01/14 22:58
12F→:ROW($A$1:$AMJ$9)*(MONTH($sheet1.$A$1:$A$9)01/14 23:04
16F→:SOYO大，因為我家裡是OPENOFFICE所以我不知道會不會有差...01/14 23:11
18F→:ROW($A$1:$A$9)*(MONTH($sheet1.$A$1:$A$9)=COLUMN()01/14 23:18
19F→:SOYO大可以解釋一下嗎? 這段看不太清楚01/14 23:18
21F→:感謝SOYO大01/14 23:31
22F→:可是SOYO大，月份的條件值不用給判別嗎？還是向左拉就好了?01/14 23:35
24F→:SOYO大，ROW($A$1:$A$9)跟Row($1:$9)是一樣意思嘛?01/15 00:01
25F→:SOYO大如果從頭拉到尾就能顯示1-12月的統計嗎?01/15 00:03
26F→:因為我想法卡在若沒給它條件指定月份值的話，怎麼去統計。01/15 00:04
27F→:它的sheet2 A2 B2 C2值怎麼能對應到月份值的統計結果？01/15 00:10
31F→:感謝SOYO大01/15 00:16
首頁
上一頁
1
下一頁
尾頁