Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
Value between 2 dates | Excel Worksheet Functions | |||
search for latest date | Excel Worksheet Functions |