| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Q: check a range values
Hello,
I have Yes or No in the Range A1:A20. As a value in a cell, if there is at least on No in the range I would like return At least One No otherwise None. How should I d this? Thanks, |
|
#2
|
|||
|
|||
|
Q: check a range values
Try this in Cell B1
=IF(COUNTIF(A1:A20,"No")1,"At least One No","") JIM.H. wrote: Hello, I have Yes or No in the Range A1:A20. As a value in a cell, if there is at least on No in the range I would like return "At least One No" otherwise None. How should I d this? Thanks, |
|
#3
|
|||
|
|||
|
Q: check a range values
I think you meant:
=IF(COUNTIF(A1:A20,"No")0,"At least One No","") or =IF(COUNTIF(A1:A20,"No")=1,"At least One No","") or =IF(COUNTIF(A1:A20,"No")1,"At least Two No's","") <vbg wrote: Try this in Cell B1 =IF(COUNTIF(A1:A20,"No")1,"At least One No","") JIM.H. wrote: Hello, I have Yes or No in the Range A1:A20. As a value in a cell, if there is at least on No in the range I would like return "At least One No" otherwise None. How should I d this? Thanks, -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I check repeating sets of number in a range | Excel Worksheet Functions | |||
| copy exact values from RangeA to Range B which has extra rows | Excel Discussion (Misc queries) | |||
| How many values appear more than once in a range? | Excel Worksheet Functions | |||
| Summary of values from a date range | Excel Worksheet Functions | |||
| Checking ALL values in a range | Excel Discussion (Misc queries) | |||
Hybrid Mode
