Cells A4 through A203 contain closing prices for stocks.
MAX(A4:A203) will give me the highest price.
Starting at A4, how do I find out in what cell this “high price” first occurred?
Hallo
=MATCH(MAX(A4:A203);A4:A203;0) returns the numeric index from that range, but isolated it seems useless - probably you want in real something like:
=VLOOKUP(MAX(A4:A203);A4:M203 ; 3 ; 0 )
which returns for Example the corresponding entry out of Column C ( 3rd Column counted from A )
Thanks!
That solves it. It give me the number of days ago the highest price was reached!