I am stuck trying to solve this question after searching for hours and trying different code.
Using a data validation dependent list, is it possible to use code to set a default to display when the list is "activated", any time through all ranges on the sheet?
Example:
Worksheet with B4...
Greetings-
Having trouble creating a formula that checks for 2 distinct criteria in a range within 2 different columns to determine if they are true or false (each criteria is in a range in different columns). I hope someone here can help.
It needs to function like this:
If criteria 1 is...