Hi,
I'd appreciate some help with the following: I've got monthly sheets with sports rankings. They look basically like:
------
June 2015
Name Ranking points
John Doe 500
James Doe 486
Earl Doe 866
Jenny Doe 855
Austin Powers 312

July 2015
Name Ranking points
John Doe 520
James Doe 496
Rick James 556
Jenny Doe 988
Austin Powers 102
-------
What I want to do is create a sheet like: (between june and july Earl left the series and Rick entered...nor the number of players or the names are always the same...roughly 95% are the same)

Ranking points
Name June July
John Doe 500 520
James Doe 486 496
Earl Doe 866
Jenny Doe 855 998
Austin Powers 312 102
Rick James 556


I want to do this to be able to compare individual trends and also between different clubs to see if some are on to something
The sport

Regards,
Mats