Let me start you off. I had to add some dummy initials for surnames to make it work since you had left that blank. Play around with it and see if you can figure it out to suit your needs.

Attached Files

Analysis.xlsx (101.3 KB, 17 views)