作者查詢 / ZZZZ0
作者 ZZZZ0 在 PTT [ Office ] 看板的留言(推文), 共35則
限定看板:Office
看板排序:
全部Gossiping357Accounting105car82Office35Storage_Zone18NTPU-ACC8714Cheer10MOD9NCHU_MBA_969NTPU-ACC899sex9WorldCup9cookclub8NewYork7HBO6BigBanciao5motor_detail5Old-Games5tax5YOLO5EZsoft4Broad_Band3CarShop3Emulator3Master_D3PhD3Tai-travel3AntiVirus2CCHS-98012EAseries2Google2Hate2HCSHch13_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推:原來可以這樣填滿呀!!!受教了Orz07/12 02:14
1F推:換顯卡07/11 16:32
1F推:小計的部分還是可以試看看,可以把各品項整理出來07/11 17:39
2F→:至於你要的那個,我猜只能用access條件查詢07/11 17:40
3F推:想了一下,利用indirect、count、column或row,或許可以07/11 18:08
4F→:不過那要花太多時間去設計,不如直接用access07/11 18:09
1F推:列出同品項名稱的部分,有試過小計嗎?07/11 11:31
2F→:2跟3,不確定你的最終需求,應該用自動篩選就可以辦到07/11 11:32
3F→:如果三個全部都要合併在一起,可能有點困難07/11 11:33
1F推:=if(c1>="門檻",c1,"."),自動填滿07/11 11:26
1F推:沒辦法,A1一定要自己獨立劃格線…07/09 16:54
1F推:就把B欄全部加起來?07/08 23:51
2F→:=sum(B:B)07/08 23:52
1F推:1.你在sum什麼? 2.看不太懂問題,只能用猜的07/07 01:29
2F→:我建議你使用indirect加上column或row使用07/07 01:29
6F推:sorry…不是不教,是用起來太複雜,你可以自己看一下函數07/07 02:42
7F→:因為公式要設兩、三層,有需要的話,我有空可以幫做07/07 02:43
8F→:至於copy的指令,則沒必要,前面設得好的話,只要改,再拉07/07 02:45
1F推:vlookup?07/05 12:44
1F推:large07/03 14:32