Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
To sort data in VBA/excel by the method of the minimas
Hello,
Could somebody find a solution to my problem ? J Would like to sort datas(numbers) by the method of the minima. J have displayed 4 numbers of a table named Valnum. After this, I have added the following code : i = 1 For i = 1 To 4 minimum = Application.WorksheetFunction.Min(Valnum) Worksheets(1).Cells(2,i).Value = Valnum(i) Worksheets(1).Cells(1,i).Clear Worksheets(1).Cells(1,i).Value = Worksheets _ (1).Cells(1,i+1).Value Worksheets(1).Cells(1,i+1).Clear Worksheets(1).Cells(1,i+1).Value = Valnum(i) Worksheets(1).Cells(2,i).Clear i = i + 1 Next i I would like to use Min in a table of 4 elements, of 3 elements,of 2 , of 1, but I don't know precisely how to do. Thank you in advance for all of you who could help me in the resolution of my problem. Jean-michel .. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
To sort data in VBA/excel by the method of the minimas
Jean-mi wrote:
Could somebody find a solution to my problem ? J Would like to sort datas(numbers) by the method of the minima. Not sure I follow your question, but if the numbers are in the spreadsheet why not use Excel to sort them. Record a macro while doing Data / Sort on the cells concerned and you should be most of the way there. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - reply in newsgroup |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need really fast method to sort data for my part numbering spread | Excel Discussion (Misc queries) | |||
Please post this thread a correct full method, method about | New Users to Excel | |||
VBA Sort method w/more than 3 Keys | Excel Discussion (Misc queries) | |||
sort method frustration | Excel Programming | |||
Sort method of range | Excel Programming |