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
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?
--
mrice
Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile:
http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=539445