Great site, i have an excel challenge and I haven't found a solution yet.

Here it is, any insight would be greatly appreciated.

http://screencast.com/t/1mxOcUoOqhlD

I have 8 cells in columns A-H in Row 3. their contents are

-5, 5, -2, 4, -2, 10, 4, 11

in Cell K1 = 3

I need a formula that will tell me which position in Row 3; where after the value in K1 has been exceeded, I need the position of the next time i have a value of less than or equal to "Zero". Looking at the data, the answer should be "3", but I am having a hard time using "Match" and "Index" and "ISNA" formulas that are not working.

Basically, 3 is exceeded by the second number (5), I want the next time a number is <1 after the 5 ie -2 the third number, so the answer should be "3".


Any insight would be Greatly Appreciated.

thanks in advance.


Will