software

In excel office 2003. I am entering a large number of numerical scores for
different individuals plus a few alpha digits NR, DQ etc. I want to sort the
scores in descending order left to right BUT also keep the alpha digits on
the right?
I then want to total the best 12 scores from each individual so as to
produce a positional league table from those totals. Can anyone help !!Let's clarify - are you saying that each cell will contain BOTH numbers and
alphas?

quot;Derickquot; wrote:

gt; In excel office 2003. I am entering a large number of numerical scores for
gt; different individuals plus a few alpha digits NR, DQ etc. I want to sort the
gt; scores in descending order left to right BUT also keep the alpha digits on
gt; the right?
gt; I then want to total the best 12 scores from each individual so as to
gt; produce a positional league table from those totals. Can anyone help !!
gt;

No one value each cell the NR (not returned) DQ (disqualified) occupy their
own cells. When I sort the data descending the alphas move to the left which
makes selecting the best 12 scores an uneven selection
NR NR DQ 36 35 32
NR 36 35 32 33 ETC

quot;Duke Careyquot; wrote:

gt; Let's clarify - are you saying that each cell will contain BOTH numbers and
gt; alphas?
gt;
gt; quot;Derickquot; wrote:
gt;
gt; gt; In excel office 2003. I am entering a large number of numerical scores for
gt; gt; different individuals plus a few alpha digits NR, DQ etc. I want to sort the
gt; gt; scores in descending order left to right BUT also keep the alpha digits on
gt; gt; the right?
gt; gt; I then want to total the best 12 scores from each individual so as to
gt; gt; produce a positional league table from those totals. Can anyone help !!
gt; gt;

What are you doing with the 12 best scores? Summing them? Or do you need to
present each of them elsewhere?

If it's a sum, you can use this array formula - entered by pressing
Ctrl-Shift-Enter

=sum(large(scores range,row(1:12)))

if you need to extract the 12 best individual scores, you can use 12 of
these formulas (not array formulas - enter them normally)

=large(scores range,n)
where n = 1 thru 12
quot;Derickquot; wrote:

gt; No one value each cell the NR (not returned) DQ (disqualified) occupy their
gt; own cells. When I sort the data descending the alphas move to the left which
gt; makes selecting the best 12 scores an uneven selection
gt; NR NR DQ 36 35 32
gt; NR 36 35 32 33 ETC
gt;
gt; quot;Duke Careyquot; wrote:
gt;
gt; gt; Let's clarify - are you saying that each cell will contain BOTH numbers and
gt; gt; alphas?
gt; gt;
gt; gt; quot;Derickquot; wrote:
gt; gt;
gt; gt; gt; In excel office 2003. I am entering a large number of numerical scores for
gt; gt; gt; different individuals plus a few alpha digits NR, DQ etc. I want to sort the
gt; gt; gt; scores in descending order left to right BUT also keep the alpha digits on
gt; gt; gt; the right?
gt; gt; gt; I then want to total the best 12 scores from each individual so as to
gt; gt; gt; produce a positional league table from those totals. Can anyone help !!
gt; gt; gt;



quot;Duke Careyquot; wrote:

gt; What are you doing with the 12 best scores? Summing them? Or do you need to
gt; present each of them elsewhere?
gt;
gt; If it's a sum, you can use this array formula - entered by pressing
gt; Ctrl-Shift-Enter
gt;
gt; =sum(large(scores range,row(1:12)))
gt;
gt; if you need to extract the 12 best individual scores, you can use 12 of
gt; these formulas (not array formulas - enter them normally)
gt;
gt; =large(scores range,n)
gt; where n = 1 thru 12
gt;
gt;
gt;
gt;
gt;
gt;
gt; quot;Derickquot; wrote:
gt;
gt; gt; No one value each cell the NR (not returned) DQ (disqualified) occupy their
gt; gt; own cells. When I sort the data descending the alphas move to the left which
gt; gt; makes selecting the best 12 scores an uneven selection
gt; gt; NR NR DQ 36 35 32
gt; gt; NR 36 35 32 33 ETC
gt; gt;
gt; gt; quot;Duke Careyquot; wrote:
gt; gt;
gt; gt; gt; Let's clarify - are you saying that each cell will contain BOTH numbers and
gt; gt; gt; alphas?
gt; gt; gt;
gt; gt; gt; quot;Derickquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; In excel office 2003. I am entering a large number of numerical scores for
gt; gt; gt; gt; different individuals plus a few alpha digits NR, DQ etc. I want to sort the
gt; gt; gt; gt; scores in descending order left to right BUT also keep the alpha digits on
gt; gt; gt; gt; the right?
gt; gt; gt; gt; I then want to total the best 12 scores from each individual so as to
gt; gt; gt; gt; produce a positional league table from those totals. Can anyone help !!
gt; gt; gt; gt;

Sorry I seem to have resent a previous reply.
Thanks for the help I will try the array etc and let you know. I have been
sorting each row individually then using the basic formula =sum (range 1:12)
and copying it into the 60 other 'total' cells. The sorting has been taking
forever - row by row then moving the 'alphas' back to the right. regards

quot;Duke Careyquot; wrote:

gt; What are you doing with the 12 best scores? Summing them? Or do you need to
gt; present each of them elsewhere?
gt;
gt; If it's a sum, you can use this array formula - entered by pressing
gt; Ctrl-Shift-Enter
gt;
gt; =sum(large(scores range,row(1:12)))
gt;
gt; if you need to extract the 12 best individual scores, you can use 12 of
gt; these formulas (not array formulas - enter them normally)
gt;
gt; =large(scores range,n)
gt; where n = 1 thru 12
gt;
gt;
gt;
gt;
gt;
gt;
gt; quot;Derickquot; wrote:
gt;
gt; gt; No one value each cell the NR (not returned) DQ (disqualified) occupy their
gt; gt; own cells. When I sort the data descending the alphas move to the left which
gt; gt; makes selecting the best 12 scores an uneven selection
gt; gt; NR NR DQ 36 35 32
gt; gt; NR 36 35 32 33 ETC
gt; gt;
gt; gt; quot;Duke Careyquot; wrote:
gt; gt;
gt; gt; gt; Let's clarify - are you saying that each cell will contain BOTH numbers and
gt; gt; gt; alphas?
gt; gt; gt;
gt; gt; gt; quot;Derickquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; In excel office 2003. I am entering a large number of numerical scores for
gt; gt; gt; gt; different individuals plus a few alpha digits NR, DQ etc. I want to sort the
gt; gt; gt; gt; scores in descending order left to right BUT also keep the alpha digits on
gt; gt; gt; gt; the right?
gt; gt; gt; gt; I then want to total the best 12 scores from each individual so as to
gt; gt; gt; gt; produce a positional league table from those totals. Can anyone help !!
gt; gt; gt; gt;