I am using the below formula which works great, however if I have for example;
abc, fff, ddd, sss, (I want to categorise these into one string result. Example I may want to call the grouping of all of these 'failures' so every cells with these strings in it will return the result 'failures'
=CONCATENATE(IF(B:B="abc","wrong job",""),IF(B:B="fff","satellites",""),IF(B:B="ddd","woo hoo",""),IF(B:B="sss","bad",""),IF(B:B="nnn","unknown",""),IF(B:B="hhh","electrical",""), IF(B:B="sm","wires",""),IF(B:B="nm","parts",""))
Thanks for your help
Bookmarks