Hi All,

I have a trouble with Rank() function. I have written normal rank function
based on "Average" column and working fine. But I need the rank based on the
"result" which ignore the averages of "fail" sting in Result column. I need
the result in "Rank" column as below:


Student name sub1 sub2 sub3 Result Average Rank
A 36 54 78 PASS 56.00 2
B 66 25 54 FAIL 48.33 N/A
C 45 36 65 PASS 48.67 3
D 12 45 45 FAIL 34.00 N/A
E 78 78 54 PASS 70.00 1

Here, the rank function ingnore the averages of fail students and rank will
calculate on only pass students.
Please suggest me in this regard.


Narendar