+ Reply to Thread
Results 1 to 2 of 2

Finding out how many products a customer permanently stocks.

  1. #1
    Registered User
    Join Date
    09-05-2013
    Location
    Bedford, England
    MS-Off Ver
    Excel 2007
    Posts
    4

    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. #2
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    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:

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

    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)
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Finding the right function, totalling customer recency.
    By alphabet_soup in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-20-2013, 08:10 PM
  2. Top 3 sold products and qyty by customer from list
    By e602043 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-08-2013, 11:01 AM
  3. help with finding and auto updating lowest price for different products
    By shesdetermined24 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-12-2012, 04:27 PM
  4. Searching and displaying multiple products per customer
    By idemdito in forum Excel General
    Replies: 1
    Last Post: 09-13-2011, 08:38 AM
  5. Finding the greater product of two sets of products and then some
    By bruce42 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-14-2008, 06:40 PM

Bookmarks

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