I have a column filled with my stock projections for the next 30 or so years. I have a column to the left of it that shows what month it will be, and another column for how much I'll be investing that month.
If there any way I can have a cell, separate from the column itself, that can show me in which month my stocks will exceed, let's say, $1,000,000? I'd love for it to be able to look at the column, say "this is the first time the number exceeded 1M, and this is the month that it did it", and then put that month into my chosen cell. Then I would have other cells with other milestones, too. That way I can see how a change in my monthly investments will change the dates of reaching my goals.
Bookmarks