i am very new to using excels, but have built a little tournament sheet. we
are holding 40 games in the tournament and are dropping the 5 lowest scores.
please help thankyou in advance.

How about ties or scores that appear more than once?
--
Gary''s Student


"bil-bil" wrote:

i am very new to using excels, but have built a little tournament sheet. we
are holding 40 games in the tournament and are dropping the 5 lowest scores.
please help thankyou in advance.

You might try using Excel's sort feature located on the Data menu.

Assuming that you have labels in row 1, click on any cell in row 1 and
select data... sort. It will bring up a dialog box of sorting criteria.

Regards...


"bil-bil" wrote:

i am very new to using excels, but have built a little tournament sheet. we
are holding 40 games in the tournament and are dropping the 5 lowest scores.
please help thankyou in advance.

try this idea. Be advised that it will also remove ties so you could remove
more than 5. Need a loop with a counter to avoid.

Sub showbottomfive()
Set myrng = Range("A2:a" & Cells(Rows.Count, "a").End(xlUp).Row)
With myrng
..AutoFilter Field:=1, Criteria1:="5", Operator:=xlBottom10Items
..SpecialCells(xlVisible).EntireRow.Delete
End With
End Sub

--
Don Guillett
SalesAid Software

"bil-bil" wrote in message
...
i am very new to using excels, but have built a little tournament sheet. we
are holding 40 games in the tournament and are dropping the 5 lowest
scores.
please help thankyou in advance.

Experiment with this
=SUM(A1:A100)-SUM(SMALL(A1:A100,{1,2,3,4,5}))
If a number occurs twice (as one of the lowest 5) it is discounted twice
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"bil-bil" wrote in message
...
i am very new to using excels, but have built a little tournament sheet. we
are holding 40 games in the tournament and are dropping the 5 lowest
scores.
please help thankyou in advance.

=SUM(LARGE(A1:A100,ROW(INDIRECT("1:"&COUNT(A1:A100 )-5))))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"bil-bil" wrote in message
...
i am very new to using excels, but have built a little tournament sheet.
we
are holding 40 games in the tournament and are dropping the 5 lowest
scores.
please help thankyou in advance.