I found Aladin Akyurek's formula very helpful, but Ola (?) suggestion sounds like what I really need although I don't understand quite what needs to be done.

I need to sort a table on the fly to determine 1st, 2nd, 3rd, etc. places, but by cub scout den, ie, Tiger Cub, Wolf, Bear, Webelo. I don't need the "st" etc solution suggested by Bob Phillips. This is need for a Pinewood Derby scoresheet.

The columns would be:

Car # ........ Name ........ Den ........ Rank
1 bob bear 58
2 ron cub 17
3 dave bear 60
4 bill bear 35
5 dakota cub 55
etc

Thanks for any ideas.

Ron

PS I will also post this as a new tread.