gussi
08-10-2007, 02:37 AM
Hi guys,
I have a value Column(E) which i have sorted so biggest value is lowest in the sheet.
I use this to find the maximum value:
Set myrange2 = Worksheets("Sheet3").Range("E:E")
max1 = Application.WorksheetFunction.Max(myrange2)
So max1 is now my maximum value.
I have row of data from A:N so the problem is that i can maybe have 3 or 4 or... rows with the maximum value.
Now I need need something, loop i think, to find out those rows and then go to a blank cell in lowest row (O column) and SUM up column F in those rows where E is the maximum value..
:help
Regards,
Gussi
I have a value Column(E) which i have sorted so biggest value is lowest in the sheet.
I use this to find the maximum value:
Set myrange2 = Worksheets("Sheet3").Range("E:E")
max1 = Application.WorksheetFunction.Max(myrange2)
So max1 is now my maximum value.
I have row of data from A:N so the problem is that i can maybe have 3 or 4 or... rows with the maximum value.
Now I need need something, loop i think, to find out those rows and then go to a blank cell in lowest row (O column) and SUM up column F in those rows where E is the maximum value..
:help
Regards,
Gussi