Formula to create similar function to a pivot table

[zz_zz11]

Hello,

I'd appreciate help with a file that I am working on. Not sure how to describe it but I have provided an example in the attached file.

I have data in the format presented in columns B and C. I need to create the result in columns F-J. Column F is provided and all the values are unique. Row 4 is provided as well and all the values are unique too.

I need to count how many times there is an overlap.

[AliGW]

In G5 copied across and down:

=SUMPRODUCT(($B$4:$B$9=$F5)*(ISNUMBER(SEARCH(G$4,$C$4:$C$9))))

There is a typo in cell C8 - I've corrected it in the attached.

[zz_zz11]

Thank you so much!

[wk9128]

Hi zz_zz11

Your Cell C8 has the following content: 2002 char six, so it is normal to get 1 in Cell H6 calculation, but it is actually 2002 chair six, or it may be a typo, or you will really get 2

[AliGW]

That was pointed out in post #2 yesterday.