Return month from GANTT table

Hansulet

Board Regular
Joined
Jan 24, 2013
Messages
111
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>
 

Some videos you may like

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Hansulet

Board Regular
Joined
Jan 24, 2013
Messages
111
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
 

Watch MrExcel Video

Forum statistics

Threads
1,108,522
Messages
5,523,363
Members
409,514
Latest member
MarkZuckerberg

This Week's Hot Topics

Top