Thread: Sort issue
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
libby libby is offline
external usenet poster
 
Posts: 96
Default Sort issue

Hi

See if this helps

Assuming the first of your numbers is in the cell D4

Dim rngend
rngend = Range("D4").End(xlDown).Address
Range("D4:" & rngend).Sort Key1:=Range("D4"), _
Order1:=xlDescending

Dim i As Integer
For i = 4 To 8
If Range("d" & i).Value = Range("d" & i) _
..Offset(1, 0).Value Then
Range("d" & i).End(xlDown).Offset(1, 0) = Range("d" & i)
Range("d" & i).Delete shift:=xlUp
End If
Next
End Sub

-----Original Message-----
I have a sorting issue that I need help with, I do not
know if it is possible to do this and I have tried a ton
of different things, so I decided to see if anyone out
here has an idea.

I have 5 Random numbers (ie.(1-5-4-6-6, 5-5-5-3-6)) I

want
to put these in order from high to low (sort decending),
but if the number is displayed more than once i want to
push it to the bottom or the string to look like this (6-

5-
4-6-1, 6-5-3-5-5)???

Any ideas if this is possible?
Patty

.