View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
GeorgeC GeorgeC is offline
external usenet poster
 
Posts: 1
Default Filtering changes in dates and Avg grades

Hello,


I was wondering if anyone can help me with this problem. I have a 3
columns:
Student Names, Dates, and Grades and I'm trying to filter out a way where I
can capture the changes in each grade for each student every 5+ months. For
example:

Student Name Dates Avg Grade
Bill 1-01-06 80
Bill 2-5-06 80
Bill 8-10-06 75
Bill 2-22-07 90

From the example, I basically I want to capture from 2-5-06 and 8-10-06,
Bill's grade dropped from 80 to 75.

Thanks