public marks

PUBLIC MARKS with tag Excel_Learning

February 2007

EditGrid - 永恆的總和

by sanoss
=sum(indirect("R2C:R[-1]C",FALSE))

EditGrid - 資料驗證 ( 二 )

by sanoss
=if(E6="","",indirect(E6)*F6) ----- EditGrid 無 indirect 函數功能

EditGrid - 資料驗證 ( 一 )

by sanoss
用 Microsoft Excel 內置資料驗證功能

EditGrid - 排名次

by sanoss
=countif(B$12:B$16,">"&B13)+1

EditGrid - 項目編號

by sanoss
=count(indirect("R4C:R[-1]C",FALSE))+1

EditGrid - 多種語言

by sanoss
=choose(語言,"Sales","營業收入","营业收入")

June 2006

PUBLIC TAGS related to tag Excel_Learning

5***** +   sanoss +  

Active users

sanoss
last mark : 20/02/2007 14:46