作者查詢 / DreamerSun

總覽項目： 發文 | 留言 | 暱稱
作者 DreamerSun 在 PTT [ Office ] 看板的留言(推文), 共12則
限定看板：Office
看板排序：
全部Tennis4429Gossiping3338Roddick3085Baseball1606Boy-Girl1227Libra515WomenTalk461tennis_life455Olympics_ISG432Militarylife403Salary399DigiCurrency386NBA346TaichungBun288sex250Tech_Job226japanavgirls218movie206CATCH171TaiwanDrama145MiamiHeat143EAseries142ONE_PIECE140LoL130SET98DIABLO94TW_Entertain90Federer88joke83Transfer83Stock72SportLottery61Moto_GP58feminine_sex57FuMouDiscuss57Mix_Match57Golden-Award55AllTogether54StupidClown44Beauty43Hewitt37MLB34ask33NBA_Film33FCU_Talk32hairdo32BLEACH29iOS27Lottery27SuperIdol27PC_Shopping25PokemonGO25US_Army25Songs23C_Chat22Elephants22Lifeismoney21unemployed21VL21part-time19Nadal18job17nb-shopping17Aries16MenTalk16Scorpio16basketballTW15HatePolitics15specialman15STUST15TOEIC15Facebook14ToS14Bioindustry13car13WorldCup13Office12Djokovic11Hearthstone10PublicIssue10HBL9LeBronJames9LoL_Picket9BB_Online8Eng-Class8Japan_Travel8PttLifeLaw8marvel7CareerPlan6SMSlife6Android5AUS_Tennis5ChungLi5ComeHere5FreeStyle5hair_loss5Hunter5rent-exp5Badminton4Bank_Service4BigSanchung4ChrisWang4e-shopping4Hsinchu4Jacky_Woo4L_TalkandCha4marriage4MobileComm4NARUTO4SNSD4YOLO4Anti-Cancer3ArtCenter3Aviation3Celine3Celtics3China-Drama3Employee3ESOE-TENNIS3Fighters3gallantry3home-sale3IVERSON3Knicks3LCD3Miaoli3Oracles3Rockets3SFGiants3Soft_Job3Spain_PL3TAROT3ADS2ALL-RUSSIANS2Ancient2BCC_Midnight2car-pool2chatskill2Coldplay2Engineer2Fantasy2Gintama2Grizzlies2GuessX32HardwareSale2Hawks2HIMYM2Hualien2Instant_Mess2KS94-3212KS98-3022KS98-3162Linyuan2Loan2Mauresmo2MKSH-95-62NBAEasyChat2NCAA2NTHU-MSE122Nuggets2Orl-Magic2Oversea_Job2OverWatch2PACERS2PingTung2Rent_tao2SHAQ2SRB-CRO2SteveNash132SuperHeroes2SuperStar2TA_AN2Tainan2Taipei2Taoyuan2Teacher2Thunder2TuCheng2TW-M-Tennis2TY_Research2UTAH-JAZZ2V_ScHooL2WarCraft2WOW2Wrestle2Yunlin2A-MEI1AIR_JORDAN1AOE1bag1Balloon1BigShiLin1biker1Biology1BLAZERS1BuyTogether1Cavaliers1CGSH86th3171ChangHua1Chihlee1Christianity1creditcard1CrossStrait1CSMU-D991CSMU-MED971CSonline1CTUST1Disabled1dog1EDR1ELSWORD1Examination1EYESHIELD211FAIRYTAIL1Feminism1FengYuan1FRA_hotties1GBR_Tennis1Google1Guardians1HCHS593051Hip-Hop1historia1HsinChuang1HsinTien1HSNU_9791Insurance1Japandrama1JapanStudy1Jay1Jeremy_Lin1kartrider1Keelung1Ken-Hirai1Kindaichi_Q1Kings1KS92-3131LaClippers1Lions1LS_Tennis1MAC1MacShop1Mavericks1MayDay1MdnCNhistory1media-chaos1Media-work1Military1mobile-game1mobilesales1MOD1money1Nantou1NCCU1NCCU08_Ethno1NCCU_Tennis1nCoV20191Nets1NKUTEE1NTHU_MDL1NTHU_pingpon1NTU1NTUBSE-B-1001NTUHISVOLLEY1NTUMEB951NTUT_IPET4951NUK_AC981NUMB3RS1optical1Ourmovies1pighead1Railway1RIPE_gender1San-Ying1Scenarist1ScienceNote1SFFamily1Sharapova1SHU_LawGrad1SK_SD_PL1SkiSnowboard1soho1soul1SuperBike1SuperStarAve1TaichungCont1TCIVS1TennisGame1TennisTeam1The-fighting1Theater1THSRshare1Timberwolves1TKU_Talk1True-Escape1TW-history1TWproducts1VideoCard1Wanhua1Wen-Shan1Whales1Wizards1YAO1Zhongshan1Zhongzheng1<< 收起看板(305)
首頁
上一頁
1
下一頁
尾頁
[算表] Vlookup可以搭配篩選格的變動來搜尋嗎？
[ Office ]15 留言, 推噓總分: 0
作者: DreamerSun - 發表於 2020/01/11 00:20(4年前)
8F→DreamerSun: 謝謝S大，您真的好神！01/11 17:37
9F→DreamerSun: 您說的是對的 是以篩選的第一筆資料01/11 17:37
10F→DreamerSun: 抱歉小弟用詞不精準01/11 17:37
11F→DreamerSun: 感謝您的指導，小弟再去研究您公式的邏輯與原理01/11 17:38
12F→DreamerSun: 另外請教您圖中 I23, J23, K23的數字是用Vlookup的嗎01/11 17:38
15F→DreamerSun: 感謝S大的善心指導！！01/14 09:00
[問題] excel資料比對 （含特殊符號）
[ Office ]10 留言, 推噓總分: +1
作者: DreamerSun - 發表於 2019/08/13 17:50(4年前)
3F→DreamerSun: 謝謝s大 如果資料量大的話 且有不同符號也是一樣嗎？08/13 17:58
5F→DreamerSun: 英文的句號 . 跟上述說的 -08/13 18:00
8F→DreamerSun: 謝謝s大！超強08/13 18:17
9F→DreamerSun: 祝您事事順心08/13 18:17
[算表] 凍結窗格與設定格式化條件
[ Office ]7 留言, 推噓總分: 0
作者: DreamerSun - 發表於 2018/07/03 22:42(5年前)
6F→DreamerSun: 謝謝S大！07/04 22:03
7F→DreamerSun: 感謝您特地錄製教學07/04 22:05
首頁
上一頁
1
下一頁
尾頁