MIN and IF functions return no value if there is no date

[roniaelm]

Hello,

I am using this array formula to give me the smallest date if two
ciretira are matched.
It works really well, but for some reason if there is no date in the
list it returns the 00-Jan-00 value.
Is there a way that it does not return any values at all and the cell
remains empty?

=MIN(IF(H9:$H20=B5,IF(I9:I20=B9,Timesheet!G9:G20,"")))

Thanks!

 

[T. Valko]

Try this (array entered):

=IF(SUM((H9:H20=B5)*(I9:I20=B9)),MIN(IF((H9:$H20=B5)*(I9:I20=B9),Timesheet!G9:G20)),"")

 

[roniaelm]

Try this (array entered):

=IF(SUM((H9:H20=B5)*(I9:I20=B9)),MIN(IF((H9:$H20=B5)*(I9:I20=B9),Timesheet!­G9:G20)),"")

--
Biff
Microsoft Excel MVP







- Show quoted text -

Hi Biff,

Thanks for this formula, does this work if my values in B5 and B9 are
actually text?
I have managed to make it work yet?

Thanks again.

 

[roniaelm]

Hi Biff,

Thanks for this formula, does this work if my values in B5 and B9 are
actually text?
I have managed to make it work yet?

Thanks again.- Hide quoted text -

- Show quoted text -

Hi Biff,

Ignore my question!
I got it to work!
Thanks for your help!

 

[T. Valko]

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP

Hi Biff,

Thanks for this formula, does this work if my values in B5 and B9 are
actually text?
I have managed to make it work yet?

Thanks again.- Hide quoted text -

- Show quoted text -

Hi Biff,

Ignore my question!
I got it to work!
Thanks for your help!