Hello, I'm trying to evaluate two ranges within a countifs formula for any potential identical values.
I have a calendar/schedule sheet with the days of the week and two rows of values using a three character letter code (ABC for the sake of the formula below) and a four digit number code indicating schedule.
I am using this formula:
=countifs(a3:a33,"SU",c3:c33,"ABC",b3:b33,????)
Where a3:a33 is a list of days of the week
c3:c33 is a list of three letter codes corresponding to certain schedules (ABC, etc.)
and b3:b33 is a list of four digit codes on the schedule
???? indicates the list of acceptable codes I'm trying to compare to b3:b33
I have gone through the four digit codes and determined that 12 of several hundred possibilities are the ones I'm specifically seeking and I have those saved in aa3:aa14.
How do I determine whether the corresponding value in b3:b33 matches any of the values in aa3:aa14? I have tried several variations and found no success. I've even looked into CSE formulas for evaluate multiple arrays. What am I missing here?
If countifs isn't the best function, is there a better function for this? Thanks!
I have a calendar/schedule sheet with the days of the week and two rows of values using a three character letter code (ABC for the sake of the formula below) and a four digit number code indicating schedule.
I am using this formula:
=countifs(a3:a33,"SU",c3:c33,"ABC",b3:b33,????)
Where a3:a33 is a list of days of the week
c3:c33 is a list of three letter codes corresponding to certain schedules (ABC, etc.)
and b3:b33 is a list of four digit codes on the schedule
???? indicates the list of acceptable codes I'm trying to compare to b3:b33
I have gone through the four digit codes and determined that 12 of several hundred possibilities are the ones I'm specifically seeking and I have those saved in aa3:aa14.
How do I determine whether the corresponding value in b3:b33 matches any of the values in aa3:aa14? I have tried several variations and found no success. I've even looked into CSE formulas for evaluate multiple arrays. What am I missing here?
If countifs isn't the best function, is there a better function for this? Thanks!
