Min Value with condition

[Vally 88]

Hi guys I'm trying to get the min date in column C if column S has a certain criteria in F.
So now I'm using as an array the below formula:

=MIN(IF('Overall Data'!$S:$S=Help!$F$2,'Overall Data'!$C$1:$C$11116))

Unfortunately it gives me back 00/01/1900 despite I don't have any 0 in the date column, anyone any idea why this is happening and how to solve it?

Many thanks as usual!!

 

[Vally 88]

Vally88,

The ideal one to help you would be that we can see your file but as apparently this will not be possible follow an example that I made for you.

Take a look and let us know if that's how your data is.

I hope it helps.

https://www.sendspace.com/file/kjdwd3

Hi Marcilio,

thanks for this not really willing to share my credit card details to sign up in this website. is there anyway I can share the sample file with you?

thanks

 

[Vally 88]

Hey guys just to share this is solved!

The root cause of the problem was that the formula in S returns "6.17 " formatted as text, with a training space. so I get rid of the trailing space modifying the formula in S to:

=IFERROR(TRIM(MID(E2,FIND(".17 ",E2)-1,5))+0,0)

and then I used the array formula:

=MIN(IF('overall data'!$S$2:$S$12000=help!$F$2,'overall data'!$C$2:$C$12000))

thanks everyone!!