VBA Code needed

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

budward

Thread Starter
Joined
Oct 27, 2006
Messages
75
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.
 
Joined
Sep 4, 2003
Messages
4,912
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
 

budward

Thread Starter
Joined
Oct 27, 2006
Messages
75
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
 
Joined
Sep 4, 2003
Messages
4,912
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
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top