Morning all,
I have a spreadsheet that I use to log football results for all the major European Leagues. All the results are contained within one sheet "SS Results" and then i have an "Overview" sheet which extracts and displays some elements of the data that I wish to see.
I am now wanting to add an extra three columns to the first table on the overview sheet. L6 (last 6), L6H (last 6 Home), L6A (last 6 away).
The new columns need to check the results sheet and count the number of times the "BTS" column = 1 for the relevant team.
Obvioulsy the parameters for each new column are slightly different - L6 needs to check the last 6 times the team played be it home or away - L6H needs to only check the last 6 times the team played at home - L6A (following a theme here) needs to check the last 6 aways.
I have been toiling with this for a few weeks now, reading forums, trying various examples i can find etc but being the excel novice that I am, I really am struggling. I wondered whether anybody had any ideas to help?
Bookmarks