Forum Discussion
Excel Planner
Macro is fine within my organisation. I will still need to keep the original format but have an altered view for other people within the organisation.
For example, the planner will require the orignal view. The people following the plan will require the new proposed view.
Cheers.
Elliot
Serdet If you are open for slightly alternative formats the following is easy:
| Dates | Task IDs | |
| Friday, January 1, 2021 | 1 | |
| Monday, February 1, 2021 | 2 | 3 |
| Thursday, April 1, 2021 | 4 | |
| Saturday, May 1, 2021 | 5 | |
| Tuesday, June 1, 2021 | 6 |
In the attached example I used =UNIQUE() for the dates but you could force the Dates so for example include March 1 and it would show blank/no task IDs
For the task IDs I used =TRANSPOSE(FILTER()) as you can see in the attached.
Hi mtarler
Thank you for taking the time to help me with my problem.
Is there anyway to transpose other data fields in with the ID's? For example, I have another column titled 'removal or install' which I would like the data to be tagged with the ID.
Many thanks,
Elliot
can you give a sample sheet and how you want it to look? Like concatenate the ID and if it is "removal" or "install"? Like this:
btw, I updated the file to also fix the ranges