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!
Bookmarks