Hi
First time poster, and an average (at best) excel user.
I have a table (see below) that lists jobs and who were the corresponding workers . As you would appreciate, some names appear across multiple jobs.
I would like to create (in a new worksheet called Backdata) a single column list that extracts non-blank cells and only unique text (no duplicates). Is this possible?
<tbody>
</tbody>
I am using Excel for Max 2008 so unfortunately cannot do VBA macro. Is it possible to achieve this via a formula? Cheers
First time poster, and an average (at best) excel user.
I have a table (see below) that lists jobs and who were the corresponding workers . As you would appreciate, some names appear across multiple jobs.
I would like to create (in a new worksheet called Backdata) a single column list that extracts non-blank cells and only unique text (no duplicates). Is this possible?
F | G | H | I | J |
Job | Worker 1 | Worker 2 | Worker 3 | Worker 4 |
CR003 | Joe | Tim | Simon | |
DE004 | Simon | |||
DF051 | Jay | |||
CR002 | Minnie | Joe | ||
CR023 | Jack | |||
DE123 | Fred | |||
DE345 | Lisa | Fred | Simon | Joe |
DF657 | Minnie | |||
CR005 | Minnie | |||
DE456 | Lisa | |||
DF567 | Mike | |||
DE304 | Mike | Joe | ||
CR567 | Angus | Joe | Lisa | Simon |
<tbody>
</tbody>
I am using Excel for Max 2008 so unfortunately cannot do VBA macro. Is it possible to achieve this via a formula? Cheers