Results 1 to 23 of 23

Thread: [resolved] Please help with VBA, for Excel 2007: working with objects

Threaded View

  1. #10

    Thread Starter
    New Member
    Join Date
    Jan 2012
    Posts
    12

    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
  •  



Click Here to Expand Forum to Full Width