how do i remove 5 lowest scores?
 

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 do i remove 5 lowest scores?
 

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.

how do i remove 5 lowest scores?
 

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.

how do i remove 5 lowest scores?
 

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.

how do i remove 5 lowest scores?
 

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.

how do i remove 5 lowest scores?
 

=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.