Public marks with tag Excel_Learning Public marks with tag Excel_Learning http://blogmarks.net/marks/tag/Excel_Learning EditGrid - 永恆的總和 http://www.editgrid.com/user/sanoss/%E6%B0%B8%E6%81%86%E7%9A%84%E7%B8%BD%E5%92%8C =sum(indirect("R2C:R[-1]C",FALSE)) 2007-02-20T14:46:42Z sanoss Excel_Learning, 5*****

EditGrid - 永恆的總和

by sanoss

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

Copy | React (0)
]]> EditGrid - 稽核工具列 http://www.editgrid.com/user/sanoss/%E7%A8%BD%E6%A0%B8%E5%B7%A5%E5%85%B7%E5%88%97 2007-02-20T14:45:34Z sanoss Excel_Learning

EditGrid - 稽核工具列

by sanoss

Copy | React (0)
]]> EditGrid - 資料驗證 ( 二 ) http://www.editgrid.com/user/sanoss/%E8%B3%87%E6%96%99%E9%A9%97%E8%AD%89%EF%BC%88%E4%BA%8C%EF%BC%89 =if(E6="","",indirect(E6)*F6) ----- EditGrid 無 indirect 函數功能 2007-02-20T14:41:50Z sanoss Excel_Learning

EditGrid - 資料驗證 ( 二 )

by sanoss

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

Copy | React (0)
]]> EditGrid - 資料驗證 ( 一 ) http://www.editgrid.com/user/sanoss/%E8%B3%87%E6%96%99%E9%A9%97%E8%AD%89%EF%BC%88%E4%B8%80%EF%BC%89 用 Microsoft Excel 內置資料驗證功能 2007-02-20T14:39:57Z sanoss Excel_Learning

EditGrid - 資料驗證 ( 一 )

by sanoss

用 Microsoft Excel 內置資料驗證功能

Copy | React (0)
]]> EditGrid - 數字格式 http://www.editgrid.com/user/sanoss/%E6%95%B8%E5%AD%97%E6%A0%BC%E5%BC%8F 2007-02-20T14:37:54Z sanoss Excel_Learning, 5*****

EditGrid - 數字格式

by sanoss

Copy | React (0)
]]> EditGrid - 自動填滿的威力 http://www.editgrid.com/user/sanoss/%E8%87%AA%E5%8B%95%E5%A1%AB%E6%BB%BF%E7%9A%84%E5%A8%81%E5%8A%9B 2007-02-20T14:37:05Z sanoss Excel_Learning

EditGrid - 自動填滿的威力

by sanoss

Copy | React (0)
]]> EditGrid - 活用數字格式 http://www.editgrid.com/user/sanoss/%E6%B4%BB%E7%94%A8%E6%95%B8%E5%AD%97%E6%A0%BC%E5%BC%8F 2007-02-20T14:35:42Z sanoss Excel_Learning

EditGrid - 活用數字格式

by sanoss

Copy | React (0)
]]> EditGrid - 排名次 http://www.editgrid.com/user/sanoss/%E6%8E%92%E5%90%8D%E6%AC%A1 =countif(B$12:B$16,">"&B13)+1 2007-02-20T14:31:21Z sanoss Excel_Learning

EditGrid - 排名次

by sanoss

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

Copy | React (0)
]]> EditGrid - 項目編號 http://www.editgrid.com/user/sanoss/%E9%A0%85%E7%9B%AE%E7%B7%A8%E8%99%9F =count(indirect("R4C:R[-1]C",FALSE))+1 2007-02-20T14:30:06Z sanoss Excel_Learning

EditGrid - 項目編號

by sanoss

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

Copy | React (0)
]]> EditGrid - 人口金字塔 http://www.editgrid.com/user/sanoss/%E4%BA%BA%E5%8F%A3%E9%87%91%E5%AD%97%E5%A1%94 注意圖二的畫法 2007-02-20T14:28:30Z sanoss Excel_Learning

EditGrid - 人口金字塔

by sanoss

注意圖二的畫法

Copy | React (0)
]]> EditGrid - 多種語言 http://www.editgrid.com/user/sanoss/%E5%A4%9A%E7%A8%AE%E8%AA%9E%E8%A8%80 =choose(語言,"Sales","營業收入","营业收入") 2007-02-20T14:26:48Z sanoss Excel_Learning

