Are you looking for 2 values, or just 1? In other words, are you looking for the highest value for the month of April and the separate highest value for the month of May? Or, are you looking for the single highest value for the 2 month period spanning April through May?
Mike --- In [email protected], "Steve_Almond" <m...@...> wrote: > > 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 >
