Friends!
I hope everyone's happy and feeling good!
So, I have a list of names, which I have named, Fruits.
Then, I have another list of names, which I have named, Seller.
I would like to count how many Fruits has Seller and Seller has Fruits.
But the issue is that basically "Apple" would be concealed in the form of "123POlAPPLE090kljkl".
Therefore it is hard to use the simple function of COUNTIFS.
I have attached the file to have a better understanding.
I have inserted the formula of SUMPRODUCT to calculate but of course there is something not right.
I would like to thank you all for the help!
Bookmarks