toony
New member
Can the below be shorten up? It’s basically to count if “dr” or “ba” are in cell E2180;
=IF(ISNUMBER(SEARCH("(dr)",E2180)),"1",IF(ISNUMBER(SEARCH("(ba)",E2180)),"1",""))
Many thanks
=IF(ISNUMBER(SEARCH("(dr)",E2180)),"1",IF(ISNUMBER(SEARCH("(ba)",E2180)),"1",""))
Many thanks