Find the minimum value based on the month

[madhusha92]

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

[canapone]

Hi,

in column A are dates

Please Login or Register  to view this content.

to be confirmed with control+shift +enter and copied down


or if in column A there are texts ("JAN", "FEB"...)

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Again confirmed with control+shift+enter

Hope it helps

[madhusha92]

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

[canapone]

Hi,

an attempt, in C2 and down:

Please Login or Register  to view this content.

to be confirmed with control+shift+enter


Regards