I am trying to count how many unique skus appear in three data sets.
Data set A is a list of 2000 best selling skus
Data set B is a list of skus on order into a warehouse
Data set C is a list of skus with inventory already in the warehouse
I am trying to get a count of how many skus in data set B are on data set A while simultaneously not on data set C
Is there any way to do this? Another user back in 2017 very helpfully provided this formula for counting values that appear in two data sets, I am missing the ability to exclude values from a third.
COUNTIF( LOOKUP( GROUP( names_in_A ) , GROUP(names_in_B) , GROUP( names_in_B ) ) != BLANK() )