Is it possible to divide 2 numbers and round the result in the same cell?
Never mind, I found the solution at MrExcel.com.
Thanks anyway.
Mallard wrote:Are you trying sort each row individually from left to right?
If so, you would need a macro to do it or do each row manually one at a time.
Hi Padawanlotto
Are you trying sort each row individually from left to right?
If so, you would need a macro to do it or do each row manually one at a time.
this worked for me:
Just create your own Macro as follows .............
Sub sortData()
Dim r As Range, cell As Range, r1 As Range
Set r = Range(Cells(1, 1), Cells(Rows.Count, 1).End(xlUp))
For Each cell In r
Set r1 = cell.Resize(1, 6)
r1.Sort Key1:=r1, _
Order1:=xlAscending, _
Orientation:=xlSortRows
Next
End Sub
this assumes your data starts in A1.
Bobijohn wrote:Hi PadwanLotto
You may find the attached text file helpful. I copied this to myself several years ago and used it extensively in Excel 2003.
Pay particular attention to to the last main paragraph to do multiple rows using the "small" function.
Ofcourse, credit to the original poster.
Cheers
Users browsing this forum: No registered users and 5 guests