Hi all,
I have a range with a maximum of 3 distinct values. How can I extract these 1-3 values with VBA and sort them at the same time?
e.g.
Column A
SS17
SS17
SS17
SS18
SS18
SS18
SS19
SS19
Then I want my code to store these 3 values in ascending order and assign them to a variable.
![]()
Dim L1 As String Dim L2 As String Dim L3 As String L1 = "SS17" L2 = "SS18" L3 = "SS19"
Bookmarks