Excel: football form table from results

http://www.blueswayedviews.co.uk/peterfc2/capture1.jpg Look at the link please. What I want to happen is it to fill the data in the yellow area. i.e. Tom has played 3 game giving W W L. (I've typed this data in to show I want.) Anyone know how this can be done please. Tried index match but failed to sort it out.

This question generated 21 answers. To proceed to the answers, click here.

This thread is current as of November 08, 2013.

For more resources for Microsoft Excel