I have an excel table that looks like this:
Date Original Actual 11/10/10 15 12 12/10/10 12 10 ... 24/10/10 2 1 25/10/10 -2 0
I want to know the date at which the original column becomes negative, 25/10/10 in this example.
I've managed to figure out the value using this formula:
which tells me -2.
I just want it to look at the date column where the original value = -2 and tell me that date, but I can't figure out a way to do this at all!
Anyone have any ideas?