Parse-ing

Susan van Niekerk

Hi Brain Trust

I have a sheet that has two Compliance & Training Columns

1/ Job Requirement

2/ Candidate Compliance Check

3/ Helper columns that reports the Count difference between 1&2 - this then triggers conditional formatting and a symbol Column

I have been asked to - when drop downs are select in the job Requirement Column( can be upto 20 requirements) that each requirement get parse out into individual Columns(yet to be added