HELP!!! Trying to populate a table based on first month of revenue.
Hi. I’m stuck and could really use some help. In the attached picture, I’m trying to populate the Month of First Revenue (in this case 4 — D7 value) into the corresponding month (in this case F14). I need the formula to be dynamic so if I change D7, the revenue aligns under the correct month on the Sales row (row 14). Any help is greatly appreciated!!!
Hi. I’m stuck and could really use some help. In the attached picture, I’m trying to populate the Month of First Revenue (in this case 4 — D7 value) into the corresponding month (in this case F14). I need the formula to be dynamic so if I change D7, the revenue aligns under the correct month on the Sales row (row 14). Any help is greatly appreciated!!! Read More