List A has the following sites: x, y, z
List B has the following sites: x, y, z, a, b, c
What formula will reveal to me that sites a, b, and c are in the range I'm looking at but missing not listed in List A?
Reason: I'm have a countif formula looking for the counts of reports created for various sites - but sometimes that site list grows but hasn't quite grown on my formula
List B has the following sites: x, y, z, a, b, c
What formula will reveal to me that sites a, b, and c are in the range I'm looking at but missing not listed in List A?
Reason: I'm have a countif formula looking for the counts of reports created for various sites - but sometimes that site list grows but hasn't quite grown on my formula