=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 amartak...@gmail.com wrote:
Hi All Champs
I will Request all anyone suggest me unique value from same month (formula)
Regards
Amar
--
Join official Facebook
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 amartak...@gmail.com wrote:
Hi All Champs
I will Request all anyone suggest me unique value from same month (formula)
Regards
Amar
--
Thanks Very much Ashish Sir Excel user group
On Wed, Dec 12, 2012 at 12:00 AM, Ms Excel user msexcelu...@gmail.comwrote:
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
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