Highest and Lowest of a series in Excel

  Clapton is God 09:54 30 Jul 2008

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 !)



  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

Nokia 8 vs Galaxy S8

How artist Alex Yanes worked with his daughter on this bright 3D mural for Monument Valley 2

iMac 21.5-inch (2017) review

Comment regarder le lancement du Galaxy Note 8 en direct ?