Hello,
I have Chemical name data in column Each chemical name is separated by "&" in cell.
I want a workflow for highlighting those records in which chemical names are not arranged alphabetically in a cell.
Eg
| ACETYLSALICYLIC ACID & CAFFEINE & CODEINE & PARACETAMOL |
ACETYLSALICYLIC ACID followed by CAFFEINE then CODEINE & then PARACETAMOL.
In above example chemical names arranged in correct order.
Number of chemicals names present in cell is not fixed. Please refer attached file for workflow development.
