Hi there,

Would appreciate some assistance with the very simple scenario below:
NAME FRUIT
Bill Orange
Bob Apple
Jade Apple
Gillian Apple
Gillian Orange
Bob Orange
Bill Apple
Bill Orange


So, there's our data, please imagine that 'Name' and 'Fruit' are in separate columns next to each other.

The Goal
In one cell, I want to show how many times 'Orange' occurs next to 'Bill', as a number.
AND (in a separate cell)
I want to show how many times 'Apple' occurs next to 'Bill', as a number.

Hopefully this would also be replicated, so that we could do the same for Gillian, Wendy, etc.

It feels like a COUNTIF / VLOOKUP amalgam, but I am really struggling (poor Excel skills). I am sure this would be a walk in the park for many of you!

Any help would be really appreciated.

Thanks,
Chris