Re: $$Excel-Macros$$ Formula required to find the highest & lowest values in each month

2010-12-29 Thread Rajesh K R
Hi Thank You Regards Rajesh Kainikkara On 12/27/10, Ms-Exl-Learner . wrote: > Hi, > > In addition to the above post I would like to remove the helper column and > we make the formula to do the work. > > Have a look in the attached file. > > --- > Ms.Exl.Learner > ---

Re: $$Excel-Macros$$ Formula required to find the highest & lowest values in each month

2010-12-27 Thread Ms-Exl-Learner .
Hi, In addition to the above post I would like to remove the helper column and we make the formula to do the work. Have a look in the attached file. --- Ms.Exl.Learner --- On Sun, Dec 26, 2010 at 6:29 PM, ashish koul wrote: > > check the attachment > On

Re: $$Excel-Macros$$ Formula required to find the highest & lowest values in each month

2010-12-26 Thread Rajesh K R
Hi Ashish Thank u very much, for ur fast & perfect answer Regards Rajesh Kainikkara On 12/26/10, ashish koul wrote: > check the attachment > On Sun, Dec 26, 2010 at 3:15 PM, Rajesh K R > wrote: > >> Hi experts >> >> Wish you happy new year >> >> I have worksheet like this >> Column A - Date >>

Re: $$Excel-Macros$$ Formula required to find the highest & lowest values in each month

2010-12-26 Thread ashish koul
check the attachment On Sun, Dec 26, 2010 at 3:15 PM, Rajesh K R wrote: > Hi experts > > Wish you happy new year > > I have worksheet like this > Column A - Date > Column B - Amt > Column C - Name of Month > Column D - For highest value of each month > Column E - For lowest value of each month > P

$$Excel-Macros$$ Formula required to find the highest & lowest values in each month

2010-12-26 Thread Rajesh K R
Hi experts Wish you happy new year I have worksheet like this Column A - Date Column B - Amt Column C - Name of Month Column D - For highest value of each month Column E - For lowest value of each month Pls check the attached file & tell me what is the formula for finding the highest & lowest val