Data Validation SOURCE - Unique and Distinct

**RedRepublic01** · 04-17-2017, 01:12 AM

Hey, guys. Here's the picture of what I'm trying to do;

COLUMN 1 COLUMN 2
Company A
Company B
Company C

I need to use data validation for the COLUMN 2 values so that it would display only the UNIQUE values related to COLUMN 1 entities (I'm getting the data from a reference sheet - For example, company A has 5 countries (some repeating) in the reference sheet). I've recorded it manually however getting the source is kind of a challenge. I have no idea how to get the UNIQUE values into the choices for the data validation dropdowns.

Here's the code;

Please Login or Register  to view this content.

Thanks in advance!

**MarvinP** · 04-17-2017, 01:38 AM

Hi RedRepublic,

I did this problem this morning for another person. I think it is the same question. Look at this thread where Glenn and I answered it.

https://www.excelforum.com/excel-for...wing-list.html

If the above problem doesn't help then keep asking.

**RedRepublic01** · 04-17-2017, 01:49 AM

Hello MarvinP,

I've checked the macro and what it does is that it filters ALL unique values in a single column. However, what I need is to filter unique values in a single column that are related to a value in another column.

For example; (IN MY REFERENCE SHEET)

COLUMN1 COLUMN2
Company A Columbia
Company C Germany
Company B Columbia
Company A Mexico

What I'm having trouble with is extracting unique values in the COLUMN2 that are related to a certain value (ex, Company A)

(For some reason, the reply button isn't working so I used the quick reply)

Thanks anyway, MarvinP :D

**MarvinP** · 04-17-2017, 02:15 AM

OK RedRepublic,

I did a problem like this a week ago. The OP wanted to do similar things (I think). See the attached where I build a dropdown list using a double click event in column B. I used Dynamic Named Ranges to do this one.
See if this is close to what you need.

Cascading Dropdowns using Advanced Filter.xlsm

**sanram** · 04-17-2017, 02:26 AM

As you are using VBA so you may use combobox for that with below code :

Please Login or Register  to view this content.

**RedRepublic01** · 04-17-2017, 03:03 AM

Hi sanram,

I need to store the values in dynamic cells. I can't use a combobox for it.

@MarvinP,
I've been studying your latest xlsm and it's just what I needed. I'm going deeper into analyzing how it works and configuring it to suit my needs. A very big help indeed. Thanks so much! ^_^

**sanram** · 04-17-2017, 04:24 AM

You can link a combobox to a dynamic cell. So, it's no matter to store values in dynamic cells.

Data Validation SOURCE - Unique and Distinct

LinkBack

Thread Tools

Rate This Thread

Display

Data Validation SOURCE - Unique and Distinct

Re: Data Validation SOURCE - Unique and Distinct

Re: Data Validation SOURCE - Unique and Distinct

Re: Data Validation SOURCE - Unique and Distinct

Re: Data Validation SOURCE - Unique and Distinct

Re: Data Validation SOURCE - Unique and Distinct

Re: Data Validation SOURCE - Unique and Distinct

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] counting unique/distinct values (sample data attached)

Need to find unique value only from the source data

Multiple Unique Distinct Values from Multiple Columns of Data

unique distinct counts.

Need help in getting the unique distinct counts.

data validation-Can the source of the validation criteria be dfrom a different sheet?

Data Validation Returning only distinct values from a list

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions