作者查詢 / kzadb

總覽項目: 發文 | 留言 | 暱稱
作者 kzadb 在 PTT [ Office ] 看板的留言(推文), 共8則
限定看板:Office
看板排序:
全部NBA1198MuscleBeach654tennis_life607ToS514Gossiping360Headphone345swim237Little-Games204Tennis200Jeremy_Lin196sex174MobileComm154Palmar_Drama117FinalFantasy89Road_Running86studyteacher71Baki60Rockets51Teacher48Education39car38E-appliance36FITNESS36Lakers35BigBanciao31Suckcomic29SuperBike28JOJO24ONE_PIECE23Digitalhome18feminine_sex15Gintama14NBA_Film14Old-Games13TOEFL_iBT12Football11Hornets10EngTalk9JD_Lover9basketballTW8BLEACH8HOT_Game8Office8Wizards8EthnosSport6UTAH-JAZZ6Android5biker5PublicIssue5Sub_GMobile5Badminton4Hate4iOS4NARUTO4Windows4ASHS-95RN3BikerShop3BLAZERS3ChicagoBulls3Crusaders3DIABLO3EatToDie3FuMouDiscuss3GRE3Grizzlies3hair_loss3Ironman3Militarylife3NBAEasyChat3PushDoll3TA_AN3BAHAMUT2Baseball2CarShop2Cavaliers2CCRomance2DC2DPP2Employee2HatePolitics2Hawks2HSNU_8202I.O.I2Kings2Knicks2LaClippers2Lottery2MartialArts2mobile-game2mobilesales2Olympics_ISG2pesoftball2Web_Design2AfterPhD1AllTogether1Alternative1AntiVirus1ArakawaCow1ASIA-uni1Audiophile1AudioPlayer1basketball1BeautyBody1Boy-Girl1Bunco1C_Chat1Christianity1cksh77th3231cksh79th011cksh81st3211Comic1cookclub1CSMU-D881CSMU-MTennis1CTSH91-3021CYUT1DC_SALE1DSLR1DummyHistory1DYU1Examination1FCU_EE97A1FFF1FJU1friends1FTV1G-S-WARRIORS1GetMarry1HatePicket1Health_Life1HoneyClover1Hunter1JackLee1joke1KINGDOM1KingdomHuang1KS98-3021KUAS_5890311marriage1Mavericks1MiamiHeat1MOD1nCoV20191NCUECON961Notebook1NTUBIME-1021Nuggets1NUK_AC981PACERS1PHX-Suns1pighead1PublicServan1Raptors1Salary1Sixers1specialman1Steam1Stock1STREET_BALL1study1STUST1tabletennis1TFSHS61st3211TigerBlue1TKU_IHM1ToS_Match1YZU_CN99A1<< 收起看板(167)
首頁
上一頁
1
下一頁
尾頁
[問題] 數字顯示成特定文字(三個條件)
[ Office ]5 留言, 推噓總分: 0
作者: kzadb - 發表於 2012/02/25 16:27(12年前)
3Fkzadb:樓上像這個狀況要怎麼設?02/25 16:38
4Fkzadb:=IF(A1>98,"特","")&IF(A1>95,"優","")02/25 16:44
[問題] 同一列中名詞出現的次數 用countif
[ Office ]3 留言, 推噓總分: +1
作者: kzadb - 發表於 2012/02/25 09:30(12年前)
3Fkzadb:yes剛剛翻書找到 是countif沒錯02/25 14:03
[算表] 全體成績中算各組組內的名次
[ Office ]9 留言, 推噓總分: +2
作者: kzadb - 發表於 2010/11/12 08:52(13年前)
2Fkzadb:算出來有一些會等於0耶,這是?11/12 09:17
4Fkzadb:我有改11/12 09:47
5Fkzadb:要隨著組別不同改唷....?11/12 09:50
7Fkzadb:我發現...同分會往下降一名耶,也就是原本應並列第9,會顯示11/12 13:03
8Fkzadb:並列第1011/12 13:03
首頁
上一頁
1
下一頁
尾頁