+ Reply to Thread
Results 1 to 2 of 2

2-Column List of Unique Distinct COMBINED Values

  1. #1
    Registered User
    Join Date
    06-19-2016
    Location
    Artesia, NM
    MS-Off Ver
    2010
    Posts
    1

    2-Column List of Unique Distinct COMBINED Values

    Okay. I've found several different answers to the question, "How do I create a list of unique distinct values?" What I seek is something different, and I'm not quite sure how to word it so I'll just explain the situation. This is my first post, but it appears my accompanying picture ("List of Unique Distinct COMBINED Values.jpg has uploaded successfully - the following will reference this screenshot of my Excel sheet.

    So in the main table (A13:A34) under "Treatment #7" Data Validation is utilized in columns J and K so the user can select/add/change the Fluid & Proppant types.

    For the report, we must separate each fluid system into clean ("-" for NO proppant), proppant 1, proppant 2, proppant 3....

    So for example; in the picture there are only two proppant types: 100M and 40/70.

    Notice columns M & N in the second table (M87:R95) has separated the fluid and proppant types as I've described: SW + "-", a SW + 100M, and SW + 40/70. The trouble is that when people have to ADD a new Fluid or Proppant they forget to edit this section.

    WHAT I SEEK: I'm trying to find a way for M86:N95 to fill itself out automatically - list each fluid & proppant combination without duplicates, in the order they appear.

    Is there a way to do this? I'm thinking there must be, but I just can't find it. Please keep in mind the picture only shows Treatment #7, and the solution you provide will need to be applied to ALL 50+ Treatments (tabs).

    Thank you in advance!
    Attached Images Attached Images
    Last edited by probladerunner; 06-19-2016 at 07:20 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    12-02-2012
    Location
    Melbourne, VIC
    MS-Off Ver
    Excel 2016
    Posts
    750

    Re: 2-Column List of Unique Distinct COMBINED Values

    I can think of a couple of ways to achieve this:
    1. Using an extra combo column
      • Create an additional column (say P13 = J13 & "," & K13; so the value in P13 would be "TW,-")
      • Use "Remove duplicates": Now apply remove duplicates on the list in P13 to P34. This should leave you with a list of unique combination values.
      • Use "Text-To-Column", with Comma as delimiter to split them back in column M and N respectively, beginning at Row 87.
      • The only trouble is you'll have to do this every time, and for over 50 worksheets, and that would get very cumbersome.
    2. Using Pivot Table
      • This is a much simpler option. Simply create a pivot table for each treatment table.
      • Allow for extra rows in your pivot data so you won't have to modify them every time.
      • Create whatever pivot view of you data you desire.

+ 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: 0
    Last Post: 07-21-2015, 04:44 PM
  2. [SOLVED] unique distinct list from a column but
    By pic2pic in forum Excel General
    Replies: 15
    Last Post: 02-02-2015, 05:15 PM
  3. Create a Distinct Unique list for 2 Columns
    By boldcode in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-06-2014, 05:10 PM
  4. Replies: 5
    Last Post: 12-24-2013, 08:38 AM
  5. [SOLVED] Copy Unique Distinct Values
    By snapfade in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-17-2013, 10:33 AM
  6. [SOLVED] Distinct List from Column of Values
    By dianaschar in forum Excel General
    Replies: 4
    Last Post: 03-26-2013, 11:39 AM
  7. [SOLVED] Unique distinct alphabetically sorted list
    By atlant15 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-06-2013, 10:03 AM

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