Something like this on "By Client" worksheet in row2

=COUNTIF('Raw Data'!C:C,A2)

And then copy down as needed.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"cware" wrote:

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.