I have a Gantt Table based on activities (vertical axis) and and month (horizontal axis).
In this Gantt table, cells are colored if there is activity in the month
I need a formula to show me in which months that business is doing.
For example, if an activity takes place in month 1, the formula shows me 1
If an activity takes place in the 2 to 10 months, the formula shows me 2 to 10
If an activity takes place in months 2, 7, 10, the formula shows me 2, 7, 10.****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
In this Gantt table, cells are colored if there is activity in the month</body>
In this Gantt table, cells are colored if there is activity in the month
I need a formula to show me in which months that business is doing.
For example, if an activity takes place in month 1, the formula shows me 1
If an activity takes place in the 2 to 10 months, the formula shows me 2 to 10
If an activity takes place in months 2, 7, 10, the formula shows me 2, 7, 10.****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
In this Gantt table, cells are colored if there is activity in the month</body>