I have a work sheet that is constantly growing. I have several formulas in columns like this one =IF(OR(ISNUMBER(SEARCH("all",D:D)),(ISNUMBER(SEARCH("EDS-1",D:D)))),"Y", "").
my problem is a few columns down i have this formula =IF(OR(ISNUMBER(SEARCH("all",D:D)),(ISNUMBER(SEARCH("EDS-10",D:D)))),"Y", ""). How do i stop the first formula from counting
DS-10 as DS-1?