作者查詢 / zxc321
作者 zxc321 在 PTT [ Office ] 看板的留言(推文), 共7則
限定看板:Office
看板排序:
全部Buzz_Act106Tennis82Baseball32CMWang24Olympics_ISG22NKFUST20DJ_Ken16basketballTW15trans_math15Dragons14MysticWiz11Adachi10Economics10Cobras9Finance9Gossiping9Militarylife9SportLottery9BB_Online7Emulator7HCKuo7Jacky7NTCUST7Office7TW-M-Tennis7Database6Whales6AdvEduUK5Billiard5MLB5TaichungCont5graduate4GraduateCram4Lifeismoney4TW-F-Tennis4TY_Research4Wei-Lun4CLHu3Golden-Award3HOT_Game3NBA_Film3NeedFood3Nuggets3NUU_Talk3tabletennis3TKU_EW94B3Angela2Army-Sir2BBSmovie2CYUT2Elephants2FCU-INS93B2FCU_Talk2FCUBA_93B2Flash2FLAT_CLUB2FORMULA12HCU2Japandrama2LoL2NBA2NCYU_BA_002NHSH13th3052NHUSH2NKUTEE2NTOU_TALK2PokeMon2San-Ying2SCU_JP_BASE2SCU_LawFB2Sharapova2studyteacher2TaiwanBank2TaiwanDrama2Tsao2TSH94_12UTAH-JAZZ2WorldCup2ALL-RUSSIANS1Anti-ramp1AQUA_SB1Argentina1ASIA-uni1Asian-MLB1AskBoard1BabyBears1BaseballNEWS1beauty_south1cafa1CEM991CHNA-SW1Chunichi1ck61st3301cksh83rd3141CMU_Talk1CPBL1CSMU-D961CSMU-HSA961CSMU-MT951CSMU-NT931CSU1CTS1CY-SPORT1CyberFormula1Dodgers1Drama-Ticket1e-coupon1Eagles1fastfood1FatMonkeys1FCU-PF20061FCU_EE97A1FCU_SB_CLUB1FengYuan1FISH-FRIEND1FJU-CH-2007B1FJU-Criminal1FJU-LS94b1FJU-MBA961FJU-Stat97A1FJUSociology1FongShan1Football1FTP1FubonBraves1Golf1GuardRookies1HCHS933141Hip-Hop1HisSoccer1HSNU_10661HSNU_11181HY-40-Xin1iOS1JapanMovie1joke1K_baseball1KG93-3241KMT1KNU1KS93-3161KS95-3181KSU1KUAS1Left_Village1Lions1lizen29-6051Lun-mei1Machi1Math1media-chaos1MiamiHeat1MP53-11N-E-W-S1NCCU_mathG961NCHUS1NCTU-STAT95G1NCTU-STAT96G1NCUECON961NCYU_DMI_991NDHU-His1001NeiHu7011NFU1NIU-ECE94b1NKMU1NKUHT1NTHU_STAT941NTIT_IMD921NTPU-CSIE931NTUHorti961NTUIAM-971NYUST98_FING1PeopleSeries1PH-sea1PHAT-MEN1Philharmonic1PlayBaseball1Raptors1Rockets1rosachien1RSPS85-6101RSSH94_3011S_B_D_W1SCU_ACC_96A1share1SlamDunk1Soci_Volley1Sodagreen1Softball1Spain_PL1SportsCard1STU1StupidClown1TaichungBun1TaiwanDa1TANK1THU_Talk1TKU-Baseball1TKU_IHM1TOEIC1ToS1Transfer1weiyin1YAKYU1Yakyu_spirit1YCChen1YCSH_3_3141YP95-3111<< 收起看板(208)
首頁
上一頁
1
下一頁
尾頁
2F→:請問S大,若是我的A欄資料有1682筆,B欄1692筆,那A欄與B欄04/04 00:43
3F→:改絕對位置後,後面row也改成至1682,按ctrl+shift+enter04/04 00:44
4F→:後,仍沒有發生任何事,請問這是為什麼呢? 謝謝~04/04 00:44
5F→:=IFERROR(INDIRECT("A"&SMALL(IF(COUNTIF($B$2:$B$1692,$A$204/04 00:54
6F→::$A$1682)=0,ROW($2:$1682)),ROW()-1)),"") 以上為在C2欄位04/04 00:54
7F→:的函數,不知是否有錯誤?~04/04 00:55
8F→:不好意思 我找到我的問題了 謝謝S大的解答 感恩~04/04 01:48
首頁
上一頁
1
下一頁
尾頁