Mike, I'm looking for several individual values:
1. the highest for June 2. the highest for May 3. the highest for April That would be 3 values in all. Steve --- In [email protected], "Mike" <sfclimb...@...> wrote: > > 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" <me@> 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 > > >
