作者查詢 / newacc
作者 newacc 在 PTT [ Office ] 看板的留言(推文), 共1727則
限定看板:Office
看板排序:
全部ask2108Office1727juniorhigh671NTUMEB98437Rubiks426TCFSH70TH322326NtuDormM1321puzzle257Little-Games235NTU230CGI-Game220Gossiping189WorldCup149GuildWars131TFSHS129Taitung116CVS89SENIORHIGH81NtuDormM375StupidClown72joke67Windows66Hiking63mobile-game58creditcard52Visual_Basic39Stock37DIABLO35tutor35Navy34Lifeismoney28NTUMEB9927ascii_wanted25NTUcourse23Android22CFP22MobilePay22movie22Divina21NTU-Exam21Q_ary20MayDay18PushDoll16Bank_Service14ForeignEX14hardware14SYSOP13Test13Baseball12marvel10BBSmovie9Steam9HOT_Game8MobileComm8NTUboardgame8Storage_Zone8TaichungBun8TFSHS67th3248HatePolitics7TY_Research7C_and_CPP6fastfood6GVOnline6LoveLive6outdoorgear6Volunteer6B98303XXX5Doctor-Info5HomeTeach5PttCard5QuestCenter5Teacher5Broad_Band4DYU4forsale4Google4memento4nb-shopping4NIU-ECE94b4Notebook4NTCUST4Olympics_ISG4PC_Shopping4PttHistory4Tai-travel4Viator4Viator93Chia4Viator96Gang4Viator97Chia4Viator97Yii4AntiVirus3ask-why3BoardGame3civil983CT24th3373CY-academic3e-coupon3Fund3HSNU_11663Mabinogi3NetRumor3NTHU_STAT943NTU-MAGIC3NTU09DFLL3NTU_trans3NTUCE-1023NtuDormM53NTUMETA3TFSHS65th3093TigerBlue3TurtleSoup3Anthro092Anthro122AOE2AskBoard2biker2cat2Childhood2CHSH_98_3202CMU_BST012Donate-Blood2Doraemon2DragonNest2ENG_Service2FixMyHouse2FLAT_CLUB2HardwareSale2KS97-3082L_LifeInfo2LCD2Math2MCU_Talk2MIS2NCUT2ntuACCT042NTUCH-1022NTUDormM72NTUEE1132NTUEE_Speech2NTUIB022NTUMEB952NTUSA2NUU_Talk2PathofExile2PttEarnMoney2PttLifeLaw2Shu-Lin2ShuangHe2Supermission2TAROT2TCFSH67TH102TCFSH69th3022tcfsh69th3042WuLing50-3172YiGo3112YLSH_863032YZU_EE99B2Agronomy-981AngelPray1Aves1B00A013XX1B97A013XX1b98610xxx1b98902xxx1B98A013XX1bicycle1BlackDesert1Campus-plan1CCU_Comm5241chatskill1cksh79th161Clothes1CMU_CM421CMU_M501CMU_M511CMWang1CrazyArcade1CSMU-D881CSMU-D981CSMU-HSA941CSMU-HSA971CSMU-MED951CSMU-MSSW941CSMUACAlumni1CSU1CYCU_ICE90AB1CYCU_MIS_93B1CYSH97Y3181Daan1Daliao1Datong1DigiCurrency1DigitalMusic1DoubleMajor1DragonBall1DTJH_3221Ecophilia1Emergency1EMS1Eng-Class1Fahrenheit1feminine_sex1FJU-EE-2005B1FJU-EE-VLSI1FJU-STAT91B1Food1FSHS-92-3101GameDesign1GetBackers1GetMarry1HCHS603121HCSHch13_3111HCU1HonorGuard1HsinYi1HSNU_10321HSNU_11461HSNU_11681HSNU_9481humanity1IAM_Aero0071ILSH-973091Instant_Food1Jam1kartrider1katncandix21KHCHS_TALK1KS96-3181KS97-3021KS98-3021KUAS1KUAS_ME94A1LadyGaga1Linyuan1Liu1LivingGoods1lizen34-6011LSSH1Matsu1ME-BASEBALL1MenTalk1model1music1N_E_Coastal1NCCU07_GID1NCCU07_SW1NCCU08_JAPAN1NCCU08_LawA1NCCU08_Math1NCCU09_LawA1NCCU09_LawB1NCCU09_LawC1NCCU_PFBASE1NCCUflamenco1NCHU-AE991NCHU-Wind1NCHU_CsHsnu1NCUMTClub1NCYU_Fst_991NDHU-Ch1001NDHU-Ch1011NDHU-Ch991Neihu1Network1North_Coast1NTIT_IMD921NTOU_TALK1NTU-K11NTU-Karate1NTU-OMIH991NTU-Puzzle1NTU_BOTDorm1NTUAC-Badmin1ntuACCT031NTUBIME-1031NTUBIME-1041NTUBIME102HW1NTUBIME103HW1NTUBSE-B-1001NTUBSE-B-981NTUDormFJr1NTUDormG31NTUE-TTB1NTUEE_LAB5061NTUF-981NTUHORTI981NTUIB031NTUMEB001NTUmed001NTUmed911NTUMiaoli1NTUphy001NTUphy991NTUPPM-971NTUPPM-981NTUST_Talk1NUK_AC1001NUK_EE100A1NUU-SHE-971OCU1ONE_PIECE1PCGC1photo1phys981points1PresidentLi1PSWO3rd1PTGS62nd3131PttBug1PttNewhand1PU_Family1R983220PT1RealPlaying1RootsnShoots1SCUG1share1SMSlife1Soft_Job1SongShan1SSSH_17th3141STDM-97-301A1Stephen1Sub_GMobile1Sub_GOnline1TaichungCont1Tainan1TaiShan1Taiwan3191tajen1TCFSH69th3061TCFSH70th3181TCFSH70th3201TCFSH70th3231TCFSHvolley1TFG07Shot1TFSHS68th3061TFSHS68th3211TFSHS69th3091TFSHS69th3211TFSHS69th3221TFSHS69th3231THU_Talk1THUIM-4th1TKU_ACC_95A1TKU_S92BIO1ToS1TSU_talk1TYSH49-3021USC1VAPE1VET_981Viator98Bing1Violation1Volleyball1Wanhua1Wanted1Wen-Shan1Wrestle1WuGu-BaLi1Zhongshan1<< 收起看板(360)
5F→: 008是國際受話方付費服務,01是中華電信管理的09/16 16:47
1F→: reddit鄉民推薦用條件式格式設定08/21 14:38
2F→: https://bit.ly/3HLCUMv08/21 14:38
1F→: 你應該是用條件式格式設定做的吧?08/15 18:04
2F→: 第一題,選擇「管理規則」之後,將「套用到」改為你所有需08/15 18:04
3F→: 要套用的格子08/15 18:04
4F→: 第二題,整列的話用公式會比較好做08/15 18:06
5F→: =$D3="是",然後範圍放整個資料區域08/15 18:07
6F→: https://i.meee.com.tw/QM4iYGr.png08/15 18:10
7F→: 阿沒看清楚題目是設定日期,不過只是範例不同而已,套用方08/15 18:11
8F→: 式是一樣的08/15 18:11
9F→: 使用公式時留意固定符號,並且是以最左上角的格子作基準08/15 18:13
1F推: 左上角不要開自動儲存08/12 00:07
3F→: 咦,介面不一樣 https://i.meee.com.tw/5Boo7Fb.png08/12 10:04
4F→: 你看看有沒有框起來的那個選項,取消就不會自動存08/12 10:06
5F→: https://i.meee.com.tw/WHx1n3R.png08/12 10:06
6F→: 跟是不是存在 onedrive 沒有絕對關係,存在 onedrive 預設08/12 10:07
7F→: 是自動存,不過也可以關閉自動儲存08/12 10:07
8F→: 對,我是365,我以為2024很新應該差不多 0rz08/12 11:02
1F→: 10000=(X-'1月1日'+1)/365,解 X ?08/08 09:53
2F→: 10000=1000000*0.03*(X-"1/1"+1)/36508/08 09:55
4F→: 我理解沒錯誤的話,這個就單純是列式問題了08/08 11:53
5F→: X=ROUNDDOWN(還款金額*365/本金/利率-1)+開始日08/08 11:54
1F推: Basic 沒有 mac 和 PC 授權05/28 21:59
1F→: VBA一行只做一件事,你這個寫法的意思是,將tswh=Range()05/11 15:49
2F→: 的值assign給Range("A3")05/11 15:50
3F→: 而在這個語法中,後面那個=並不是賦值,而是「是否相等」05/11 15:50
4F→: 要改寫的話,應該要改成這樣:05/11 15:51
5F→: Range("A3").Value = Range("B2").Width05/11 15:52
1F推: 它必須是三個獨立的表格,但仍然會有框線粗細的點差,可05/05 23:56
2F→: 以看我上篇的圖05/05 23:56
1F推: 先做出三個只有兩欄一列的大格子,再個別分割成需要的列05/01 21:51
2F→: 數,這樣應該就可以外表等高但列數不同了吧05/01 21:51
3F推: 做出來大概長這樣 https://i.imgur.com/uJzf9ed.png05/01 22:10
1F推: 用VALUE(實際股價)去判斷,就可以讓空字串被視為004/27 21:24