close

Hi there

I have a large spreadsheet that contains two columns of data. Does anyone
know a formula that will look down each column (A amp; B) and return the highest
found value into cell C1.

Thanks in advance!

=MAX(A:B)

or

=MAX(A1:B999)

HTH
--
AP

quot;JaBquot; gt; a écrit dans le message de news:
...
gt; Hi there
gt;
gt; I have a large spreadsheet that contains two columns of data. Does anyone
gt; know a formula that will look down each column (A amp; B) and return the
gt; highest
gt; found value into cell C1.
gt;
gt; Thanks in advance!

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