+ Reply to Thread
Results 1 to 3 of 3

How to find customers which purchase particular product

  1. #1
    Forum Contributor
    Join Date
    04-23-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    113

    How to find customers which purchase particular product

    Dear All Masters,

    I have an excel sheet in which I want to find the those all customers and their customer type,product basic price and monthly volume who purchase that particular product, based on it's item code (item code which will available in Master sheet cell A3).

    And all the data which has to be find, is available in DEALER DATA sheet.

    I have attached sample sheet for your reference.

    Kindly do the needful

    Thanks in advance.

    Dev.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    03-30-2016
    Location
    Gillette, WY
    MS-Off Ver
    Office 365
    Posts
    230

    Re: How to find customers which purchase particular product

    Ok,

    Sorry this took so long. I was having a terrible time until I realized that your named range "itemcode" in Basic!B2:B7
    that you were using to produce the drop-down in Master!A3 does not correspond to all entries in your Dealer Data for
    Item Code.

    I created a new named range called Item_Code_Reference_Range in Master Column L and used it for the data validation for the input cell Master!A3. I also formatted your Dealer
    Data into an Excel Table. This creates dynamic named ranges for all columns in the table.

    The following formula can then be ARRAY ENTERED (Ctrl+Shift+Enter) into Master!B6 and copied down as
    far as you need:

    Please Login or Register  to view this content.
    The other columns in your sorting table use the same formula only the initial array criteria for the INDEX(array) changes
    to the corresponding column in Dealer Data.

    Hope this helps!
    Attached Files Attached Files
    Last edited by TFiske; 01-28-2018 at 10:07 PM.

  3. #3
    Forum Contributor
    Join Date
    04-23-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    113

    Re: How to find customers which purchase particular product

    Dear Sir,

    Sorry for the delay in replay, I just checked solution given by you it's working great for me.

    Thank you so much.

    Regards,

    Dev.

+ 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. [SOLVED] Product purchase value based on total payed amount
    By 2p12p1 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 12-28-2017, 06:59 AM
  2. [SOLVED] Retention formula to count unique customers that made a purchase in both years
    By stu40 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-23-2016, 01:24 AM
  3. Determine repeat customers vs. new customers based on purchase date
    By mktgdude in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-02-2013, 04:10 AM
  4. Macro to Pull Info from Product Line Sheet to Purchase Order Sheet
    By JeffreyJr in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-09-2012, 11:16 AM
  5. [SOLVED] Find Product Details in Another Sheet based on Product ID and Copy some Fields From there
    By kevalkothari in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-29-2012, 10:43 AM
  6. [SOLVED] Need Function that will find ordered product, and display the product code in a 2nd workbk
    By rollerden in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-21-2012, 08:52 AM
  7. Replies: 5
    Last Post: 01-16-2010, 01:17 AM

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