Can anyone help?Please
我有2colum數值(say A1 to A10, B1 to B10)
I want max value (only one value) of (B1減A1, B2減B2......)
How to set the formula?
Thanks
Excel (max) formula
2011-10-23 7:06 am
回答 (3)
2011-10-23 11:27 am
✔ 最佳答案
=MAX(A1:A10-B1:B10)輸入後, 先按 ctrl+Shift 兩鍵不放, 然後再按 enter
2011-10-24 14:07:32 補充：
午夜夢迴，身心仍處於渾沌之際，連題目亦看錯了。謝謝 kh 指正。至於有否普通公式能達成樓主之要求，由於我對 Excel 的學習仍處於初階，恕未能提供。
2011-10-25 8:44 pm
You may use the following formula:
=MAX(B1:B10-$A$1:$A$10)
and then press CTRL+Shift+ENTER
and then copy this formula to other columns.
=MAX(B1:B10-$A$1:$A$10)
and then press CTRL+Shift+ENTER
and then copy this formula to other columns.
2011-10-24 5:21 am
TO : bb
答案A和B應對調
=MAX(B1:B10-A1:A10)
ctrl+Shift+enter
請教如不想用ctrl+Shift+enter，有冇公式可提供？
2011-10-23 23:53:36 補充：
each one 減 colunm A
=MAX(B1:B10-$A1:$A10)
ctrl+Shift+enter
答案A和B應對調
=MAX(B1:B10-A1:A10)
ctrl+Shift+enter
請教如不想用ctrl+Shift+enter，有冇公式可提供？
2011-10-23 23:53:36 補充：
each one 減 colunm A
=MAX(B1:B10-$A1:$A10)
ctrl+Shift+enter
收錄日期: 2021-04-13 18:18:44
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20111022000051KK01018