C
Colin Hayes
HI
I'm hoping that someone can help with a formula.
In column B , I have a formula which numbers to a maximum of 300. Each
number represents a monthly payment.
In column A I'd like to signal the start of each new year with 'Year 1"
, "Year 2" , "Year 3" etc as the numbers in column B reach 12 , 24 , 36
, 48 and so on.
If the cells in column B are zero in quantity , then so should be the
cells in A.
So :
A B
Year1 1
2
3
4
5
6
7
8
9
10
11
12
Year 2 13
14
15
16
17
18
19
20
21
22
23
24
Year 3 25
Hope someone can help.
Best Wishes
I'm hoping that someone can help with a formula.
In column B , I have a formula which numbers to a maximum of 300. Each
number represents a monthly payment.
In column A I'd like to signal the start of each new year with 'Year 1"
, "Year 2" , "Year 3" etc as the numbers in column B reach 12 , 24 , 36
, 48 and so on.
If the cells in column B are zero in quantity , then so should be the
cells in A.
So :
A B
Year1 1
2
3
4
5
6
7
8
9
10
11
12
Year 2 13
14
15
16
17
18
19
20
21
22
23
24
Year 3 25
Hope someone can help.
Best Wishes