ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   start a copy of data at a line depending on date (https://www.excelbanter.com/excel-programming/360728-start-copy-data-line-depending-date.html)

news

start a copy of data at a line depending on date
 
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







All times are GMT +1. The time now is 01:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com