Excel VBA - Naming Range - Has Duplicates. Consider only Unique Values and Name that Range

Dear all,

I'm facing an issue in Naming a Range.

Sample Data:
Grades

1
1
2
2
3
3

I would like to get the above values as:
1
2
3

Name the Range of Values (1,2,3) as "Grades".

Please see the below code which will print the unique values(here, grades) in column D.

Please Login or Register  to view this content.

PFA for reference.

I would like these unique values to be considered as a Range of Values and also Name that Range.

Note: Code to do the needful without Printing the unique values in a separate column.

Please let me know if this would be possible

Thanks,
Vinod Krishna

Dear TMS,

Well, I asked you one solution and you gave me three You simply exceed ones expectations

One small request:
How about modifying the above code in such a way that you don't print it in any of the columns?

Idea for possible Solution:
* Consider the Range of Values from A2 to Last Cell (Row wise).
* Store all the unique values into a Array, say UniqueGrades.
* Consider that Array as a Range
* Name that Range as "GradesList"

Please let me know if this would be possible

Regards,
Vinod Krishna

Dear TMS,

Thank you for trying your level best.

I guess its one of the drawbacks of Data Validation.

I will continue to use the above logic.

Will update on this post if I get to know of any Alternatives.

Please let us all know if you get to know of any Alternatives.

Thanks,
Vinod Krishna