Tech Support Guy banner
Status
Not open for further replies.
1 - 8 of 8 Posts

·
Registered
Joined
·
75 Posts
Discussion Starter · #1 ·
I need a VBA code to take the list of follower numbers and separate them into tiers.
For example, using #768, it would have to recognise that 768,678,867,876 are
all variations of the same # and list all #'s with 4 variations first, 3 variations ,
2 variations, and last all single #'s
In real life I would like it to list all 6 # 's ,then 5's, then 4's,then 3's, then 2's, then singles.
Not to start at 4 like the example.
There could also be many more followers than in the example also.
See example worksheet below to understand what I am trying to do.
 

·
Registered
Joined
·
4,936 Posts
I'm confused by what you are trying to accomplish. In your example above there are more than 4 combinations. Will the follower numbers always be 3 digits long? If the follower number is 3 digits long and each number is unique, there will always be 6 possible combination. If two of the numbers are the same and the third is unique the will always be 3 combinations.

768
786
867
876
687
678


Regards,
Rollin
 

·
Registered
Joined
·
75 Posts
Discussion Starter · #7 ·
Rollin,
Yes, all followers will be 3 digits long. I would like to search the list of followers and then make a list of all numbers starting with all numbers with all 6 variations.
768 786 876 876 687 678
123 132 213 231 312 321
etc...
then all numbers with 5 variations
234 243 324 342 423
012 021 102 120 210
etc...
then all numbers with 4 variations
then all numbers with 3 variations
then all numbers with 2 variation
and lastly all single numbers with no variations. I will attach another example that better shows how I would like them listed.
I keep trying to upload an example but it's not working. PM me your e-mail if you want and I will I e-mail you a copy
 

·
Registered
Joined
·
4,936 Posts
budward said:
then all numbers with 5 variations
234 243 324 342 423
012 021 102 120 210
etc...
In your example above you imply that there are 5 variations to the numbers. Unless I am understanding incorrectly I see 6 variations.

234 243 324 342 423 -----> 432
012 021 102 120 210 -----> 201

You can email me at Rollin_Again at hotmail dot com

Regards,
Rollin
 
1 - 8 of 8 Posts
Status
Not open for further replies.
Top