"IanRoy" wrote:
Hi, Tray;
Assuming column A contains the dealer codes in your list, then in another
column, such as B, list the dealer codes one time each. In a third column,
use the countif function, like: =COUNTIF(A:A;B2). This will return the number
of times the dealer code in B2 shows up in column A. Fill the formula on down
for the other dealer codes.
Regards,
IanRoy.
"Tray" wrote:
I have a list of all sales made by our dealers. Each dealer has an individual
dealer code. I need to count how many sales each dealer has made and so need
to count how many times each dealer code appears in my list. Is there a quick
and easy way of doing this - my list has over 15,000 entries, comprising of
hundreds of dealer codes!!
|