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?

Blackened2012-05-06T04:51:00Z

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)