macro or function needed for count...

[excelhelpseeker]

Hi champs,

I have data from A to T column.

the rule is

1. if i have all cells from A2:T2 as "No" or "N/A", then the result is "Yes" in U2
2. If any of the cells from A2:T2 is "Yes" then result is "NO"


Please not that "N/A" entry is dummy. so its a dont care cell.


please help me with a formula or a macro. i have attached a sample file


Thanks in advance.View attachment sample.xlsx​

 

[NBVC]

Try:

=IF(COUNTIF(A2:T2,"YES")>0,"NO","YES")

 

[excelhelpseeker]

Try:

=IF(COUNTIF(A2:T2,"YES")>0,"NO","YES")

Thanks .. working fine.