Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
auto fill columns
hi all,
i have an excel sheet with student's grades: column A has an icreasing number, column B has the name , column C has the class, column D has the grade. I would like if it is posssible when i filter the students by class at the end of the sheet to be added two columns automatically [with macro, code?? i dont know how :-( ] the first one write if the student is 1st, 2nd, 3rd, etc in the class depending on the grade (column D) and the second column write if the grade is lower than 5 the student pass or fail! Is possible the column A when i use the filter to change in a number that is the first row affected has 1, the second 2, etc? if yes how? thanks in advanced, Stelios |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking columns for auto fill | Excel Discussion (Misc queries) | |||
I need to Auto Fill columns with data | Excel Discussion (Misc queries) | |||
linking columns for auto fill-in | New Users to Excel | |||
Protecting and Auto fill Columns | Excel Worksheet Functions | |||
Auto fill of columns | Excel Discussion (Misc queries) |