Is there anyway that I can create the formulas (in yellow) without having to select the cells in the left most column and dragging across? Thanks.
Is there anyway that I can create the formulas (in yellow) without having to select the cells in the left most column and dragging across? Thanks.
How else would you expect to get the formulas in there? It would take longer to code, test and implement than it would for you to manually select and drag formulas many times over.
Paul, I think the OP wants a formula that will produce that triangle affect
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
amartino, try this, copied down and across from the SECOND row...
=IF(OR(B21="",A21=""),"",IF(COUNT(B21:$M21)<=COUNT($C21:M21),$A22/12,""))
In B21 and copy across and down,
=IF(ROWS($A$21:B21) >= COLUMNS($A$21:B21), "", $A21/12)
Entia non sunt multiplicanda sine necessitate
@ FDibbins. This worked. Would you mind explaining the logic? I tried analyzing formula but I still didn't get it haha. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks