Hi June7
Thanks very much for that. I tried running it and it sorted by suit first and then went Ace, 10,2,3,4 etc.

Hi p45cal
Thank you both of those worked well. I ran both of those samples and they both begin at 1 and sort first by Aces then 2,3,4 through 10,J,Q,K.

I am able to understand the code from June7 better, but I will now sit down and work through the samples from p45cal. This is the part I enjoy most when toying with formulas getting a better understanding.

Thank you both for your help
and best wishes for you and yours in the New Year.

Kisinana