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.
VoG's the person for the answer to this, but I haven't seen him around for some time now.Holidays perhaps!.
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. ;-))
Assuming the prices are in column A then (NOT in column A !)=MIN(A:A)=MAX(A:A)
Bloody hell, that was quick.Works a treat!
This thread is now locked and can not be replied to.
iMac Pro review
Illustrator Charles Williams on how to create magazines and book covers
Les meilleures prises CPL (2018)
© Copyright 2018 IDG UK. All Rights Reserved.