earliest date

[spig]

I currently have a formula reading.....

=IF(COUNT(C10:CW10),INDEX(C$1:CW$1,,MATCH(TRUE,INDEX(ISNUMBER(C10:CW10),0),0)),"")

It read from blank cells C10 to CW10 and date cells C1 to CW1

However, I have had to change the blank cells C10 to CW10 to formulas which returns a zero if criteria not met. Therefore, the earliest date function now reads the 1st entry date due to the formulated cells C10 to CW10

How do I add something to the IF formula above to not read zero's?

Your assistance would be greatly appreciated

Regards

 

[AlphaFrog]

Try something like this...
=IF(COUNT(C10:CW10),MIN(IF(C10:CW10>0,C1:CW1,"")),"")

This is an array formula. When you enter in this formula, use Ctrl+Shift+Enter. Excel will automatically surround the formula with {braces}.

 

[spig]

Alpha Frog - perfect - worked fine. Thanks very much for your time

Regards

Spig

 

[T. Valko]

I currently have a formula reading.....

=IF(COUNT(C10:CW10),INDEX(C$1:CW$1,,MATCH(TRUE,INDEX(ISNUMBER(C10:CW10),0),0)),"")

It read from blank cells C10 to CW10 and date cells C1 to CW1

However, I have had to change the blank cells C10 to CW10 to formulas which returns a zero if criteria not met. Therefore, the earliest date function now reads the 1st entry date due to the formulated cells C10 to CW10

How do I add something to the IF formula above to not read zero's?

Your assistance would be greatly appreciated

Regards

You just need a slight tweak to the formula...

=IF(COUNT(C10:CW10),INDEX(C$1:CW$1,MATCH(TRUE,INDEX(C10:CW10>0,0),0)),"")