+ Reply to Thread
Results 1 to 2 of 2

Formula for getting unique values from two dependent rows

  1. #1
    Registered User
    Join Date
    09-19-2018
    Location
    Tbilisi, Georgia
    MS-Off Ver
    Microsoft Office Professional Plus 2013
    Posts
    1

    Question Formula for getting unique values from two dependent rows

    Hi,

    I have been searching for this and cannot find a solution if anybody can help.

    So I have two columns "usernames" and "products". The list shows specific transactions, meaning user and product paid by him or her. So there are duplicate values in both columns since each user paid multiple products for the specific time period. (I have 12,000 unique users, 350 products and about 200,000 transactions).

    I need to get a largest to smallest list of users by paid unique products, meaning I need to return unique values from the products column for each user.

    The only way I came up with so far is to filter for each individual user and then use remove duplicates for the products column, which is impossible to do 12,000 times.

    Can anybody help?

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    21,676

    Re: Formula for getting unique values from two dependent rows

    You could use a helper column with a COUNTIF formula to identify where a name first occurs (and give this a unique ID), and then you can use an INDEX/MATCH formula to extract the names against those numbers.

    I can't give you an exact formula to use, however, as you have not said which columns you use for "usernames". Please describe the layout of your sheet in a bit more detail.

    Hope this helps.

    Pete

+ 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. Replies: 13
    Last Post: 10-20-2019, 05:39 AM
  2. x2 Dependent ComboBoxes with Unique Values
    By aidan5800 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-30-2018, 12:57 PM
  3. [SOLVED] Userform - dependent combobox with unique values
    By Villalobos in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-17-2018, 04:50 PM
  4. Replies: 1
    Last Post: 01-29-2015, 04:08 PM
  5. [SOLVED] Unique values in dependent drop downs
    By ertweety in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-19-2012, 10:27 AM
  6. Unique list Array Formula dependent of two criteria
    By ron2k_1 in forum Excel General
    Replies: 3
    Last Post: 09-01-2011, 10:50 PM
  7. Dependent list using only unique values in drop down
    By jwaldridge in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-10-2011, 05:56 PM

Tags for this Thread

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