how do i remove 5 lowest scores?

B

bil-bil

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

ChristopherTri

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

Don Guillett

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
 
B

Bernard Liengme

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
 
B

Bob Phillips

=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)
 
Top