Create a Distinct Unique list for 2 Columns

Hello,

So far I created code that creates a Distinct Unique item's list for one column. It works as it should but I want to modify the code to create a Distinct Unique item's list for two columns that are related to another i.e. a person's name to their license #.
Here is the code below that works for one column only:

Please Login or Register  to view this content.

I would really like it to work for two columns and have the data spit out in columns starting E2 to F (whatever the last row would be). So if I had the code right for two columns i.e. license # would always match up with the right name.

Thanks,

Bc

You need to change the columns to suite your need.

Please Login or Register  to view this content.

Hi AB33,

The code you suggested combines the output in one column which is not correct. I want it to spit the data out in 2 columns i.e. for example license # would be spit out in E and person's name in column F. The columns are related so amount of items should be the same just in separate columns. Also in your code I changed "E2:F" to "C2:D" because that's where the data starts. It should get spit out to E2:F.

- let me know if this makes sense

I assumed you want to the keys based on two columns, but this might not be the case.
I do not know which one you want to split up, but if you want to display the keys and items on two different columns.

Please Login or Register  to view this content.

AB33,

I see what you are saying...Here is what I have....

In Column C I have "license #'s" and in Column D I have "names". When the list is created the license #'s in Column C will populated in Column E and the names will be populated separately in Column F. Right now I get the concatenation of both C and D in Column E, not what I am looking for. I want those separated, license #'s in E and names in F.

I also want to say thank you for your time.

-bc

boldcode,
Please attach a sample as it would be easily to see and test it.

AB33,

Here is the example attached. The macro name in the attached workbook is "test" and you can run it in the worksheet "TestSheet". The other two worksheets in the workbook just describe what the macro is doing now (worksheet: ResultsNow) and what I would like the macro to do (worksheet: ResultsWanted).

Thanks again.

Try the attached.

Boldcode,
You are welcome!