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