At work we currently use a program that outputs product number combinations in a single cell. For example, in cell C2 there will be "1 4 6" to show the customer ordered products 1, 4 and 6. These numbers are separated by a single space. Is there any if() type formula I could use that would detect if the products were out of order like "1 6 4". I do not want to use the text to column conversion as I want to keep it all in one step.
Thanks!!
Aucun commentaire:
Enregistrer un commentaire