I want to find the highest closing price for a stock in the last month and the one before that (say highest for May and for April). I thought I could use something like:
HHV(C,Ref(Month(),-1)) but it seems only to return a recent high value. Can someone point me in the right direction? Thanks, Steve
