PS. You may want to look at =rank(). You wouldn't have to even sort the data
to do the ranking.

Dave Peterson wrote:

Glad you got it working the way you want.

Saxman wrote:

Dave Peterson wrote:
Or you could just do all the sorts at once:

That works beautifully! Exactly what I wanted.

I can do another macro for calculations and combine them into one.

I see that you are a 'dab hand' at this kind of thing during my searches.

I do have a good book on Excel VBA, but books usually cover common
things like formatting.

I am most grateful to you.

John (Essex, UK).

--

Dave Peterson

--

Dave Peterson