I have 3 separate lists of data and I want to check how many items exist on all three lists.
I thought this might work :
=aggr(count(Distinct Item) LIST)
But not getting anywhere with it? If I then wanted to count the number on specific lists, lets say only those items that appear on list 1 and 2, where the price is different and then another count where the price is the same how would you achieve it.
