Find pattern (positive, negative, positive)

Hi. I'm attaching my workbook. I have a column that has numbers. (The first number will always be positive). I would like to get a "flag" (1 in another column) whenever the data goes from positive to negative and then positive again (no need for back to back to back). If I get a 1 it should stop looking at this pattern and look to find the next negative and get a 2 then. When that happens start finding for the 1 again (the first pattern). Here is an example to understand.

Column A Column B
3.86%
3.79%
-2.88%
-2.33%
3.36% 1
2.07%
4.65%
-3.87% 2
3.88%
-3.32%
8.20% 1
-0.46% 2
1.49%
2.62%
So, at B5 I get 1 because we have a positive first (A1) then at A3 a negative and then at A5 a positive. Now that it got the 1 it will look for the first negative which it gets at A8.
After that, it tries to find the 1 again. A9 is positive, A10 is negative and A11 is positive so B11 will be 1. A12 is negative so B12 will be 2.
I don't have a specific preference for a formula or a macro.

Hope you understand what I'm trying to do!
Thanks for any help!

P.S. I have asked the same question in another forum http://www.mrexcel.com/forum/excel-q...ml#post4535573

I'm going to see if I can get what you want. B5 = 1 because the trend went from positive to negative to positive. B8 = 2 because it went from positive to negative. B11 = 1 because it went from positive to negative to positive, and B12 = 2 because it went from positive to negative.

So, a positive to negative to positive =1 first flip back to negative = 2.

Do I have that right?

There are errors in your data
B9 should be 1 since A7 is positive, A8 is negative and A9 is back to positive again.
B13 should also be 1 for the same reason since A11 (+) A12 (-) A3 (+)
B16 should be 2 since A14 (-) A15 (+) A16 (-)
B23 should be 1 since A21 (+) A22 (-) A23 (+)

Unfortunately I discovered this manually, and at present don't have a formula to solve this