| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Filling cells depending on two conditions
I have worksheet for periodical (serial) payments. Column A - payment starting date, in each row different, formated as "dd.mm.yyyy" Column B - type of payment (yearly, biannualy, quarterly, monthly) Column C - amount of periodical payment Columns D to ?? - range of months, eg. for 5 years, formated as "mmmm yy" What I need is to copy amount (eg. C2) to each respective column D-?? depending on type of payment and starting date. How ? :) -- dziw ------------------------------------------------------------------------ dziw's Profile: http://www.excelforum.com/member.php...o&userid=10422 View this thread: http://www.excelforum.com/showthread...hreadid=469843 |
|
#2
|
|||
|
|||
|
nobody can help me ? thx in advance -- dziw ------------------------------------------------------------------------ dziw's Profile: http://www.excelforum.com/member.php...o&userid=10422 View this thread: http://www.excelforum.com/showthread...hreadid=469843 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display first, second, etc Nonblank Cells in a Range | Excel Worksheet Functions | |||
| Use functions when cells are merged | Excel Worksheet Functions | |||
| Count the number of Cells in one ROW with conditions | Excel Worksheet Functions | |||
| How to get excel cells to change colors depending on value | Excel Worksheet Functions | |||
| How do I automatically shade cells depending on data entered? | Excel Worksheet Functions | |||
Hybrid Mode
