football form table from results

P

Peterfc2

Active Member
Joined
Jan 2, 2004
Messages
396
Office Version
  1. 2013
Platform
  1. Windows
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.
 
Sort by date Sort by votes
Sorry, I had been away doing some stuff. Glad it worked, Am sure we can expand on it and make it more elegant :)
 
Upvote 0

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
You must log in or register to reply here.

Similar threads

A
  • Question
Two dimensional dynamic named range over a pivot table not working as I thought
Replies
4
Views
415
ashleighbrown
A
J
  • Solved
Calculate last 5 soccer team goals using data from another sheet on same workbook.
2
Replies
19
Views
1K
felixstraube
F
A
  • Question
Sorting from the lowest to highest value
Replies
1
Views
103
dermie_72
D
willow1985
  • Solved
VBA Compile error - Trying to send an email using VBA/Excel
Replies
6
Views
613
gorgkhan
G
Chris_010101
  • Question
Weekly meeting tracker
Replies
6
Views
147
JerrExcel
JerrExcel

Forum statistics

Threads
1,216,098
Messages
6,128,812
Members
449,468
Latest member
AGreen17

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top