Hi all. Thanks in advance for your help.

I have a workbook with two sheets
"By Client" has column A which is a list of client codes
"Raw Data" has 35000 lines of data where each line will include a client
code in column C.

On "By Client" I want to count how many times that client code shows on "Raw
Data".

I have already used a pivot table to get the list of client codes I want to
use, put I need to take this additional step.

Appreciate your assistance.