EditGrid - 多種語言

by sanoss

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

Copy | React (0)
]]> EditGrid - 陣列公式 http://www.editgrid.com/user/sanoss/%E9%99%A3%E5%88%97%E5%85%AC%E5%BC%8F 2007-02-20T14:24:58Z sanoss Excel_Learning

EditGrid - 陣列公式

by sanoss

Copy | React (0)
]]> EditGrid - 二次方程式 http://www.editgrid.com/user/sanoss/%E4%BA%8C%E6%AC%A1%E6%96%B9%E7%A8%8B%E5%BC%8F =linest(A4:A13,B4:C13) 2007-02-20T14:22:57Z sanoss Excel_Learning

EditGrid - 二次方程式

by sanoss

=linest(A4:A13,B4:C13)

Copy | React (0)
]]> EditGrid - 陣列的轉置 ( TRANSPOSE ) http://www.editgrid.com/user/sanoss/%E9%99%A3%E5%88%97%E7%9A%84%E8%BD%89%E7%BD%AE%EF%BC%88TRANSPOSE%EF%BC%89 2007-02-20T14:21:56Z sanoss Excel_Learning

EditGrid - 陣列的轉置 ( TRANSPOSE )

by sanoss

Copy | React (0)
]]> EditGrid - 假期的統計 http://www.editgrid.com/user/sanoss/%E5%81%87%E6%9C%9F%E7%9A%84%E7%B5%B1%E8%A8%88 2007-02-20T14:20:03Z sanoss Excel_Learning

EditGrid - 假期的統計

by sanoss

Copy | React (0)
]]> EditGrid - 文字輸入格式 http://www.editgrid.com/user/sanoss/%E6%96%87%E5%AD%97%E8%BC%B8%E5%85%A5%E6%A0%BC%E5%BC%8F 2007-02-20T14:19:23Z sanoss Excel_Learning

EditGrid - 文字輸入格式

by sanoss

Copy | React (0)
]]> EditGrid - 股票價格 (香港) http://www.editgrid.com/user/sanoss/%E8%82%A1%E7%A5%A8%E5%83%B9%E6%A0%BC%EF%BC%88%E9%A6%99%E6%B8%AF%EF%BC%89 2007-02-20T14:18:32Z sanoss Excel_Learning

EditGrid - 股票價格 (香港)

by sanoss

Copy | React (0)
]]> EditGrid - 把資料放在網頁上 http://www.editgrid.com/user/sanoss/%E6%8A%8A%E8%B3%87%E6%96%99%E6%94%BE%E5%9C%A8%E7%B6%B2%E9%A0%81%E4%B8%8A 2007-02-20T14:17:29Z sanoss Excel_Learning

EditGrid - 把資料放在網頁上

by sanoss

Copy | React (0)
]]> EditGrid - 彩券結果 : 六合彩 http://www.editgrid.com/user/sanoss/%E5%BD%A9%E5%88%B8%E7%B5%90%E6%9E%9C%EF%BC%9A%E5%85%AD%E5%90%88%E5%BD%A9 2007-02-20T14:11:47Z sanoss Excel_Learning

EditGrid - 彩券結果 : 六合彩

by sanoss

Copy | React (0)
]]> EditGrid - 從數字到文字 http://www.editgrid.com/user/sanoss/%E5%BE%9E%E6%95%B8%E5%AD%97%E5%88%B0%E6%96%87%E5%AD%97 2007-02-20T14:09:48Z sanoss Excel_Learning

EditGrid - 從數字到文字

by sanoss

Copy | React (0)
]]> EditGrid - Break Even Point (Excel) http://www.editgrid.com/user/sanoss/Break_Even_Point 2007-02-20T14:01:14Z sanoss Excel_Learning

EditGrid - Break Even Point (Excel)

by sanoss

Copy | React (0)
]]> Excel ~ 永恆的總和 http://www.excelhelp.net/cgi-bin/forum/topic.cgi?forum=2&topic=3&show=0 2006-06-26T03:03:01Z sanoss Excel_Learning

Excel ~ 永恆的總和

by sanoss

Copy | React (0)
]]>