Hi, i am wondering what the excel formula would be if I need to identify if there are multiple items in column A that also have multiple items in column B.
An example is attached.
In this case, I would want to know that Example 3 has 3 Grapes and also that Example 5 has two pineapples
Bookmarks