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!!

 

[Marcílio_Lobão]

Vally88, Good afternoon.

Are you finishing this formula with CTRL + SHIF + ENTER ?

 

[Vally 88]

Vally88, Good afternoon.

Are you finishing this formula with CTRL + SHIF + ENTER ?

Hey Marcilio
yes as an array formula but it keeps not working, I have tried to do the same with max but again same result

 

[Marcílio_Lobão]

Vally88,

I tested the formula and it's working perfectly.

As your result is 00/01/1900 it means that the real answer is ZERO. Nothing found.

Are you sure that in this range of data there is a valid answer?

All your DATES are real dates? Nothing is TEXT and not date?

 

[Vally 88]

Vally88,

I tested the formula and it's working perfectly.

As your result is 00/01/1900 it means that the real answer is ZERO. Nothing found.



Are you sure that in this range of data there is a valid answer?

All your DATES are real dates? Nothing is TEXT and not date?

Yes all formatted in date and I don't have any 0 in there, I'm bumping my head to the wall. So Formula should be correct but in my column date is formatted as a date. Is it possible that the issue is that in column S so my column condition my condition is TRUE in multiple rows?
What do you think?

thank you!

 

[Marcílio_Lobão]

Vally88,

If I'm not wrong your colunm S must have a lot of TRUE cell conditions found to create a list to search for a MIN.

Sorry, but I insist on the question.

Do you have at least one real example that should appear in the answer?

Save your file at a free site, www.sendspace.com and put a link to download here.

This way it will be easier to help you in a conclusive way.

 

[Vally 88]

Vally88,

If I'm not wrong your colunm S must have a lot of TRUE cell conditions found to create a list to search for a MIN.

Sorry, but I insist on the question.

Do you have at least one real example that should appear in the answer?

Save your file at a free site, www.sendspace.com and put a link to download here.

This way it will be easier to help you in a conclusive way.

Sorry tired and I said wrongly I was meaning that in the date column C I have multiple date for the same day. Is it possible that this confuses the arrow?

thanks,

Valeria

 

[Marcelo Branco]

Yes all formatted in date and I don't have any 0 in there?

Formatting a column as Date is not enough to ensure that the values are real dates (numbers).
Check - in an empty column try
=ISNUMBER(C1)
copy down

Tell us the results

M.

 

[Marcílio_Lobão]

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

 

[Vally 88]

Formatting a column as Date is not enough to ensure that the values are real dates (numbers).
Check - in an empty column try
=ISNUMBER(C1)
copy down

Tell us the results

M.

Hello Marcelo, yes everything is number confirmed by the formula.
thanks for this