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.
Please Login or Register to view this content.
Not sure if this is what you mean...
Please Login or Register to view this content.
Last edited by Sintek; 09-26-2018 at 07:26 AM.
Good Luck...
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
Also....Add a comment if you like!!!!
And remember...Mark Thread as Solved...
Excel Forum Rocks!!!
hmm... this doesn't seem to be feasible in my data set as I am already using a filter. Also, I need to assign the 3 values to 3 different variables as I am using it for something else within my code.
Last edited by esbencito; 09-26-2018 at 11:09 PM.
Try to use formula
Enter in B2 and copy down
Formula:
Please Login or Register to view this content.
v A B 1 2 SS17 SS17 3 SS17 SS18 4 SS17 SS19 5 SS18 6 SS18 7 SS18 8 SS19 9 SS19
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Please Login or Register to view this content.
Ben Van Johnson
Obviously you would have had to make changes to accommodate your data sethmm... this doesn't seem to be feasible in my data set
Please Login or Register to view this content.
Thanks all! I ended up with a mix of both solutions and it seems to work just fine!
Didn't know that the advanced filter method is common to use in VBA to find unique values. It's probably even a lot faster than some of the other array calculations...Please Login or Register to view this content.
Last edited by esbencito; 09-27-2018 at 01:40 AM.
Originally Posted by AlKey
Try to use formula
Enter in B2 and copy down
Formula:Please Login or Register to view this content.
v A B 1 2 SS17 SS17 3 SS17 SS18 4 SS17 SS19 5 SS18 6 SS18 7 SS18 8 SS19 9 SS19
*deleted.. apologies
Last edited by EXCELBENCH; 09-30-2018 at 12:24 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks