Counting how many times each item appearss in a Column

I hope the experts here can help, and that I can write a question that can be understood.

I have a sheet the looks something like this.

Col A Col B Col D
Date of sale Name of Item Buyer
11-2-12 Dress A Buyer B
11-2-12 Dress D Buyer C
11-2-12 Dress C Buyer B
11-2-12 Dress A Buyer A

What I am looking for is a way to get a running count of each Item and buyer. Every time the same item appears in Col B it's item count goes up by 1.

the result would look like this
Col A Col B Col C Col D Col E
Date of sale Name of Item Buyer Item Count Buyer Count
11-2-12 Dress A Buyer B 2 2
11-2-12 Dress D Buyer C 1 1
11-2-12 Dress C Buyer B 1 1
11-2-12 Dress A Buyer A 1 1

Dress A sold twice, it's count went to 2, Buyer B bought twice and her count went to 2. This way i can see my top selling items and best customers.

I have 400 unique items, so creating a rule for each item name is not an option.

Any suggestions?

Not sure why you have the higher numbers on the first row, but you could try this in D2:

Formula:

Please Login or Register  to view this content.

and this in E2:

Formula:

Please Login or Register  to view this content.

then copy down.

Hope this helps.

Pete

Originally Posted by Pete_UK

Not sure why you have the higher numbers on the first row, but you could try this in D2:

Formula:

Please Login or Register  to view this content.

and this in E2:

Formula:

Please Login or Register  to view this content.

then copy down.

Hope this helps.

Pete

I may be doing something wrong, I get Err:508

I don't know what that error means, but I think you are doing something wrong. I just set it up in a blank worksheet and it works for me.

Hope this helps.

Pete