Filter

  • Thread starter Thread starter Luciano
  • Start date Start date
L

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
 
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
 
Back
Top