Number of occurence of every value in one column, in another column

Hi All,

I have one worksheet with two columns A & B.

ColA has nearly 7000 cells. Each cell contains text data of variable length.
ColB has nearly 8500 cells. Each cell contains key text data that has at least 2 strings up to 24.

As I'm sealing a tedious analysis task, I need to return the number of occurences of each value of every cell in ColB from the entire ColA, and return the total in its adjacent ColC cell.

Can I get some precious assistance with this question, please?

Always .. many thanks in advance ..

T.

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook

Thanks Alansidman. Example attached as requested.
Very much appreciated.

T.

Definitely YES AliGW. Your formula did the trick, really marvellous.
Thank you very much for such valuable, easy powerful solution.
I'm glad to mark this question as answered by you AliGW.

All the best.

T.