Football form

[AnushPatel]

Hello friends,

If you look at the attachment, I want to transpose the 'Raw Data' sheet into the 'Form' sheet using the Arsenal format as an example (last 6 games).

Any help appreciated.

Thanks

Anush

[samba_ravi]

what you entered in Form sheet is correct? as per data last game was "D"?

[samba_ravi]

See the attached file

[AnushPatel]

Great work Siva . FYI - the example i gave in the Form tab didn't necessarily reflect the raw data. I just entered random letters.

Question - if I add new rows to the raw data sheet as and when future results come through, will the Form tab continue to reflect the last 6 games?

Thanks!

[samba_ravi]

Yes, just simply edit the range as required