[算表] EXCEL如何傳回最大值.
軟體:office 2000
excel
如何
在b欄中找出最大值.並傳回最大值 a欄的數值
感謝
標題不知怎麼表達 Orz
a b
.50000574e+003, 0.00000000e+000
1.68227661e+003, 8.04415834e-002
1.88241064e+003, 1.01663205e-001
1.97486816e+003, 1.27624541e-001
2.14785034e+003, 1.71972410e-001
2.30788745e+003, 2.19807445e-001
2.45751392e+003, 3.02172170e-001
2.59852783e+003, 3.63763530e-001
2.73227563e+003, 3.60178836e-001
2.85976514e+003, 2.82044864e-001
3.04098657e+003, 1.46988668e-001
3.15603442e+003, 1.06612900e-001
3.32113159e+003, 9.59787536e-002
3.47839014e+003, 8.09345792e-002
3.57940259e+003, 7.18598508e-002
3.77331128e+003, 6.80148811e-002
3.91244141e+003, 8.04295099e-002
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 220.130.241.106
→
12/18 14:28, , 1F
12/18 14:28, 1F
→
12/18 14:56, , 2F
12/18 14:56, 2F
推
12/18 14:59, , 3F
12/18 14:59, 3F
推
12/18 15:03, , 4F
12/18 15:03, 4F
→
12/18 15:04, , 5F
12/18 15:04, 5F
→
12/18 15:14, , 6F
12/18 15:14, 6F
→
12/18 16:13, , 7F
12/18 16:13, 7F
討論串 (同標題文章)
以下文章回應了本文 (最舊先):
完整討論串 (本文為第 1 之 3 篇):
Office 近期熱門文章
PTT數位生活區 即時熱門文章