Determining How Often A Data Point Increases

Hi everyone!

Sorry for the really terrible thread title. I have a question and I have no idea where to start to figure out the solution.

I have a spread sheet that contains PINs, a test score, and a date for when the test was taken and for most students I have two test scores taken on two different dates. Basically, the table looks like this:

PIN	Score	Date
001	88	April 1
001	93	November 1
002	77	May 1
002	81	October 1
003	65	June 1
003	55	July 1

Ultimately what I'm trying to figure out is what percentage of students got a higher score the second time they took the test. All students have taken the test twice, but some have taken it three or four times as well.

Does anyone know how I can go about figuring this out? Any advice would be awesome!

just lookup