作者查詢 / iicash
作者 iicash 在 PTT [ Office ] 看板的留言(推文), 共7則
限定看板:Office
看板排序:
全部FCK-GARDEN25CCUfinGrad9521StupidClown14Office7Songs7BBSmovie6CoC6Finance4Road_Running4StarCraft4Tainan4Excalibur3Stock3Accounting2Actuary2asciiart2BuRuRadio2e-coupon2joke2KS94-3072License2LoL2NCHU-AGR022TA_AN2TaichungBun2Army-Sir1bicycle1book1BuyTogether1CareerPlan1cjjhs3271CPU_FC7111Create1CSMU-AFL1dance1Eng-Class1eSports1Facebook1FCK-FISH1FJU-ACCR941FJU-EE-2005B1FJU_OT2nd1FuHo14th3431FXM91-3291graduate1ILSH-953131ISU_CS_93A1KS92-3101KS94-3091KS94-3121KS98-3021Kusan_89-3121MakeUp1NBA1NBA_Film1NCCU05_CHI1NCHU-AGR001NCUFingrad041NDHU-MSE921NDMC-PH231NEHS19th41NIUECE911NTHU-MSE091NTPU-STAT931NTUdent891NTUE-CS981NTUEOE_R306A1Palmar_Drama1Salary1sex1shoes1TTU-I90B1USC1Viator96Gang1viatording971Yup01-041<< 收起看板(76)
首頁
上一頁
1
下一頁
尾頁
1F推: INDIRECT(A2&"!C2")02/04 15:41
1F推: googlge:Excel-向下填滿空白儲存格 試試看是不是你要的?09/02 00:20
3F推: OFFSET(Sheet1!$C$2,(ROW(B2)-2)*4+MOD(COLUMN(B$2),4),0)08/21 09:05
4F推: =OFFSET(Sheet1!$C$2,(ROW(B2)-2)*4+COLUMN(B2)-2,0)08/21 09:11
5F→: 多了MOD,用列數*4+欄數位移就好囉...08/21 09:12
3F推:=COUNTIF(A$1:A1,A1)01/02 22:15
3F推:google~~~ 想到啥查啥~~02/19 20:59
首頁
上一頁
1
下一頁
尾頁