作者查詢 / peiring

總覽項目: 發文 | 留言 | 暱稱
作者 peiring 在 PTT [ Office ] 看板的留言(推文), 共11則
限定看板:Office
看板排序:
全部Gossiping68146WomenTalk17429movie5662StupidClown284Sebastian253joke154sex147Salary133HatePolitics116SuperHeroes96Lefty91FuMouDiscuss86Military84Golden-Award82feminine_sex79gay78Examination59unemployed53EAseries51Teacher47China-Drama44Tainan43PublicIssue37Militarylife34car31YOLO29Tech_Job28MenTalk26Finance25L_TalkandCha25Cga24Eda_Pitcher23Kaohsiung23TaiwanDrama18Insurance17PingTung16home-sale15PublicServan15AfterPhD14Boy-Girl14TaichungBun14specialman13Matsu12TWHiddleston12CrossStrait11NCHUS11Office11EarthQuake2610EarthQuake4310HK-movie10IA10MACAU10NTU10Shu-Lin10biker9Stock9Taoyuan9Baseball8Guardians8HsinChuang8Ourmovies8ShuangHe8Wanhua8Olympics_ISG7PttLifeLaw7SouthPark7Elephants6Hsinchu6LAW6Aboriginal5Alec_Su5Aves5BigBanciao5C_Chat5CPBL_Retired5CPBL_veteran5Crowd5CVS5Everton5medstudent5Miaoli5Monkeys5NCTU_TALK5PH-sea5PhD5rent-exp5Taitung5Yunlin5cat4FiremanLife4graduate4Hualien4japanavgirls4JJ4kodomo4LGBT_SEX4LTK4marvel4SMSlife4studyteacher4Theater4Women_Picket4AirForce3Anti-Cancer3Anti-ramp3boxoffice3CFantasy3ChangHua3Emergency3Employee3FIR3gallantry3GossipPicket3HsinTien3kawaii3KS98-3023LawsuitSug3Lions3Marginalman3SCU_Talk3SongShan3swim3Urban_Plan3Whales3WorldCup3AC_In2aqua-shop2Aviation2BabyMother2Bank_Service2Bus2CareerLady2Childhood2Christianity2CMstudents2ColinFirth2CTV2DivingSport2dog2Drink2Hamster2Hip-Hop2Hong_Kong2HotBloodYuan2IC-Card2Jinmen2L_TaiwanPlaz2MartialArts2Mongolia2MuscleBeach2Nangang2Nantou2nCoV20192Neihu2Nurse2pharmacist2Post2Ptt-Charity2PttEarnMoney2railtour2RIPE_gender2Sijhih2soho2SuperBike2SurvivalGame2Test2TigerBlue2Weyslii2A-BAW1About_Life1AllTogether1Aquarium1Audiophile1Aussiekiwi1BabyBears1basketballTW1Beauty1Bioindustry1Biology1book1Buddhism1Bunco1calligraphic1CantonesePOP1CATCH1CCRomance1CCU_talk1CFP1Cheerleader1Chiayi1chocolate1Civil1CKSHTalk1Coffee1CSMUdancepub1CTS1Daliao1Depstore1DirectSales1Disney1DSLR1Ecophilia1Euthanasia1facelift1fastfood1FatMonkeys1FJU1FJU-Laws971Folklore1FongShan1Football1France1FTV1Geography1Gintama1Gov_owned1Hate1Hearthstone1Hiking1historia1HK-drama1Hotel1hotspring1HRM1HSNU_10821hypermall1I-Lan1Ironman1Jacky_Woo1Japan_Travel1Jeremy1Keelung1KMU1kochikame1KOTDFansClub1Law-Fala1lesbian1LinKou1LoL1Lottery1Malaysia1MapleStory1marriage1media-chaos1Minecraft1MobileComm1Motel1N_E_Coastal1NBA1NCCU1NCCU_M.B1NCYU_Fst_981NTTU_CSIE991NTUHistory021NUU_Talk1Option1Palmar_Drama1PC_Shopping1Philippines1PlayStation1politics1Property_M1rabbit1Reptile1Road1Road_Running1Rubiks1SENIORHIGH1StarWars1stationery1studyabroad1Swccyer1TaichungCont1Taipei1TFSHS69th3211THSRshare1TKU_Talk1Tobacco1toberich1Tour-Manager1TPC_Police1travel1TSU1TW-history1twin1Violation1WorkinChina1<< 收起看板(287)
首頁
上一頁
1
下一頁
尾頁
[算表] Excel取代問題
[ Office ]29 留言, 推噓總分: +8
作者: peiring - 發表於 2018/06/28 21:27(5年前)
7Fpeiring: 是3萬個不是5個06/29 04:50
12Fpeiring: 一樓的方法我試成功了,感謝06/29 07:53
13Fpeiring: 也謝謝其他大大提供意見,煩惱兩天的事終於解決了06/29 07:54
16Fpeiring: 貼圖沒辦法,全部都是客戶的個資,但我大概講一下,其實我是06/29 21:01
17Fpeiring: 要把客戶的個資去識別化,但我不能把其中幾個數字用XX取代06/29 21:02
18Fpeiring: 因為去識別化後,我必須還看得出來其中哪幾筆是同一位客戶06/29 21:02
19Fpeiring: 例如一個客戶帳號是12345,另一個是16785,傳統去識別化變06/29 21:03
20Fpeiring: 成兩個都是1XXX5,我會以為是同一個客戶,這樣不可以06/29 21:04
21Fpeiring: 一樓大大給了我靈感,把其中幾個數字用函數變成特定符號,06/29 21:05
22Fpeiring: 這樣既可以去識別化,我還能看得出來是不是同一個客戶06/29 21:06
24Fpeiring: 這樣有幫到你嗎? 可能跟你原本想的3萬個取代有點不一樣06/29 21:09
首頁
上一頁
1
下一頁
尾頁