Hi all, I've got this code, & it's not bringing back the results I'm after. =(IF(OR(COUNTIF(K7:M28,"No - Major")>0,1,COUNTIF(K7:M28,"No - Minor")>2,2),"")) K7-M28 are the cells (columns K, L & M are merged cells on each row). Basically if any of these cells have a "No - Major" in them then the result in K29 should be 1, but if any have "No - Minor" three times or more than this should result in a 2. Hope you can help! Thanks.
This question generated 15 answers. To proceed to the answers, click here.
This thread is current as of August 03, 2015.