Need to Sum one column for each row that is part of a group and then filter out dups

[kukarooza]

I have around 53,000 rows of data with columns A-I. The first five row
for example have data for a particular student... STUDENT A. Rows
through 15 have data about another student... STUDENT B, and so forth


Each column per student has the same data in it with the exception o
the last column, column I. Column I has the students GPA (Grade Poin
Averages) in it per row.

So, for example, STUDENT A might have a GPA in row 1 of 4.0, a GPA i
row 2 of 2.5, a GPA in row 3 of 4.0, a GPA in row 4 of 3.0, and a GP
in row 5 of 4.0.

Since all data in the rows for each person has the same data in the
(with the exception of column 5), I want to get rid of the duplicat
rows per person. I want the one row that's left to represent eac
person to show an average GPA of all the GPA's that were listed fo
that particular student, before the duplicates were removed.

For example,

STUDENT 1
Row 1 GPA (in column I) is 4.0
Row 2 GPA (in column I) is 2.5
Row 3 GPA (in column I) is 4.0
Row 4 GPA (in column I) is 3.0
Row 5 GPA (in column I) is 4.0

I need to remove filter out rows 2-5 and have only one row representin
the student. In that row, (in column I) I need the number for GPA to b
an average of what was listed in I1-I5... or 3.5 in this example.

When I filter out duplicate data, I'm currently getting the one row I'
looking for, but that row only lists the 4.0 number that was listed i
the first column of the student group of rows.

Is it possible to filter out duplicate rows and place a formula in th
row that's left for each student that will give the average of all th
rows that were originally showing for that person?

Thanks in advance