Help with IF(AND) formulas
What I've written above is what I want to do. Below is the formula, which gives me the dreaded #UNPARSEABLE.
After I can get this straightened out, then it becomes more complicated.
Then I need to check that Instructor 2's LAST NAME does not equal Instructor 1's LAST Name.
Then I need to check that Instructor 3's LAST NAME does not equal Instructor 1 & 2's LAST NAMES
Finally, I'll need to check that Instructor 4's LAST NAME does not equal Instructor 1, 2, & 3's LAST NAMES.
Sometimes we have a group of instructors who go to teach in one location. Sometimes we only have 1 instructor who will teach at least 2 courses. (Even though there are 2 courses taught, we only count it as 1 instructor even though his name will appear twice for this trip.)
I need a count of instructors who go to teach each quarter, and I need to know if they are Nationals or if they are U.S. Instructors.
All names columns are TEXT only. (My brain is slowly frying....) Thanks for any help!!