Apr 26 2019 02:21 PM
I have a spreadsheet with ranges by date containing "yes" and "no" responses. I need a formula to look at the range, assign a "Yes" response if there are no "no"s in the range, a "No" response if there are any "no's" in the range, and a blank response if the range is blank.
Any suggestions?
Apr 26 2019 02:26 PM
Apr 26 2019 03:29 PM
That worked perfect, thank you!
Apr 27 2019 01:25 PM
@cjohns125 , you are welcome