I have 10 tasks that can each be assigned to 1 of ten sequence numbers. If there is more than 1 task assigned to a sequence number those tasks are run in parallel. So there can be anywhere from 1 to 10 tasks assigned to a sequence number but each task can only be assigned once.
The tasks are identified by the task numbers in column B and the sequence for the task is assigned in column A.
Does anyone have any suggestions for a formula in column E that will create a comma-separated list of the tasks assigned to each sequence number?
Note in the example that only 5 of the sequence numbers are used since some of the tasks run in parallel. The unused sequence numbers are blank.
Thanks in advance for any help!
<tbody>
</tbody>
The tasks are identified by the task numbers in column B and the sequence for the task is assigned in column A.
Does anyone have any suggestions for a formula in column E that will create a comma-separated list of the tasks assigned to each sequence number?
Note in the example that only 5 of the sequence numbers are used since some of the tasks run in parallel. The unused sequence numbers are blank.
Thanks in advance for any help!
<tbody> </tbody> |
<tbody>
</tbody>
Last edited: