G'day,
Another tricky one in my mind.
I have 100 jobs multiple lines per job with the same JOBID found in column A starting in A2.
I also have a description of material in Column W. Starting at W2.
What I need to do is if the BLOCK is the same job ID (column a) and "Ridge300" is found in Column W then AC column needs to be "1" against each row which matches this criteria.
Looking something like this: Thanks for your help!
<tbody>
</tbody>
Another tricky one in my mind.
I have 100 jobs multiple lines per job with the same JOBID found in column A starting in A2.
I also have a description of material in Column W. Starting at W2.
What I need to do is if the BLOCK is the same job ID (column a) and "Ridge300" is found in Column W then AC column needs to be "1" against each row which matches this criteria.
Looking something like this: Thanks for your help!
JOB ID | Machine | FLAG |
1 | xxx | 1 |
1 | Ridge300 | 1 |
1 | xxx | 1 |
1 | xxx | 1 |
1 | xxx | 1 |
25 | Ridge300 | 1 |
25 | xxx | 1 |
25 | xxx | 1 |
3 | Ridge400 | |
3 | xxx | |
3 | xxx | |
3 | xxx | |
3 | xxx | |
5 | xxx | 1 |
5 | xxx | 1 |
5 | xxx | 1 |
5 | Ridge300 | 1 |
5 | xxx | 1 |
5 | xxx | 1 |
<tbody>
</tbody>