problem of copying column related to date

[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

 

[mrice]

Having a little trouble understanding this one. Would it be possible to
create a dummy sheet showing what you expect it to look like given a
couple of different values of F15?

 

[news]

Hi Mrice,
no problem! :


I have got the table "FP" which can be.... (F column begin by a variable
month, and after it is month by month; P column is the result of operations)
F P
15 07/2002 125
16 08/2002 587
17 09/2002 879
..... ..... .....
64 08/2006 789

but also....
F P
15 01/2010 4546
16 08/2010 4652
17 09/2010 4845
..... ..... .....
255 12/2029 1452

or again
F P
15 04/2002 24
16 05/2002 27
17 06/2010 29

and then , I have got the fixed columns A and B, where in want to put
results of P column in the B cells, but important!!, related to the correct
date in the table "FP" :

A B
03/2002
04/2002
05/2002
06/2002
07/2002
08/2002
09/2002
......
02/2042

so for the first example , it should look like:
A B
03/2002
04/2002
05/2002
06/2002
07/2002 125
08/2002 587
09/2002 879
...... ...
08/2006 789
......
02/2042


but for the third, it will be:

A B
03/2002
04/2002 24
05/2002 27
06/2002 29
07/2002
08/2002
09/2002
......
02/2042


I hope it is more clear now,
thank you again Mrice!



























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

 

[mrice]

Sorry for the delay in replying.

The attached has a macro which will aligh data whenever a change is
made to the values in column F. I hope that this is what you are after.


+-------------------------------------------------------------------+
|Filename: Book1.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4752 |
+-------------------------------------------------------------------+