Excel函數問題 - 證照
By Ula
at 2014-07-22T20:33
at 2014-07-22T20:33
Table of Contents
請問各位大大
下面的數值在同一欄裡,如何用excel函數將它選取出來
100194
100185
100189
200060
200059
100163
300080
300111
200079
分別要選出3開頭、2開頭及1開頭的最大和最小值?
是結合if及max和min函數嗎?
請問函數是怎麼寫?
--
下面的數值在同一欄裡,如何用excel函數將它選取出來
100194
100185
100189
200060
200059
100163
300080
300111
200079
分別要選出3開頭、2開頭及1開頭的最大和最小值?
是結合if及max和min函數嗎?
請問函數是怎麼寫?
--
Tags:
證照
All Comments
By Quanna
at 2014-07-27T14:00
at 2014-07-27T14:00
By Rebecca
at 2014-07-28T20:56
at 2014-07-28T20:56
By David
at 2014-07-29T11:43
at 2014-07-29T11:43
By Gilbert
at 2014-07-29T19:10
at 2014-07-29T19:10
By David
at 2014-07-31T11:05
at 2014-07-31T11:05
Related Posts
103年不動產經紀人 補習班選擇?
By Christine
at 2014-07-22T16:29
at 2014-07-22T16:29
101/3 證分 投資學 求解
By Connor
at 2014-07-22T14:35
at 2014-07-22T14:35
證券分析師 投資學 考題
By Callum
at 2014-07-22T11:14
at 2014-07-22T11:14
投信投顧+信託法 還不算有信託證照??
By Kelly
at 2014-07-21T23:34
at 2014-07-21T23:34
請問關於申請技師證書...
By Edith
at 2014-07-21T19:19
at 2014-07-21T19:19