Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Trending News

Promoted
stevepitt2
Lv 6
stevepitt2 asked in Computers & InternetSoftware · 9 years ago

Microsoft Excell question --?

I have a list of stock holdings that I download the value most days. I would like a formula that would look at my total value and record that value if it is higher than the previous value. I am looking to record a high water mark, so to speak. Can someone help with this?

1 Answer

Relevance
  • Blackened
    Lv 6
    9 years ago
    Favorite Answer

    the MAX function seems like what you're looking for. So assuming your total values were in the C column, the formula would be:

    =MAX(C:C)

Still have questions? Get your answers by asking now.