[算表] 求第二大的數字

看板Office作者 (內湖信義永和人)時間17年前 (2009/04/15 21:17), 編輯推噓1(101)
留言2則, 2人參與, 最新討論串1/1
軟體: EXCEL 版本: 2003 一串數字中 A1~Z1 =max(a1:z1)可以找出最大的數字 我想找A1~Z1中 第二大 的數字 該怎麼寫公式呢 -- Do you like Germany Ya!I like Germany.... but not Germany. I Like German History. Very strong will, Very deligent people....... (in a word)The Great Germany(Das Gross Deutschland) I don't Like the American one, the American one no good, They Pretend,(We're justice,peace,democracy......) -- ※ 發信站: 批踢踢實業坊(ptt.cc) ◆ From: 123.194.135.134

04/15 21:29, , 1F
=large(A1:Z1,2)
04/15 21:29, 1F

04/15 21:45, , 2F
感謝
04/15 21:45, 2F
文章代碼(AID): #19vTvCyC (Office)
文章代碼(AID): #19vTvCyC (Office)