Re: $$Excel-Macros$$ Re: All time high Price *

thanks Prince, Effort appreciated On Mon, Sep 24, 2012 at 10:10 AM, Prince Dubey wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (prince141...@gmail.com) Add cleanup > rule

$$Excel-Macros$$ Re: All time high Price

Hi Hilary please use this formula hope this will helpe u. =MAX(INDEX('Monthly End Prices'!C2:AK169,,MATCH(Sheet2!B1,'Monthly End Prices'!C1:AK1,0))) Regards Prince dueby On Thursday, September 20, 2012 9:28:51 PM UTC+5:30, hilary lomotey wrote: > > Hello Experts, > > i need a formula to cal