Most valuable professional
  • Hot Topics

Excel Counting certain text in a selection

Hi all, I've got this code, & it's not bringing back the results I'm after. 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 3, 2015.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel