striker13
Last Activity: May 20 '10, 10:26 PM
Joined: May 18 '10
Location:
-
Thousands and more thanks :D -
...Code:Sub keskmine3() Dim m As Long, n As Long, c As Range Range("l2").Activate ActiveCell.FormulaR1C1 = _ "=(RC[-9]+RC[-8]+RC[-7]+RC[-6]+RC[-5]+RC[-4]+RC[-3]+RC[-2]+RC[-1])/9" Range("L2").Select Selection.AutoFill Destination:=Range("L2:L33"), Type:=xlFillDefault Columns("L:L").Select Selection.NumberFormatLeave a comment:
-
What you mean where?
anyway, i managed to do some myself, but when it shows the highest average grade in messagebox, it does not use any commas " , " in numbers, so for example, average grade is 4,3 it shows as 43. And i also can't figure out, how to make it show the student's name.
I uploaded my excel file, so you can have a look at it:
http://www.upload.ee/files/574980/hinded.rar.html...Leave a comment:
-
sorting a list
I'm using VBA in Excel.
I have a list of students first and last names in A and B column, and grades in columns C to K. And i need to find the average of all of these students in column L. After i found the averages, i need to find the highest average grade and the students name who has this highest grade. if theres 2 or more with the same highest grade, then i need to find them all. the result should be displayed in an message box...
No activity results to display
Leave a comment: