Finding First Negative Value

[skate1991]

Hi All,

I am looking for a formula which will return the date of the first negative value. I have attached an example workbook.

I manage to get it to return the row or column ref that it falls in but I cant seem to return the date.

Thanks
P

[PaulM100]

Try:

Please Login or Register  to view this content.

[skate1991]

Thanks PaulM100 worked pefectley

[PaulM100]

If it took care of your problem, please mark the thread as Solved. Thanks.

[Czeslaw]

Apply the formula

Please Login or Register  to view this content.

[johnmpl]

Hi, to all!

Another approach could be:
=AGGREGATE(15,6,E3:H3/(E4:H4<0),1)

Blessings!