Finding out how many products a customer permanently stocks.

**Paxman71** · 09-25-2013, 10:07 AM

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.

**Tony Valko** · 09-25-2013, 10:15 AM

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

http://contextures.com/xladvfilter01.html#FilterUR

Then, you can use a formula like this:

Data Range