ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Filtering changes in dates and Avg grades (https://www.excelbanter.com/excel-discussion-misc-queries/161573-filtering-changes-dates-avg-grades.html)

GeorgeC

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


All times are GMT +1. The time now is 11:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com