| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If row contains ANY value - then return "Yes"
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If row contains ANY value - then return "Yes"
Hi,
Try this =IF(COUNTIF(A1:G1,"<")1,"Yes","No") Mike "jgray" wrote: 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If row contains ANY value - then return "Yes"
Oops,
try this instead =IF(COUNTIF(A1:G1,"<")=1,"Yes","No") "jgray" wrote: 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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If row contains ANY value - then return "Yes"
=IF(COUNTA(A1:G1)0,"Yes","No")
-- Regards, Peo Sjoblom "jgray" wrote in message ... 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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If row contains ANY value - then return "Yes"
Thanks to both of you. I tried it out and it works like a champ.
"Peo Sjoblom" wrote: =IF(COUNTA(A1:G1)0,"Yes","No") -- Regards, Peo Sjoblom "jgray" wrote in message ... 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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If row contains ANY value - then return "Yes"
=IF(COUNTA(A1:G1),"Yes","No")
"jgray" wrote: 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. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If row contains ANY value - then return "Yes"
On Jul 13, 10:42 am, Teethless mama
wrote: =IF(COUNTA(A1:G1),"Yes","No") "jgray" wrote: 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. 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If (A1 = "ValueA" & C1 = "ValueB") return the quantity of matches | Excel Discussion (Misc queries) | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| Print IF return "OK" or "NOT OK" in different colors | Excel Discussion (Misc queries) | |||
| Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) | |||
Linear Mode
