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

iMac Pro review

Illustrator Charles Williams on how to create magazines and book covers

iMac Pro review

Les meilleures prises CPL (2018)