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/01/2021 |
| 6 | 06/01/2021 |
To make the table for visually appealling and easier to use, is there a way to automate this in a different view to read like the below
01/01/2021 - Friday
ID 1
02/01/2021
ID 2
ID 3
'and so on'
This will make the users be able to easily see how many ID are due on each day in a simple clear format.
Many thanks,
Elliot
5 Replies
- 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.
