前幾天在教 Excel函數時，發現 Match函數的功能常常會讓人困擾，有些人還會將 Match函數和 Vlookup函數搞混。
使用的範例資料來源是 Excel 裡對於函數 Match 的說明。
Function，所謂的自訂函數。
在Function裡寫入自己想要的功能，而後在工作表(Sheet)裡就能自由運用該函數。
接下來的範例，在Function裡寫入可以抓取該模組(Module)裡全域變數的相關程式碼，就可以在工作表(Sheet)裡使用。
在Function裡寫入自己想要的功能，而後在工作表(Sheet)裡就能自由運用該函數。
接下來的範例，在Function裡寫入可以抓取該模組(Module)裡全域變數的相關程式碼，就可以在工作表(Sheet)裡使用。
Synergy 是一個可以把鍵盤&滑鼠 分享到網絡的東東, 對於我有多台電腦的人 真的很方便.
以下是下載網址
http://synergy-foss.org/zh-tw/
設定方面也沒有有煩, 只是一台電腦開 Server mode 然後把其他電腦加入到 Screen 些定位置就可以了
在我的設定中 一台放左邊 中間是主機 右邊是Mac, 開啟後 就可以主機的鍵盤&滑鼠 在三台電腦之間跑來跑去, 而且 copy & paste 之類也support :p
以下是下載網址
http://synergy-foss.org/zh-tw/
設定方面也沒有有煩, 只是一台電腦開 Server mode 然後把其他電腦加入到 Screen 些定位置就可以了
在我的設定中 一台放左邊 中間是主機 右邊是Mac, 開啟後 就可以主機的鍵盤&滑鼠 在三台電腦之間跑來跑去, 而且 copy & paste 之類也support :p
Cause of work, i has long time didn't update this blog.
In last week, i need to install an project management system redmine. redmine develop in ruby on rails, so i try to install ruby on rails in ubuntu server.
Please follow below step use root account.
1. Install curl.
apt-get install curl
2. Install RVM with ruby.
\curl -L https://get.rvm.io | bash -s stable --ruby
RVM is a command-line tool which allows you to easily install, manage, and work with multiple ruby environments from interpreters to sets of gems.
3. Load rvm source
source [path your install rvm]/rvm
4. Install dependancies
rvm requirements
after this command, will showing the dependeices package you need to install
5. Install Ruby 1.9.3
rvm install 1.9.3
6. Set defualt ruby version
rvm use 1.9.3 --default
7. Install RubyGems
rvm rubygems current
RubyGems is a package manager for the Ruby programming language that provides a standard format for distributing Ruby programs and libraries (in a self-contained format called a "gem").
8. Install Rails
rvm 1.9.3 do gem install rails
When finish all step, now we can start develop our ror projects.
In last week, i need to install an project management system redmine. redmine develop in ruby on rails, so i try to install ruby on rails in ubuntu server.
Please follow below step use root account.
1. Install curl.
apt-get install curl
2. Install RVM with ruby.
\curl -L https://get.rvm.io | bash -s stable --ruby
RVM is a command-line tool which allows you to easily install, manage, and work with multiple ruby environments from interpreters to sets of gems.
3. Load rvm source
source [path your install rvm]/rvm
4. Install dependancies
rvm requirements
after this command, will showing the dependeices package you need to install
5. Install Ruby 1.9.3
rvm install 1.9.3
6. Set defualt ruby version
rvm use 1.9.3 --default
7. Install RubyGems
rvm rubygems current
RubyGems is a package manager for the Ruby programming language that provides a standard format for distributing Ruby programs and libraries (in a self-contained format called a "gem").
8. Install Rails
rvm 1.9.3 do gem install rails
When finish all step, now we can start develop our ror projects.
台北今天天氣很好，於是乎我決定出門遊玩 =///=
最近在教Excel時，被問說要怎麼抓到最新的價格呢？要用VBA嗎？其實不用，用一個函數搭配定義範圍名稱就可以解決唷!!
