Filter

[Luciano]

Hi,
I have a table.One cloumn(D) is a list of student's first exam
grades.Another column(E) is a list of student's second exam grades.I
want to filter the students whose first exam grades are bigger than
second exam grades?
Thanks

 

[drabbacs]

One way. In an arbitrary column (say column F) next to the
data type

= if(D2>E2,1,0) and drag the formula down as far as
necessary. Also, change D2 and E2 to the row number of the
first studen't grades.

Then autofilter again. In the new column (F) filter for
the value 1.

Good Luck

 

[Luciano]

Thanks

It worked well !