Hi Everyone,

I'm trying to figure out how I can create a customized sort pattern for a card game macro I'm making.

As an example, in range A2:B6 is one player's hand. column A can have any of the following: " 9", " 10", " Q", " K", " A", " J" (padded with spaces for equal length and readability)
Column B can have any of the following: "Hearts", "Diamonds", "Clubs", "Spades"

I want to sort this range first by column B, then by column A. BUT--I don't want it alphabetic.

For column B, I want it to be sorted using the following: "Hearts" < "Diamonds" < "Clubs" < "Spades"
then column A: " 9" < " 10" < " Q" < " K" < " A" < " J"

What is the best way to go about doing this?

Thanks
Matt