Most valuable professional
  • Hot Topics

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 8, 2013.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel