Forum Discussion
Excel Planner
Hi All, I have an excel spreadsheet which is used as a tracker as is laid out as below ID PLANNED START DATE 1 01/01/2021 2 02/01/2021 3 02/01/2021 4 04/01/2021 5 05/0...
Are you looking for a solution that is recorded using a Macro? Because in some organization running a Macro is not allowed for security reasons. If Macro is fine, I can suggest a way. If not, we will have to concatenate and do some counting etc.
- Hi,
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.
ElliotSerdet 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.
