Highest and Lowest of a series in Excel

  Clapton is God 09:54 30 Jul 2008
Locked

I have an Excel spreadsheet which tracks the daily share price of a particular company.

That price changes daily and is in a single column with each day's price in the next row/cell down.

Is there a formula I can use which will 'look' at all those prices and tell me the lowest price and the highest price at any time?

That is, I just need the formula in 2 cells - one cell to show the lowest price and another cell to show the highest price.

  spuds 09:57 30 Jul 2008

VoG's the person for the answer to this, but I haven't seen him around for some time now.Holidays perhaps!.

  Clapton is God 10:01 30 Jul 2008

I know that he's the Excel guru and, oddly enough, I answered a question from him about 3 or 4 days ago!

Quite happy to take answers from any other Excel experts, though. ;-))

  VoG II 10:02 30 Jul 2008

Assuming the prices are in column A then (NOT in column A !)

=MIN(A:A)

=MAX(A:A)

  Clapton is God 10:10 30 Jul 2008

Bloody hell, that was quick.

Works a treat!

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Best phone camera 2017

Stunning new film posters by Hattie Stewart, Joe Cruz & more

iPad Pro 10.5in (2017) review

28 astuces pour profiter au mieux de votre iPhone