I have a table in excel that automatically gets populated once a Microsoft form is submitted.
The trouble I am having is the cell referenced against, if contains more than one of the three categories it does not plot an x the corresponding cell. I originally used the =IF(D5="Repair","x","") for each cell category but this did not work.
Example of one string in cell
Example when two values are in cell does not work
The trouble I am having is the cell referenced against, if contains more than one of the three categories it does not plot an x the corresponding cell. I originally used the =IF(D5="Repair","x","") for each cell category but this did not work.
Example of one string in cell
Example when two values are in cell does not work