|
-
Feb 6th, 2012, 02:38 PM
#10
Thread Starter
New Member
Re: Please help with VBA, for Excel 2007: working with objects
That's perfect, thanks!
I'm also wondering about how to improve the codes I wrote so that it would display the list of numbers in a sorted manner according to the amount it appears in the array where the data was drawn from.
example:
What my codes in previous post does (listed in a column):
123 (2), 234(3), 345 (1)
234 (4), 345 (1)
123 (1), 345 (4)
Internally it converts it into an array that is a mixture that contains 3 of "123", 7 of "234", and 6 of "345".
And then outputs:
123 (3), 234 (7), 345 (6)
Would be great if its output could be sorted as such:
234 (7), 345 (6), 123 (3)
P.S. Is there a name to this type of sorting in computer science?
Could you help me with this again? Thank you so much!
Last edited by needhelpooo; Feb 6th, 2012 at 02:55 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|