# Finding out how many products a customer permanently stocks.

1. ## Finding out how many products a customer permanently stocks.

I have a spreadsheet, that shows many different customers that purchase many different products each product bought will be a new row on the spreadsheet. What I want to do is on a seperate sheet have each customer shown only once and find out if at any point on the original sheet there is the word Permanent in the next column and if there is how often.

I'm sure there must be a way of doing this but I have never needed to.

Any help will be greatly appriciated.

2. ## Re: Finding out how many products a customer permanently stocks.

Create a list of the unique customer names. You can do this easily with advanced filter:

Then, you can use a formula like this:

Data Range
 A B C D E 1 Customer Status ----- Customer Permanent 2 1 1 1 3 1 Permanent 2 1 4 2 Permanent 3 0 5 2 4 2 6 3 5 0 7 4 Permanent 8 4 Permanent 9 5 10 5

This formula entered in E2 and copied down:

=COUNTIFS(A\$2:A\$10,D2,B\$2:B\$10,E\$1)

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1