doctortt
11-26-2012, 08:33 AM
Can one of the gurus here take a look at the file that I attached?
- On the "test" worksheet, I can't figure out what to do with the "Anniversary Flag" row, which is row 6.
-The model starts off by month and then turns to quarter.
-If you look at V6, the flag turns to 1 because that's the first anniversary
-However, AG6 is only the 11th month of the second year, and the column right next to it, which is AH6, immediately turns to a quarterly basis.
The question is how do I make the codes so that Excel can flag 1 after four quarters (because it's an anniversary) while keeping what I have now since the model starts off on a monthly basis
Thank you in advance
- On the "test" worksheet, I can't figure out what to do with the "Anniversary Flag" row, which is row 6.
-The model starts off by month and then turns to quarter.
-If you look at V6, the flag turns to 1 because that's the first anniversary
-However, AG6 is only the 11th month of the second year, and the column right next to it, which is AH6, immediately turns to a quarterly basis.
The question is how do I make the codes so that Excel can flag 1 after four quarters (because it's an anniversary) while keeping what I have now since the model starts off on a monthly basis
Thank you in advance