Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
auto filter and auto fill
hi,
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 T. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I auto refresh a column that has an auto filter in place | Excel Discussion (Misc queries) | |||
Auto Count for Auto Filter Doesn't Function under certain circumst | Excel Discussion (Misc queries) | |||
Auto-populate, Auto-copy or Auto-fill? | Excel Worksheet Functions | |||
Auto Number the Rows of Auto Filter Result | Excel Discussion (Misc queries) | |||
I need a specific value in auto filter to fill a combo box and than match the select value in 2 other columns. | Excel Worksheet Functions |