Since you don’t have/want NULL values the statement would be:
=IF(H2="Yes",1,0)
This is based upon your image provided.
This is a valid solution. However, based upon having over 12K rows I believe SQL may be a better direction.
Since you don’t have/want NULL values the statement would be:
=IF(H2="Yes",1,0)
This is based upon your image provided.
This is a valid solution. However, based upon having over 12K rows I believe SQL may be a better direction.