作者查詢 / wxtab019
作者 wxtab019 在 PTT [ Office ] 看板的留言(推文), 共46則
限定看板:Office
看板排序:
全部C_Chat19603TurtleSoup15766KanColle13400ask8551Gossiping6922sanguosha2372Little-Games1041Salary717Tech_Job656LightNovel560joke495Suckcomic448SMSlife441puzzle403Math281MJ_JP273FuMouDiscuss210StupidClown202CCU_talk187TaichungBun180Hunter138CrazyArcade133Master_D110Lifeismoney88Instant_Mess87Browsers86DMM_GAMES83ONE_PIECE83graduate81Chiayi79NARUTO77C_BOO72CVS67Hayate61biker60C_and_CPP54GO47Q_ary47Android46Office46Bank_Service44cookclub42AOE37EatToDie37PublicIssue37Mechanical34Teacher30FAIRYTAIL29Inference27MATLAB27Windows27Conan26tax26Broad_Band25Militarylife24MobileComm24BoardGame23C_ChatBM21Physics18Stock17PttHistory16Vtuber16Electronics15fivesix15HatePolitics15Old-Games15PttEarnMoney15Shokugeki15TNFSH102nd15Instant_Food14kodomo14Minecraft14Food13Vocaloid12Gintama11HitmanReborn11C_Sharp10KenAkamatsu10specialman10IC-Card9Visual_Basic9ASM8EZsoft8Isayama8NTU8TypeMoon8AC_In7BabyMother7CS_TEACHER7Google7Kaohsiung7LittleFight7medstudent7Steam7Suckgame7TWvoice7Baseball6Doraemon6GL6home-sale6PokeMon6SENIORHIGH6SYSOP6AfterPhD5bicycle5Bus5creditcard5Employee5hololive5L_TalkandCha5LoL5Map-Guide5Monkeys5Shana5Soft_Job5toberich5Ajax4Anti-ramp4cat4Comic4dog4Expansion074HK-movie4Hualien4RO4Road_Running4sky4TY_Research4WomenTalk4Yunlin4AskBoard3book3CFantasy3gay3hardware3J-PopStation3Jacky_Woo3Marginalman3NewYork3PublicServan3rent-exp3Road3Savage3Stall3Wanhua3Angela2ArakawaCow2BaseballXXXX2BBSmovie2Beauty2BigBanciao2C_Question2car2Childhood2DIABLO2digitalk2Doctor-Info2Ecophilia2FATE_GO2FBG2Garena2H-GAME2HsinTien2ID_Multi2Interdiscip2juniorhigh2kawaii2Keelung2Koei2KS98-3022Kyoto_Ani2L_LifeInfo2L_TaiwanPlaz2LAW2MayDay2nb-shopping2NSwitch2Nurarihyon2PingTung2sex2Shu-Lin2ShuangHe2SongShan2SouthPark2tabletennis2talk2Taoism2Wine2Airantou1AngelPray1AntiVirus1Aquarius1ARIA1Army-Sir1asciiart1Aussiekiwi1Aviation1Badminton1basketball1BIGBANG1Billiard1C_WorkBoard1CMstudents1DIGIMON1DummyHistory1EarthQuake261EarthQuake431EzHotKey1Falcom1FCU_Talk1Finance1funeral1GBF1GetMarry1give1Golden-Award1GossipPicket1Hate1Hip-Hop1IA1IME1Insurance1iOS1japanavgirls1JapanHistory1JodyChiang1JOJO1JP_Entertain1KOTDFansClub1KUAS1Linux1love-vegetal1MartialArts1marvel1medache1MenTalk1Mix_Match1MJ1movie1MP3-player1MuscleBeach1museum1MusicGame1Nangang1Nantou1NBA1NCTU_TALK1NitroPlus1nobunyaga1Notebook1NSYSU1Nurse1Oni_soul1PlayStation1PSP-PSV1Ptt-Charity1PttCard1PttLifeLaw1PublicBike1Railway1RDSS1S.H.E1Sagittarius1San-Ying1SET1SF1SoundHorizon1stationery1Stephen1street_style1studyteacher1SuckcomicBM1SuperHeroes1TaichungCont1Tainan1Taoyuan1ToS1TW-language1Violation1W-Philosophy1Yabuki1YOLO1YozoraMel1<< 收起看板(283)
3F→: 也可以就直接=就好06/13 19:48
1F→: 某些字型沒有正確安裝?06/09 21:46
3F→: 感覺直接插入比較不麻煩03/08 18:22
1F→: 不是不能用 是沒有設定吧02/28 18:03
2F→: 而且不是alt+enter嗎02/28 18:04
3F→: 不然就是看自動換列的有沒有設定02/28 18:05
1F→: Tab ?01/31 01:00
1F→: 不用巨集吧01/29 04:38
2F→: =INDIRECT("Sheet1!"&ADDRESS(COLUMN(A1),ROW(A1)))01/29 04:38
3F→: 就普通行列互換而已吧01/29 04:38
1F→: 方法1 2 3 的數值不要用1呢? 像是方法1用1 方法2用201/21 06:32
2F→: 0的話也不會是空白 還是會有001/21 06:33
1F→: 另外在d欄用個1~60 然後e f就用vlookup去對照b c ?11/15 10:44
7F→: 有什麼規律嗎 還是每次填都有固定位置10/11 15:58
8F→: 有的話直接用=就好了10/11 15:59
9F→: 看起來是千位數的開頭 最大和最小值各取一個?10/11 16:00
10F→: 如果是有database 可能可以用Dmax Dmin10/11 16:11
11F→: 不然就是用輔助儲存格先找千位數判斷再取max min10/11 16:12
1F→: /多個 /excel /合併09/28 01:00