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

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!

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

Try this (array entered):

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

--
Biff
Microsoft Excel MVP


wrote in message
...
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!

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

On Apr 25, 11:46*am, "T. Valko" wrote:
Try this (array entered):

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

--
Biff
Microsoft Excel MVP

wrote in message

...



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!- Hide quoted text -

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

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

On Apr 25, 12:02*pm, wrote:
On Apr 25, 11:46*am, "T. Valko" wrote:





Try this (array entered):

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

--
Biff
Microsoft Excel MVP

wrote in message

...

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!- Hide quoted text -

- 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.- Hide quoted text -

- Show quoted text -

Hi Biff,

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

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

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


wrote in message
...
On Apr 25, 12:02 pm, wrote:
On Apr 25, 11:46 am, "T. Valko" wrote:





Try this (array entered):

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

--
Biff
Microsoft Excel MVP

wrote in message

...

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!- Hide quoted text -

- 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.- Hide quoted text -

- Show quoted text -

Hi Biff,

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