You add an extra column and use the group T1 , T2 etc. then when you sort you
use the grouping.

You probably need an extra column to give each row the sum of the scores

so if the sum of T1 is 20 T1 fred = 20 and T1 tom = 20 then when you sort
you can sort on the score and then the group.
--
Hope this helps
Martin Fishlock, www.nyfconsultants.com, Bangkok, Thailand
Please do not forget to rate this reply.


" wrote:

Martin. Not sure what you mean, how or where do I number the rows or
change the numbers that are already there
ps I can overcome my problem by transposing the information from each
row to another sheet by using the formular =IF(A1=0,A2,A1) and then
doing the countback sequence in this new sheet,and will do this if
necessary
Thanks EPJ

On Tue, 13 May 2008 03:38:09 -0700, Martin Fishlock
wrote:

Hello Jambun:

One method is to number the rows as pairs for example
T1 Fred 10 10 2 3
T1 Tom 5 2 3 1
T2 Sally
T2 June....

or use

1.1 Fred 10 10 2 3
1.2 Tom 5 2 3 1
2.1 Sally
2.2 June....

May work and is the easiest method. That is unless any one else knows
otherwise.