auto fill

[stelios]

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.

 

[Dave Peterson]

How about just adding two columns that are always populated with the info. When
you filter on the name, that info will still be visible.

It sounds like your grades are numeric.

There's worksheet function called =rank() that can, er, rank each value. Take a
look at help for more info.

And I think that for the final formula, you could just use something like:

=if(d2<5,"Fail","Pass")

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.