If row contains ANY value - then return "Yes"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
=IF(COUNTA(A1:G1),"Yes","No")
Click to expand...

Those examples check every column from A to G.
If you have 7 columns over 9 columns where you have 2 columns that you
want to ignore
these examples need to be tweaked
Tweak the examples to check only the groups of columns with failure
data
in them rather than checking contiguously, one might do the following.

EG if you have A:E then H:I you might want to try;
=IF(COUNTA(A1:E1),"Yes",IF(COUNTA(H1:I1),"Yes","No"))

And any variations of that nested IF statement.

Nick
 
Back
Top