Highest and Lowest of a series in Excel

  Clapton is God 09:54 30 Jul 08
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 08

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 08

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 08

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 08

Bloody hell, that was quick.

Works a treat!

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

Sniper Elite 4 review: Headshotting Nazis has never felt so good

1995-2015: How technology has changed the world in 20 years

The Best Design, Illustration, Animation and VFX Awards of 2017

WWDC 2017 dates: How to get WWDC 2017 tickets, when is WWDC 2017 and more details announced