Re: $$Excel-Macros$$ Request for formula:Unique value from same month

Thanks Very much Ashish Sir & Excel user group On Wed, Dec 12, 2012 at 12:00 AM, Ms Excel user wrote: > Hi Amar, > > Try this array formula > =INDEX($F$7:$F$27,MATCH(MONTH(H8),MONTH($E$7:$E$27),0)) > > > > > > On Tue, Dec 11, 2012 at 1:13 PM, amar takale wrote: > >> Hi All Champs >

Re: $$Excel-Macros$$ Request for formula:Unique value from same month

Hi Amar, Try this array formula =INDEX($F$7:$F$27,MATCH(MONTH(H8),MONTH($E$7:$E$27),0)) On Tue, Dec 11, 2012 at 1:13 PM, amar takale wrote: > Hi All Champs > > I will Request all anyone suggest me unique value from same month (formula) > > Regards > Amar > > > -- > Join offic

Re: $$Excel-Macros$$ Request for formula:Unique value from same month

=MAX(IF(MONTH($E$7:$E$27)=MONTH(H8),$F$7:$F$27,"")) press + ctlr + shift+ enter On Tue, Dec 11, 2012 at 1:13 PM, amar takale wrote: > Hi All Champs > > I will Request all anyone suggest me unique value from same month (formula) > > Regards > Amar > > > -- > Join official Facebook page of thi

$$Excel-Macros$$ Request for formula:Unique value from same month

Hi All Champs I will Request all anyone suggest me unique value from same month (formula) Regards Amar -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need