I want the minimum value based on the Month for Eg:
Month RF
Jan 5
Jan 3
Jan 2
Feb 4
Feb 1
Feb 0
Mar 1
Mar 5
Apr 9
Apr 8
Answer should be next column like this in corresponding row
2
1
1
8
pls do the needful
Hi,
in column A are dates
to be confirmed with control+shift +enter and copied down=min(if(month($A$2:$A$1000)=Row(A1),$B$2:$B$1000))
or if in column A there are texts ("JAN", "FEB"...)
=min(if(month($A$2:$A$1000)="Jan",$B$2:$B$1000))
=min(if(month($A$1:$A$1000)="Feb",$B$1:$B$1000))
Again confirmed with control+shift+enter
Hope it helps
Last edited by CANAPONE; 02-01-2012 at 05:11 AM. Reason: just wrapped with [code]
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon below the post.
Please, mark your thread [SOLVED] if you received your answer.
Forum rules: http://www.excelforum.com/forum-rule...rum-rules.html
This formula is working
=min(if(month($A$2:$A$1000)=Row(A1),$B$2:$B$1000))
but the answer is coming like
2
1
1
8
but i want
Jan 5
Jan 3
Jan 2 2
Feb 4
Feb 1
Feb 0 0
Mar 1 1
Mar 5
Apr 9
Apr 8 8
like this i want
and one more thing this formula is not working =min(if(month($A$2:$A$1000)="Jan",$B$2:$B$1000))
thank you
Hi,
an attempt, in C2 and down:
to be confirmed with control+shift+enter=if(b2=min(if(month($A$2:$A$1000)=Row(A1),$B$2:$B$1000)),b2,"")
Regards
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon below the post.
Please, mark your thread [SOLVED] if you received your answer.
Forum rules: http://www.excelforum.com/forum-rule...rum-rules.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks