Hey guys - I have a sheet that has (among other things) 7 different columns
associated with product failure. The workbook itself consists of a large
number of products, of which only a very small fraction will have anything
marked in any one of the failure columns. The failure columns are general
text and not necessarily numeric.

I am trying to write a If/Then so that if ANYTHING is present in ANY of the
seven columns, I will get a return of "YES" in my cell. If nothing is
present, then it will return with "NO". I will then be able to sort by "yes"
or "no".

Is it possible to write an If/Then for general, unstandardized text that
simply will recognize if something is populated? Also, columns exist between
each of the 7 failure columns. It would be helpful if these columns could be
excluded from the formula.