swelldandy
New Member
- Joined
- Feb 27, 2019
- Messages
- 2
I have to create a work plan spreadsheet that tracks tasks, which have steps.
<tbody>
</tbody>
As each staff member completes the step, they will update the status line, for example "DoF approval received 01/01/2019"
From there, I would like to have a sheet where each task was condensed down into the task and the latest status. For example:
<tbody>
</tbody>
Is it possible to ask Excel to look at line 6 (in table 1), and if blank, look at line 5 so on and so forth until it finds text at which point it copies the status? Or is there a better way to do it? Or can it not be done at all?
Thanks for your time.
Task X | Status |
Step 1 | 1. Status 1 |
Step 2 | 2. Status 2 |
Step 3 | 3. Status 3 |
Step 4 | 4. Status 4 |
Step 5 | 5. Status 5 |
Step 6 | 6. Status 6 |
<tbody>
</tbody>
As each staff member completes the step, they will update the status line, for example "DoF approval received 01/01/2019"
From there, I would like to have a sheet where each task was condensed down into the task and the latest status. For example:
Task | Status |
Task 1 | 4. DoF approval received 01/01/2019 |
Task 2 | 3. Approval requested by DoF |
<tbody>
</tbody>
Is it possible to ask Excel to look at line 6 (in table 1), and if blank, look at line 5 so on and so forth until it finds text at which point it copies the status? Or is there a better way to do it? Or can it not be done at all?
Thanks for your time.