You were correct that I found the problem when doing this. I appreciate the value of posting the whole code, but the code is very lengthy and would require explaining multiple other variables that were included in the IF statements. Moreover, posting would make public some information that I don't want disclosed. Ultimately, the issue lay in the complexity, with an out-of-place AND portion tacked on. It was intended to apply to a different column but was incorrectly attributed. The suggestion of printing the data assisted in finding the problem. Thanks to all for your assistance. ... View more