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...