start a copy of data at a line depending on date

N

news

Hello,

I have this huge problem: I try to find a formula to obtain the following
result:

Let F15= 07/2002 and A2= 04/2002, A3= 05/2002, A4= 06/2002, A5=
07/2002, A6= 08/2002, ....A(x+1)=Ax +1month



C2 =SI (A2>=F15 ; P15 ; 0)
C3 =SI (A3>=F15 ; P15 ; 0)
C4 =SI (A4>=F15 ; P15 ; 0)
C5 =SI (A5>=F15 ; P15 ; 0) at this line, the condition
is obtained and for all the followings
C6 =SI (A6>=F15 ; P16 ; 0)
C7 =SI (A7>=F15 ; P17 ; 0)
C8 =SI (A8>=F15 ; P18 ; 0)
C9 =SI (A9>=F15 ; P19 ; 0)

In words : date value of cells "A" are fixed, but date of cell F15 is
variable, like results in "P" cells ; I would like to copy the column under
P15 on the "C "column, beginning at a line corresponding to equalization of
the date between F15 and "A" column.....

Is there someone who can help me...?

Patrick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top