Advanced Group Filtering

[_____]

Hello All, I am having a bit of trouble developing a proper sort that I will eventually be turning into a macro in which data is sorted in order within its own sub-group and then those sub-groups are sorted by the lowest value in the subgroup in descending (A-->Z) order. The data is then outputted to as per the original data (i.e the output isn't a subgroup, it is the original data that has been simply sorted).
Here is an example of what I am talking about utilizing playing cards:

Playing Card Associated Number Card Suit Asociated Letter Associated Sort Number Ace 1 Hearts H 1 Two 2 Diamonds D 2 Three 3 Spades S 3 Four 4 Clubs C 4 Five 5 Six 6 Seven 7 Eight 8 Nine 9 Ten 10 Jack 11 Queen 12 King 13 <tbody> </tbody>

<tbody>
</tbody>

Sets of Suits Drawn Order Desired Suit Order Desired Overall Order D2 S1 Hearts S7 Hearts S4 H3 C8 H2 S6 H5 H2 H3 S7 H2 D13 H5 S10 H5 H2 Diamonds H2 Diamonds H3 D13 S4 D2 H5 D2 S1 D8 D2 D8 S10 D9 D8 D9 D9 D13 D9 D8 D13 Spades S6 Spades C8 S1 S1 S7 S4 S10 S6 S4 S7 S6 S10 Clubs Clubs C8 C8 <tbody> </tbody>

<tbody>
</tbody>

In this example the "Desired Suit Order" would be the sorting done into and within sub-groups and the "Desired Overall Order" is the desired results.

As can be seen the number of items in a group are dynamic. I would also like the number of sub-groups to be dynamic as well if, per this example, a 5th, 6th, etc. suit was added.

Any help / ideas are appreciated.

Thanks,

_____