Hi,
I'm hoping someone could help me out with a formula that returns the first and last month that data is entered into in a columned by-month table.
I have a sheet w/ month's across the top (headers) and projects down the first column. If data is input in one row with values from February to October, I'm hoping to have a formula that will return "Feb-Oct", this should also work if there are breaks within the phasing (for instance if there were month's with that range with no data).
Please tell me this is possible, it would save a *ton* of time (without a formula, I'll have to manually go row-by-row typing out what the timeline of each project is...and I'm hoping to avoid that).
Thank you!
Bookmarks