I have a data stream in M100:M291 and dates in V100:V291.
In F44 I have a date that corresponds with the end of a period of negative numbers, formatted as a date mmm-yy using
=VLOOKUP(F42,M100:V291,10,FALSE)
The formula looks for the occurrence of a single negative number and retrieves the period in which it occurred.
Does anyone know how I can use a formula in Excel 2010 to look through the data in M100:?291 and look UP in the column to find the first positive number above the last (F44) in a series of negatives?
Bookmarks