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 advancesample.xlsx