View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

Hi Dennis,

Try this

Sub test()
Dim rng As Range
Dim iRow As Long
Dim i As Long

Set rng = Selection
For i = 1 To 3
iRow = Application.Match(Application.Small(rng, 1), rng, 0)
Cells(iRow, rng.Column).EntireRow.Delete
Next i

End Sub


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Dennis" wrote in message
m...
I have a list in B2 thru B11 which includes in this order.... 15 10 48 16

27
8 2 21 10 60

What I woujld like to do is highlight the range and have the 3 lowest

numbers
deleted, but I dont want them sorted first, the remaining 7 must stay in

the
original cells. Here's where it gets tricky, because 10 is one of the

lowest 3
and there are 2 10's, I want to keep one of the 10's (it doesn't matter

which
one). So after all is done I would be left with 15 48 16 27 21 10

60

TIA, Dennis
================